Overview
Pipetable is an MCP server that registers your local data files as DuckDB views and lets AI tools (Claude Code, Cursor, Copilot, RooCode) run real SQL against them. Files never leave your machine. Results are ground truth — not generated.
Tools: scan_folder, list_datasets, get_schema, execute_sql.
Also ships as a standalone CLI REPL. MIT licensed. 5MB binary.
Server Config
{
"mcpServers": {
"pipetable": {
"command": "pipetable",
"args": [
"mcp"
]
}
}
}