I am manager at a game store, and I need to know the genre and reference number of the game with the highest existing stock among those named game title 142. I also need the genre and reference number of the game with the lowest existing stock among games with the same name.
I am manager at a game store, and I need to know the genre and reference number of the game with the highest existing stock among those named game title 142. I also need the genre and reference number of the game with the lowest existing stock among games with the same name.
---
name: workspace-filesystem
description: The virtual filesystem layout of this workspace.
---
# Virtual Filesystem
You work in a terminal over a virtual filesystem. Read files with shell
commands.
Command output comes back whole, however long. Some files here are large,
so point `grep -r`, `rg`, `find` and `cat` at the directory or file you
need rather than at a whole mount.
| path | what it is |
|---|---|
| `/mongodb` | Your MongoDB databases, read-only; change them with the `mongodb` CLI. |
| `/tmp` | Scratch space, in memory. |
## `/mongodb`
```
/mongodb/
<database>/
database.json
collections/
<collection>/
schema.json
documents.jsonl
views/
<view>/
schema.json
documents.jsonl
```
- `database.json`: `{database: str, collections: list[{name: str}],
views: list[{name: str}]}`
- `schema.json`: `{database: str, name: str, kind: str, validator: dict |
null, fields: list[{path: str, presence: number, types: dict}],
primary_key: str, indexes: list[{name: str, keys: dict, type: str}],
sampled: int}`, read from a sample of `sampled` documents
- `documents.jsonl`: one document per line, in MongoDB Extended JSON: a date
reads as `{"$date": "..."}`| name | workspace-filesystem |
|---|---|
| description | The virtual filesystem layout of this workspace. |
Virtual Filesystem
You work in a terminal over a virtual filesystem. Read files with shell commands.
Command output comes back whole, however long. Some files here are large, so point grep -r, rg, find and cat at the directory or file you need rather than at a whole mount.
| path | what it is |
|---|---|
/mongodb | Your MongoDB databases, read-only; change them with the mongodb CLI. |
/tmp | Scratch space, in memory. |
/mongodb
/mongodb/
<database>/
database.json
collections/
<collection>/
schema.json
documents.jsonl
views/
<view>/
schema.json
documents.jsonldatabase.json: {database: str, collections: list[{name: str}], views: list[{name: str}]}schema.json: {database: str, name: str, kind: str, validator: dict | null, fields: list[{path: str, presence: number, types: dict}], primary_key: str, indexes: list[{name: str, keys: dict, type: str}], sampled: int}, read from a sample of sampled documentsdocuments.jsonl: one document per line, in MongoDB Extended JSON: a date reads as {"$date": "..."}---
name: workspace-commands
description: Use when running commands in this workspace - which commands exist, what they can do, and what the interpreter supports.
---
# Available commands
Python (`python` or `python3`), Perl, JavaScript/Node.js, and TypeScript
runtimes are unavailable. Use the shell commands and task CLIs documented
below; do not probe for or attempt to install other runtimes.
Standard Unix commands, among them:
cat head tail ls find grep wc sort uniq cut tr sed awk
diff tee xargs jq
with pipes, `>` redirection and `$(...)` substitution.
Do not probe the machine with `which`, `type`, `--version`, `env`, `ps`,
`echo $PATH`, `ls /usr/bin` or `cat /usr/bin/<command>`: they tell you
nothing about the task.
A filename with a space in it needs quoting, as it would in any shell.
## mongodb
Use `mongodb <command> '<JSON arguments>'`. Run `mongodb <command> --help`
to get more information.
```sh
mongodb list-collections '{"database":"DATABASE"}'
mongodb list-databases '{}'
mongodb collection-indexes '{"database":"DATABASE","collection":"COLLECTION"}'
mongodb collection-schema '{"database":"DATABASE","collection":"COLLECTION"}'
mongodb find '{"database":"DATABASE","collection":"COLLECTION","filter":{"FIELD":"VALUE"},"limit":10}'
mongodb collection-storage-size '{"database":"DATABASE","collection":"COLLECTION"}'
mongodb count '{"database":"DATABASE","collection":"COLLECTION","query":{"FIELD":"VALUE"}}'
mongodb db-stats '{"database":"DATABASE"}'
mongodb aggregate '{"database":"DATABASE","collection":"COLLECTION","pipeline":[{"$group":{"_id":"$FIELD","total":{"$sum":1}}}]}'
mongodb explain '{"database":"DATABASE","collection":"COLLECTION","method":[{"name":"find","arguments":{"filter":{"FIELD":"VALUE"}}}]}'
```
| Command | Arguments | Description |
|---|---|---|
| `mongodb list-collections` | `{database: str}` | List all collections for a given database |
| `mongodb list-databases` | `{}` | List all databases for a MongoDB connection |
| `mongodb collection-indexes` | `{database: str, collection: str}` | Describe the indexes for a collection |
| `mongodb collection-schema` | `{database: str, collection: str}` | Describe the schema for a collection |
| `mongodb find` | `{database: str, collection: str, filter?: dict, projection?: dict, limit?: number = 10, sort?: dict}` | Run a find query against a MongoDB collection |
| `mongodb collection-storage-size` | `{database: str, collection: str}` | Gets the size of the collection |
| `mongodb count` | `{database: str, collection: str, query?: dict}` | Gets the number of documents in a MongoDB collection using db.collection.count() and query as an optional filter parameter |
| `mongodb db-stats` | `{database: str}` | Returns statistics that reflect the use state of a single database |
| `mongodb aggregate` | `{database: str, collection: str, pipeline: list[dict]}` | Run an aggregation against a MongoDB collection |
| `mongodb explain` | `{database: str, collection: str, method: list[{name: str, arguments: dict}]}` | Returns statistics describing the execution of the winning plan chosen by the query optimizer for the evaluated method |
## airtable
Use `airtable <command> '<JSON arguments>'`. Run `airtable <command> --help`
to get more information.
```sh
airtable get-record '{"base_id":"BASE_ID","table_name":"TABLE","record_id":"RECORD_ID"}'
```
| Command | Arguments | Description |
|---|---|---|
| `airtable get-record` | `{base_id: str, table_name: str, record_id: str}` | Get a single record by its ID |
## wikipedia
Use `wikipedia <command> '<JSON arguments>'`. Run
`wikipedia <command> --help` to get more information.
```sh
wikipedia search-wikipedia '{"query":"QUERY"}'
wikipedia get-article '{"title":"TITLE"}'
```
| Command | Arguments | Description |
|---|---|---|
| `wikipedia search-wikipedia` | `{query: str, limit?: int = 10}` | Search Wikipedia for articles matching a query. |
| `wikipedia get-article` | `{title: str}` | Get the full content of a Wikipedia article. || name | workspace-commands |
|---|---|
| description | Use when running commands in this workspace - which commands exist, what they can do, and what the interpreter supports. |
Available commands
Python (python or python3), Perl, JavaScript/Node.js, and TypeScript runtimes are unavailable. Use the shell commands and task CLIs documented below; do not probe for or attempt to install other runtimes.
Standard Unix commands, among them:
cat head tail ls find grep wc sort uniq cut tr sed awk
diff tee xargs jqwith pipes, > redirection and $(...) substitution.
Do not probe the machine with which, type, --version, env, ps, echo $PATH, ls /usr/bin or cat /usr/bin/<command>: they tell you nothing about the task.
A filename with a space in it needs quoting, as it would in any shell.
mongodb
Use mongodb <command> '<JSON arguments>'. Run mongodb <command> --help to get more information.
mongodb list-collections '{"database":"DATABASE"}'
mongodb list-databases '{}'
mongodb collection-indexes '{"database":"DATABASE","collection":"COLLECTION"}'
mongodb collection-schema '{"database":"DATABASE","collection":"COLLECTION"}'
mongodb find '{"database":"DATABASE","collection":"COLLECTION","filter":{"FIELD":"VALUE"},"limit":10}'
mongodb collection-storage-size '{"database":"DATABASE","collection":"COLLECTION"}'
mongodb count '{"database":"DATABASE","collection":"COLLECTION","query":{"FIELD":"VALUE"}}'
mongodb db-stats '{"database":"DATABASE"}'
mongodb aggregate '{"database":"DATABASE","collection":"COLLECTION","pipeline":[{"$group":{"_id":"$FIELD","total":{"$sum":1}}}]}'
mongodb explain '{"database":"DATABASE","collection":"COLLECTION","method":[{"name":"find","arguments":{"filter":{"FIELD":"VALUE"}}}]}'| Command | Arguments | Description |
|---|---|---|
mongodb list-collections | {database: str} | List all collections for a given database |
mongodb list-databases | {} | List all databases for a MongoDB connection |
mongodb collection-indexes | {database: str, collection: str} | Describe the indexes for a collection |
mongodb collection-schema | {database: str, collection: str} | Describe the schema for a collection |
mongodb find | {database: str, collection: str, filter?: dict, projection?: dict, limit?: number = 10, sort?: dict} | Run a find query against a MongoDB collection |
mongodb collection-storage-size | {database: str, collection: str} | Gets the size of the collection |
mongodb count | {database: str, collection: str, query?: dict} | Gets the number of documents in a MongoDB collection using db.collection.count() and query as an optional filter parameter |
mongodb db-stats | {database: str} | Returns statistics that reflect the use state of a single database |
mongodb aggregate | {database: str, collection: str, pipeline: list[dict]} | Run an aggregation against a MongoDB collection |
mongodb explain | {database: str, collection: str, method: list[{name: str, arguments: dict}]} | Returns statistics describing the execution of the winning plan chosen by the query optimizer for the evaluated method |
airtable
Use airtable <command> '<JSON arguments>'. Run airtable <command> --help to get more information.
airtable get-record '{"base_id":"BASE_ID","table_name":"TABLE","record_id":"RECORD_ID"}'| Command | Arguments | Description |
|---|---|---|
airtable get-record | {base_id: str, table_name: str, record_id: str} | Get a single record by its ID |
wikipedia
Use wikipedia <command> '<JSON arguments>'. Run wikipedia <command> --help to get more information.
wikipedia search-wikipedia '{"query":"QUERY"}'
wikipedia get-article '{"title":"TITLE"}'| Command | Arguments | Description |
|---|---|---|
wikipedia search-wikipedia | {query: str, limit?: int = 10} | Search Wikipedia for articles matching a query. |
wikipedia get-article | {title: str} | Get the full content of a Wikipedia article. |
| Model | VFS | MCP | VFS Tokens | MCP Tokens | Token Reduction Rate |
|---|---|---|---|---|---|
| Claude Opus 5.5 | 1/1 | 1/1 | 11.2k | 19.0k | 41% |
| GPT-6.1 Sol | 1/1 | 1/1 | 9.04k | 6.46k | −40% |
| GPT-5.6 Luna | 1/1 | 1/1 | 11.6k | 9.33k | −24% |
| Claude Haiku 5.5 | 1/1 | 1/1 | 33.7k | 31.6k | −7% |
| Gemini 3.8 Flash | 1/1 | 1/1 | 309k | 70.1k | −340% |