
Pipetable
Local MCP server that lets agents run DuckDB SQL on CSV, Excel, Parquet and JSON files
- Pricing
- Open source
- Platforms
- CLI, macOS, Linux
- Runs
- Locally
- Version
- 0.7.2
- Listing updated
- 3 days ago
About Pipetable
Pipetable is an open-source MCP server for files and documents. It runs locally on your machine and is started by your AI client.
Pipetable is built for the case where an assistant needs your business data but you don't want to upload files or open up the whole filesystem. You point it at a folder, it registers the data files it finds, and the agent queries them through DuckDB, so answers come from real query output rather than guesses.
The MCP server exposes four steps: scan a folder, list datasets with column types, inspect one table with sample rows, and execute SQL. Folders are scanned up to three levels deep, hidden files and directories such as node_modules and .git are skipped, and files up to 2GB are supported.
The same binary also works as a standalone CLI with a SQL prompt. Natural-language questions there are optional and use an Anthropic key, an OpenAI-compatible endpoint or a local Ollama model; SQL and the MCP server need no key or internet connection. It is MIT licensed and installs as a small binary or via cargo.
Install
Run in a terminal
claude mcp add pipetable -- npx -y pipetableAdd to claude_desktop_config.json
{
"mcpServers": {
"pipetable": {
"command": "npx",
"args": [
"-y",
"pipetable"
]
}
}
}Add to ~/.cursor/mcp.json
{
"mcpServers": {
"pipetable": {
"command": "npx",
"args": [
"-y",
"pipetable"
]
}
}
}Add to .vscode/mcp.json
{
"servers": {
"pipetable": {
"type": "stdio",
"command": "npx",
"args": [
"-y",
"pipetable"
]
}
}
}Add to ~/.codeium/windsurf/mcp_config.json
{
"mcpServers": {
"pipetable": {
"command": "npx",
"args": [
"-y",
"pipetable"
]
}
}
}Add to your client's MCP settings (most use this shape)
{
"mcpServers": {
"pipetable": {
"command": "npx",
"args": [
"-y",
"pipetable"
]
}
}
}Tools this server provides (4)
Taken from the project documentation; the running server may differ.
- scan_folder
- Register all data files in a folder
- list_datasets
- See dataset schemas and column types
- get_schema
- Inspect a specific table with sample rows
- execute_sql
- Run DuckDB SQL against the files
What it does
- Folder scanning
- Registers CSV, TSV, Parquet, JSON, NDJSON and Excel files found up to three levels deep.
- Real DuckDB SQL
- Queries run in DuckDB, so results are actual query output.
- Local-only access
- Files stay on your machine and nothing is uploaded.
- Schema inspection
- Shows column types and sample rows before the agent writes a query.
- Standalone CLI
- An interactive prompt with dot commands and one-shot `ask` queries.
- Chained results
- Each query result is kept as a view called _last for follow-up queries.
Good for
- Let Claude Code answer questions about a folder of sales CSVs
- Query Excel workbooks without uploading them anywhere
- Explore large Parquet or NDJSON files from an editor assistant
- Run ad hoc SQL over local exports from the terminal
Pricing
Open source
MIT licensed, free to use.
Prices change. Check pipetable.com before you buy.
Pipetable FAQ
Does it need an API key?
No. SQL and the MCP server work offline without a key; only natural-language questions in the CLI need an Anthropic, OpenAI-compatible or Ollama backend.
Which file formats can it read?
CSV, TSV, Parquet, JSON, NDJSON and Excel (xlsx, xls, xlsm), up to 2GB per file.
How do I add it to Claude Code?
Run claude mcp add pipetable pipetable mcp after installing the binary.
Is my data sent anywhere?
The site and README say files never leave your machine.
Is Pipetable free?
Yes. Pipetable is open source, so you can use and self-host it for free.
How do I add Pipetable to Claude Code?
Run this command in your terminal: claude mcp add pipetable -- npx -y pipetable
What are the best alternatives to Pipetable?
The closest alternatives to Pipetable are Agent-Native Analytics, Google Ads + Meta Ads + SEO/GEO MCP, Tapetide - Indian Stock Market MCP, Midplane and World Monitor.
Alternatives to Pipetable

Agent-Native Analytics
MCP serverOpen-source analytics app where an AI agent builds charts and dashboards from your data
- Remote
- Open source
- 7.7K GitHub stars
- Analytics and data

Google Ads + Meta Ads + SEO/GEO MCP
MCP serverHosted MCP connector for managing Google Ads, Meta Ads, GA4 and Search Console from chat
- 8 tools
- Remote
- Freemium
- 8.1K GitHub stars
- Marketing and SEO

Tapetide - Indian Stock Market MCP
MCP serverIndian NSE and BSE stock market data for AI assistants through 48 MCP tools
- 17 tools
- Remote
- Freemium
- 150 GitHub stars
- Finance and payments

Midplane
MCP serverPostgres gateway for AI agents with table grants, column masking and approval for writes
Runs locally- Open source
- 5 GitHub stars
- Databases

World Monitor
MCP serverLive geopolitical intelligence dashboard with an API and MCP server for agents
- Remote
- Freemium
- Analytics and data

CompanyData
MCP serverSearch and enrich company records from official registers via the CompanyData API
- 3 tools
- Remote
- Paid
- 3 GitHub stars
- Analytics and data