Pipetable
@melihbirim
About Pipetable
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.
Config
Add this server to your MCP-compatible client using the configuration below.
{
"mcpServers": {
"pipetable": {
"command": "pipetable",
"args": [
"mcp"
]
}
}
}Tools
No tools detected
We auto-extract tools from the README. The maintainer can list them under a ## Tools heading to populate this section.
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.
Frequently asked questions
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.
Basic information
More Developer Tools MCP servers
BetterBugs
BetterBugsThe BetterBugs MCP (Model Context Protocol) enables you to load BetterBugs bug reports (via report links) directly to your preferred AI Agents and developer environments with MCP Client capabilities (such as Cursor, VS C
Serena
oraiosA powerful MCP toolkit for coding, providing semantic retrieval and editing capabilities - the IDE for your agent
CircleCI MCP Server
CircleCIManage CI/CD pipelines, debug failed builds, and optimize test suites directly from your AI agents - no terminal required. The CircleCI MCP Server is a remote server hosted by CircleCI that connects AI tools and agents
Rams
HSLA0001 Inc.Design review for UI code, inside your agent. One tool (review_files): up to 20 files in, a scored review out — 0–100, issues with severity and file:line, a concrete fix for each. 258 versioned rules across accessibility
PuzzleTide Puzzle Generator
Caravaca-LabsWord search generator, crossword generator, and sudoku generator + solver as a local-first MCP server. 15 deterministic tools: printable PDF puzzle worksheets, themed word banks, and verifiable LLM evals. From the makers
Comments