Pipetable MCP Server

@melihbirim

Basic information

About Pipetable MCP Server

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

Pipetable MCP Server config

Add this server to your MCP-compatible client using the configuration below.

{
  "mcpServers": {
    "pipetable": {
      "command": "pipetable",
      "args": [
        "mcp"
      ]
    }
  }
}

Pipetable MCP Server tools

Tool list not available yet

This listing does not currently have a tool list to display. This does not mean the server has no tools; check its documentation for supported capabilities.

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

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

More Developer Tools MCP servers

Layro

Layro connects your AI coding tool (Cursor, Claude Code, VS Code, Windsurf, Codex, Gemini CLI) to 112 production React, TypeScript and Tailwind CSS components. Your agent can search the library, read each component's pro

Ramen

bkraad47

Multi-zone MCP server for GKE/EKS/AKS: Python tools from git, NeMo guardrails, SSO, autoscaling.

Vibgrate MCP

Vibgrate

Query your team's drift, vulnerability, and migration data from any AI assistant. Vibgrate MCP connects Cursor, Claude, ChatGPT, Windsurf, or VS Code to Vibgrate Cloud: 51 tools for DriftScores, CVEs and EOL runtimes, up

offprompt

MCP server that lets Claude Code, Cursor or Codex ask you for API keys on a local page and write them to .env. The agent only ever sees key names.

Eddyter AI Rich Text Editor MCP

EddyterAI

Set up and manage the Eddyter AI rich text editor by talking to your AI agent — for Claude, Cursor, Codex and other MCP tools. A Model Context Protocol server that lets AI tools add Eddyter to a React, Next.js, Vite or R