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.

#duckdb #csv #parquet #data #local #sql #files

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.

Comments

Basic information

More Developer Tools MCP servers

FastAPI-MCP

tadata-org

Expose your FastAPI endpoints as Model Context Protocol (MCP) tools, with Auth!

11.9K

Serena

oraios

A powerful MCP toolkit for coding, providing semantic retrieval and editing capabilities - the IDE for your agent

26.2K

TranscriptFetch MCP Server

TranscriptFetch

Model Context Protocol (MCP) server for TranscriptFetch: fetch YouTube transcripts, search, channels, and playlists from any MCP client.

PuzzleTide Puzzle Generator

Caravaca-Labs

Word 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

MCP Containers

metorial

Connect any AI model to 1200+ integrations (MCP, CLI, API)

3.3K