Tools Reference¶

The MCP server exposes the tools below. Most are read-only against a file argument. The file-writing exceptions are convert (writes a new output file), write_table (writes model-supplied rows to a new file), edit_table (edits an existing file in place), transform_columns (rename / cast / drop columns, writes back), anonymize (mask / scramble columns, writes the result), partition_table (writes one file per group), and write_workbook (writes one .xlsx holding several tables). The live-database write tools (write_db_table, copy_db_table) and run_sql's write_to are gated the same way. All of these are dropped when the server is started with --mcp-read-only.

At-a-glance¶

Tool	Purpose	Mutates files?
`read_table`	Load schema + rows from a file	No
`tail`	Last N rows of a file	No
`sample`	Reproducible random N-row sample	No
`schema`	Schema only (no rows)	No
`list_tables`	List tables in a multi-table source	No
`count_rows`	Row count for a table	No
`run_sql`	DuckDB SQL against the file	No *
`convert`	Write a file in a different format	Writes only the new output path
`export_schema`	Render the schema as DDL / model / struct	No
`profile`	Per-column statistics (`SUMMARIZE`)	No
`find_duplicates`	Rows sharing key-column values	No
`fuzzy_duplicates`	Near-duplicate row clusters (fuzzy)	No
`value_frequency`	Per-column value counts	No
`search`	Match cells across every column	No
`compare_schemas`	Diff the column metadata of two files	No
`diff_tables`	Row-level diff of two files	No
`describe_file`	One-shot orientation snapshot	No
`validate_against_schema`	Validate columns against a JSON Schema	No
`unique_columns`	Unique columns / key candidates	No
`suggest_join_keys`	Rank the column pairs that would join two tables	No
`pivot`	Reshape long <-> wide (PIVOT / UNPIVOT)	No
`batch_convert`	Convert many files into one format	Yes
`resample_timeseries`	Group rows into time buckets and aggregate	No
`rolling_window`	Rolling aggregate over the previous N rows	No
`correlation`	Pairwise numeric correlation matrix	No
`grep_files`	Grep a value across files in a directory	No
`list_objects`	List a cloud bucket folder (S3/Azure/GCS)	No
`copy_object`	Copy a cloud object or folder to another location	Yes
`move_object`	Move a cloud object or folder (copy, then delete)	Yes
`delete_object`	Delete a cloud object or folder	Yes
`write_table`	Write inline rows to a new file	Writes/replaces the output path
`edit_table`	Add columns / set cells / insert / delete rows in place	Yes (edits the file)
`transform_columns`	Rename / cast / drop columns, write back	Writes the output path
`anonymize`	Mask / scramble columns, write the result	Writes the output path
`detect_pii`	Find likely personal-data columns	No
`detect_outliers`	Flag numeric outlier cells	No
`fill_missing`	Impute empty cells in a column	No
`drop_duplicates`	Remove duplicate rows	No
`union_tables`	Stack tables vertically	No
`join_tables`	Join tables on key columns	No
`partition_table`	One file per distinct column value	Writes one file per group
`schema_drift`	Which files in a folder disagree about columns	No
`harmonise_schemas`	Rewrite a folder of files to one schema	Writes into out_dir
`create_report`	Write a self-contained HTML profiling report	Writes the output path
`fuzzy_join`	Join on similarity rather than equality	No
`diagnose_join`	Why two key columns do not join	No
`check_rules`	Check values against a saved rules file	No
`data_drift`	How a dataset changed between two versions	No
`sync_sql`	SQL that would make a server table match a file	No
`write_workbook`	Write several tables into one .xlsx workbook	Writes the output path
`list_db_connections` ¹	List saved live-database connections	No
`list_db_tables` ¹	List schemas / tables on a live connection	No
`db_relationships` ¹	Foreign keys a live database declares	No
`query_db` ¹	Run SQL on a live database server	Mutations need Allow writes
`write_db_table` ¹	Write a table into a live database	Yes (server table)
`copy_db_table` ¹	Copy a table server-to-server through DuckDB	Yes (target server table)

* run_sql accepts mutation queries (INSERT / UPDATE / DELETE) but the in-memory DuckDB connection is discarded at the end of the call. Changes are not persisted back to the file, and the next tool call sees the original on-disk contents again. The mutation result is only useful for "what would this query produce?" probes.

Common parameters¶

All tools share two parameter conventions:

path is required. Absolute or working-directory-relative path to the file. Octa parses based on the file extension. A cloud URL (s3://bucket/key, az://container/key, gs://bucket/key) is also accepted: the object is downloaded to a temporary file and read as usual. The MCP/CLI server authenticates with ambient credentials (AWS_ env vars, a cached SSO session, Azure CLI login, or Google application-default credentials); Azure also needs AZURE_STORAGE_ACCOUNT. Use list_objects to browse a bucket first. Writing* to a cloud URL works too: the write tools (write_table, convert, transform_columns, anonymize, run_sql with write_to) accept a cloud URL as their output, building the file locally and uploading it. They use the same ambient credentials; run the server with --mcp-read-only to drop all write tools.
table (optional): for multi-table sources (SQLite, DuckDB, GeoPackage), pick a specific table. Omit for single-table formats. If you don't know the available tables, call list_tables first.

Row-returning tools (read_table, tail, sample, run_sql, find_duplicates, search, diff_tables) also share:

limit (optional): maximum rows / hits to return.
Omit → use the server's configured default (1000 unless changed under Settings → MCP).
0 → unlimited (returns every row, so be careful with big files).
Any positive integer → that many rows max.

Response shape¶

Tools return JSON content. The shape varies by tool (see each tool page for the specifics), but result-bearing tools always include these envelope fields:

Field	Type	Meaning
`truncated`	bool	True when more rows existed than were returned
`total_rows_available`	int	Total rows in the source (when known cheaply)
`cell_truncated`	bool	True when at least one cell was replaced with a `[truncated: …]` marker due to the per-cell byte cap

These flags let an AI client know when to ask for more, e.g. if truncated: true and total_rows_available: 50000, the model can re-call with limit: 0 (or a higher limit) when the user asks for "all of them."

Error handling¶

Errors come back as MCP tool error responses with a message and an error code:

Code	Meaning
`invalid_params`	The arguments couldn't be parsed or the file couldn't be opened
`internal_error`	Unexpected failure inside the tool's logic (rare)

Friendly examples:

{ "error": { "code": "invalid_params", "message": "read failed: no reader available for /tmp/data.unknown" }}
{ "error": { "code": "invalid_params", "message": "run_sql failed: syntax error at \"FOO\"" }}
{ "error": { "code": "invalid_params", "message": "convert failed: format SAS does not support writing" }}

The model sees the error and (in practice) usually responds with a clarifying question or corrected call.

Tools Reference¶

At-a-glance¶

Common parameters¶

Response shape¶

Error handling¶

See also¶