mcp-tabular
Click on "Deploy Server".
Wait a few minutes for the server to deploy. Once ready, it will show a "Started" state.
In the chat, type
@followed by the MCP server name and your instructions, e.g., "@mcp-tabular load sales.csv and show total revenue by region"
That's it! The server will respond to your query, and you can continue using it as needed.
Here is a step-by-step guide with screenshots.
mcp-tabular
An MCP server that gives any LLM agent SQL over CSV and Excel files. DuckDB-powered, read-only, zero configuration.
Why
Embedding spreadsheets into a vector store gives agents mushy answers; tables chunk badly. The pattern that works in production is SQL-over-file: load the table into an analytical engine and let the agent query it. mcp-tabular packages that pattern as a standard MCP server, so it works with Claude Desktop, Claude Code, or any MCP client.
Agent ──MCP──▶ mcp-tabular ──▶ DuckDB (in-memory, read-only)
tools: load_file · list_tables · describe_table · query · sample_rowsRelated MCP server: DuckDB MCP Server
Install & run
pip install -e .
mcp-tabular # stdio transportClaude Desktop config:
{
"mcpServers": {
"tabular": { "command": "mcp-tabular" }
}
}Tools
Tool | Description |
| Load a CSV/XLSX file into an in-memory table. Returns schema + row count. |
| Tables currently loaded. |
| Columns, types, null counts, min/max — enough for the agent to write correct SQL. |
| Read-only SELECT. Results capped and returned as markdown. |
| Quick peek at representative rows. |
Safety
Read-only: statements other than
SELECT/WITHare rejected before execution.Path allow-listing: set
MCP_TABULAR_ROOTto restrict which directory files may be loaded from.Bounded output: result sets are truncated (default 200 rows) so a bad query can't blow up the agent's context window.
Example session
> load_file("sales_q3.csv")
loaded table 'sales_q3' (8,412 rows). Columns: region VARCHAR, sku VARCHAR, units BIGINT, revenue DOUBLE
> query("SELECT region, SUM(revenue) r FROM sales_q3 GROUP BY 1 ORDER BY r DESC LIMIT 3")
| region | r |
|--------|----------|
| South | 412,050 |
| West | 371,200 |
| East | 298,700 |Design notes
Built after shipping enterprise agents where tabular Q&A over uploaded files was the highest-volume use case. Schema + sample injection (via describe_table/sample_rows) is what makes agents write correct SQL on the first try.
License
MIT
Available Tools
5 toolsdescribe_tableB
Column names, types, null counts, and min/max — enough to write correct SQL.
Inputs: table (required). Returns: result
list_tablesA
List tables currently loaded and their source files.
Inputs: no named parameters. Returns: result
load_fileA
Load a CSV or Excel file into an in-memory table for SQL querying.
Args: path: path to a .csv, .tsv, .xlsx, or .xls file. table_name: optional; defaults to the file stem.
Inputs: path (required), table_name. Returns: result
queryC
Run a read-only SELECT/WITH query. Results are capped at MAX_ROWS.
Inputs: sql (required). Returns: result
sample_rowsB
Return n representative rows from a loaded table.
Inputs: table (required), n. Returns: result
Tool Schema Changelog
Recent tool additions, removals, and schema changes observed during successful MCP inspections.
Loading tool schema changelog…
TDQS
Scored across 5 tools
Each tool has a clear, distinct purpose: describing schema, listing tables, loading files, running queries, and sampling rows. No overlap in functionality.
Most tool names follow a consistent verb_noun pattern (describe_table, list_tables, load_file, sample_rows). 'query' is a single verb but is a common and clear exception that doesn't cause confusion.
With 5 tools covering loading, listing, describing, querying, and sampling, the count is well-suited for a focused tabular data server. No unnecessary or missing tools.
The tool set covers the core workflow for read-only SQL querying on loaded tables. Minor gaps like table removal or export exist but are not essential for the stated purpose.
Maintenance
Related MCP Connectors
Query, join, profile, clean and convert CSV/JSON/Parquet with server-side DuckDB over MCP.
Read-only MCP over your Excel or Airtable plus the PDFs beside it, joined as one relational dataset.
Query your warehouse or a CSV with Claude/ChatGPT over MCP, governed by table-level ACL + audit.
Query your org's data in natural language — read-only MCP access to SQL, NoSQL, files & warehouses.
Related MCP Servers
- AlicenseAqualityDmaintenanceEnables DuckDB database interaction through MCP, supporting SQL queries, table creation, and schema inspection with optional read-only mode.1MIT
- FlicenseNot gradedqualityDmaintenanceEnables running read-only SQL queries and exploring DuckDB databases through MCP tools like listing tables, describing schemas, and fetching paginated data.-
- AlicenseAqualityDmaintenanceEnables read-only SQL querying and exploration of data files (CSV, Parquet, JSON, Excel, etc.) via DuckDB, supporting local paths, globs, URLs, and S3 buckets.5MIT
- FlicenseNot gradedqualityAmaintenanceEnables interaction with a DuckDB database through MCP tools for executing SQL queries, creating tables, and inspecting schemas. It also supports read-only mode to prevent write operations.-