Pipetable
@melihbirim
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.
Overview
What is Pipetable?
Pipetable is an MCP server that registers your local data files as DuckDB views, enabling AI tools like Claude Code, Cursor, Copilot, and RooCode to run real SQL against them. Files never leave your machine and results are ground truth—not generated.
How to use Pipetable?
You can use Pipetable as an MCP server with supported AI tools or as a standalone CLI REPL. It provides four tools: scan_folder, list_datasets, get_schema, and execute_sql.
Key features of Pipetable
- Registers local data files as DuckDB views
- Lets AI tools run real SQL queries
- Files never leave your machine
- Results are ground truth, not generated
- Ships as both MCP server and CLI REPL
- MIT licensed, 5MB binary
Use cases of Pipetable
- Query CSV, Parquet, or other local files via AI assistant chat
- Validate data or answer questions using real SQL execution
- Explore and analyze datasets without uploading them anywhere
FAQ from Pipetable
Which AI tools does Pipetable work with?
Claude Code, Cursor, Copilot, and RooCode are explicitly supported.
How does Pipetable keep my data private?
Files never leave your machine; all SQL runs locally.
Is Pipetable a server or a CLI tool?
It is an MCP server and also ships as a standalone CLI REPL.
What license is Pipetable under?
MIT License.
How large is the Pipetable binary?
5MB.
