Tablebridge MCP Server

Query a folder of CSV / Parquet / JSON files with SQL — one queryable source, read-only.

Local serverstdio

What is the Tablebridge MCP Server?

Query a folder of CSV / Parquet / JSON files with SQL — one queryable source, read-only.

What it actually does

It's read-only and sandboxed: files are loaded into an in-memory database, the data directory is the only thing it can see, and queries are validated so an agent can't write, escape to other paths, or call raw file functions.

  • 🔗 One source over many files. JOIN orders.csv to customers.csv to regions.json in a single query — no ETL, no database to stand up
  • 🦆 DuckDB-powered. Fast analytical SQL over CSV, TSV, Parquet, JSON/NDJSON
  • 🔒 Safe by design. Files are materialized into memory; queries are validated read-only; raw file-access functions and out-of-sandbox paths are rejected
  • 🤖 Agent-friendly. list_sources → describe → query is a natural flow the agent can follow on its own
  • 🪶 Two dependencies (mcp, duckdb), fully typed and tested

More MCP options

Compare MCP servers by category, or browse hosted MCP servers if you prefer an endpoint over a local process.

Maintainer setup documentation.

Recorded tools

Check the linked publisher documentation and your connected client's tool list. Names and availability can vary with the server version and account permissions.

ToolWhat it does
list_sourcesList the tables (one per data file) with column counts — start here
describeA table's columns and types
previewFirst N rows of a table
queryRun read-only SQL (DuckDB dialect) across the tables, JOINs included
refreshRe-scan the data directory for added/changed files
server_infoEffective config (data dir, row cap, supported formats)

How to install the Tablebridge MCP Server

{
  "mcpServers": {
    "tablebridge": {
      "command": "uvx",
      "args": [
        "tablebridge"
      ],
      "env": {
        "TABLEBRIDGE_DATA_DIR": "/path/to/your/data"
      }
    }
  }
}

From the project documentation. Replace placeholders and example paths before connecting.

Configuration

VariableDescriptionRequired
TABLEBRIDGE_DATA_DIRDeclared in the maintainer’s client configuration.Check documentation

Example prompts to try

  • “Use Tablebridge to list sources.”
  • “Use Tablebridge to describe.”
  • “Use Tablebridge to preview.”

Frequently asked questions

Query a folder of CSV / Parquet / JSON files with SQL — one queryable source, read-only. Confirm the tools offered by your installed version in the connected client. Tool availability and permissions depend on the server and account configuration.