The MCP server exposes 26 tools to your AI assistant. You never call these directly — you describe a goal in plain language and the AI picks and chains the tools itself. This page is the plain-language map of what it can reach.
Every tool is read-only. Nothing here can change your data, connections, stream configs, or stream runtime state. See Safety & privacy for the full boundary.
| Tool | What it does |
|---|
list_connections | Lists your connections (name, type, ID) — never DSNs or passwords. |
get_connection | Detail for one connection: host, port, username, default database, SSL/SSH topology — never the password, SSH private key, or cloud keys (S3/GCS/Azure access keys, tokens, service-account JSON). |
list_databases | Databases on a connection (system databases hidden unless asked). |
list_schemas | Schemas inside a database (system schemas hidden unless asked). |
list_tables | Tables in a database, optionally filtered by schema. |
describe_table | Columns, indexes, primary/foreign keys, and CREATE TABLE DDL for a table. |
preview_table | A bounded sample of rows (default 100, max 1000), with optional ordering and offset. |
list_views | Views in a database (separate from tables), optionally filtered by schema. |
describe_view | A view's columns, defining SQL, materialized flag, and dependencies. |
preview_view | A bounded sample of view rows (default 100, max 1000). |
| Tool | What it does |
|---|
list_files | Lists local files/directories (CSV, JSON, JSONL, Parquet) from a path or a files-type connection. |
get_file_schema | Detected schema, row-count estimate, and optional column statistics for a data file. |
list_s3_buckets | Lists the S3 buckets reachable with a stored S3 connection's credentials. |
list_s3_objects | Lists objects and sub-folder prefixes under an S3 bucket/prefix, with pagination. |
| Tool | What it does |
|---|
run_select | Runs one bounded SELECT / WITH ... SELECT against a connection. Returns rows plus measured executionMs. Rejects anything that isn't a single read-only query. |
explain_select | Runs EXPLAIN for a query (Postgres / MySQL / DuckDB), returning the plan plus parsed top-of-plan metrics. |
| Tool | What it does |
|---|
run_federated_select | One SELECT spanning multiple sources — databases, local files, and S3 — joined in a single query. |
explain_federated_select | EXPLAIN for a federated query, to sanity-check the cross-source join plan before running it. |
| Tool | What it does |
|---|
list_streams | Lists your stream configs (name, mode, source/target connection IDs). |
get_stream | Full config for one stream: source tables, target shape, write mode, schema policy, per-table filters. |
get_stream_status | Latest known status from runtime snapshots or run history. |
get_stream_stats | Latest throughput/row statistics snapshot. |
get_stream_recent_errors | Recent error-level log entries for a stream (secrets redacted). |
get_stream_recent_logs | Recent log entries with an optional level filter (secrets redacted). |
| Tool | What it does |
|---|
compare_schemas | Compares two table schemas across connections; flags blockers and warnings for migration/CDC. |
compare_data_sample | Compares bounded sample rows across two tables, matched by key columns or row order. |
| Category | Count | Tools |
|---|
| Database inspection | 10 | list_connections, get_connection, list_databases, list_schemas, list_tables, describe_table, preview_table, list_views, describe_view, preview_view |
| Files & S3 | 4 | list_files, get_file_schema, list_s3_buckets, list_s3_objects |
| Query | 2 | run_select, explain_select |
| Federated query | 2 | run_federated_select, explain_federated_select |
| Streams | 6 | list_streams, get_stream, get_stream_status, get_stream_stats, get_stream_recent_errors, get_stream_recent_logs |
| Comparison | 2 | compare_schemas, compare_data_sample |
| Total | 26 | all read-only |
No tool — by any path — writes data, changes configuration, runs arbitrary SQL, or controls streams. The AI advises; you execute. The full list of guarantees is in Safety & privacy → What cannot happen.