Skip to content
MCP server

Pipetable

Local MCP server that lets agents run DuckDB SQL on CSV, Excel, Parquet and JSON files

Runs locallyStatus and history
Pricing
Open source
Platforms
CLI, macOS, Linux
Runs
Locally
Version
0.7.2
Listing updated
3 days ago

About Pipetable

Pipetable is an open-source MCP server for files and documents. It runs locally on your machine and is started by your AI client.

Pipetable is built for the case where an assistant needs your business data but you don't want to upload files or open up the whole filesystem. You point it at a folder, it registers the data files it finds, and the agent queries them through DuckDB, so answers come from real query output rather than guesses.

The MCP server exposes four steps: scan a folder, list datasets with column types, inspect one table with sample rows, and execute SQL. Folders are scanned up to three levels deep, hidden files and directories such as node_modules and .git are skipped, and files up to 2GB are supported.

The same binary also works as a standalone CLI with a SQL prompt. Natural-language questions there are optional and use an Anthropic key, an OpenAI-compatible endpoint or a local Ollama model; SQL and the MCP server need no key or internet connection. It is MIT licensed and installs as a small binary or via cargo.

Install

Run in a terminal

claude mcp add pipetable -- npx -y pipetable

Add to claude_desktop_config.json

{
  "mcpServers": {
    "pipetable": {
      "command": "npx",
      "args": [
        "-y",
        "pipetable"
      ]
    }
  }
}
Install in CursorOpens Cursor, which asks you to confirm. Or add it by hand:

Add to ~/.cursor/mcp.json

{
  "mcpServers": {
    "pipetable": {
      "command": "npx",
      "args": [
        "-y",
        "pipetable"
      ]
    }
  }
}
Install in VS CodeOpens VS Code, which asks you to confirm. Or add it by hand:

Add to .vscode/mcp.json

{
  "servers": {
    "pipetable": {
      "type": "stdio",
      "command": "npx",
      "args": [
        "-y",
        "pipetable"
      ]
    }
  }
}

Add to ~/.codeium/windsurf/mcp_config.json

{
  "mcpServers": {
    "pipetable": {
      "command": "npx",
      "args": [
        "-y",
        "pipetable"
      ]
    }
  }
}

Add to your client's MCP settings (most use this shape)

{
  "mcpServers": {
    "pipetable": {
      "command": "npx",
      "args": [
        "-y",
        "pipetable"
      ]
    }
  }
}

Tools this server provides (4)

Taken from the project documentation; the running server may differ.

scan_folder
Register all data files in a folder
list_datasets
See dataset schemas and column types
get_schema
Inspect a specific table with sample rows
execute_sql
Run DuckDB SQL against the files

What it does

Folder scanning
Registers CSV, TSV, Parquet, JSON, NDJSON and Excel files found up to three levels deep.
Real DuckDB SQL
Queries run in DuckDB, so results are actual query output.
Local-only access
Files stay on your machine and nothing is uploaded.
Schema inspection
Shows column types and sample rows before the agent writes a query.
Standalone CLI
An interactive prompt with dot commands and one-shot `ask` queries.
Chained results
Each query result is kept as a view called _last for follow-up queries.

Good for

  • Let Claude Code answer questions about a folder of sales CSVs
  • Query Excel workbooks without uploading them anywhere
  • Explore large Parquet or NDJSON files from an editor assistant
  • Run ad hoc SQL over local exports from the terminal

Pricing

Open source

MIT licensed, free to use.

Prices change. Check pipetable.com before you buy.

Pipetable FAQ

Does it need an API key?

No. SQL and the MCP server work offline without a key; only natural-language questions in the CLI need an Anthropic, OpenAI-compatible or Ollama backend.

Which file formats can it read?

CSV, TSV, Parquet, JSON, NDJSON and Excel (xlsx, xls, xlsm), up to 2GB per file.

How do I add it to Claude Code?

Run claude mcp add pipetable pipetable mcp after installing the binary.

Is my data sent anywhere?

The site and README say files never leave your machine.

Is Pipetable free?

Yes. Pipetable is open source, so you can use and self-host it for free.

How do I add Pipetable to Claude Code?

Run this command in your terminal: claude mcp add pipetable -- npx -y pipetable

What are the best alternatives to Pipetable?

The closest alternatives to Pipetable are Agent-Native Analytics, Google Ads + Meta Ads + SEO/GEO MCP, Tapetide - Indian Stock Market MCP, Midplane and World Monitor.

Alternatives to Pipetable

  1. Open-source analytics app where an AI agent builds charts and dashboards from your data

    • Remote
    • Open source
    • 7.7K GitHub stars
    • Analytics and data
  2. Hosted MCP connector for managing Google Ads, Meta Ads, GA4 and Search Console from chat

    • 8 tools
    • Remote
    • Freemium
    • 8.1K GitHub stars
    • Marketing and SEO
  3. Indian NSE and BSE stock market data for AI assistants through 48 MCP tools

    • 17 tools
    • Remote
    • Freemium
    • 150 GitHub stars
    • Finance and payments
  4. Midplane

    MCP server

    Postgres gateway for AI agents with table grants, column masking and approval for writes

    Runs locally
    • Open source
    • 5 GitHub stars
    • Databases
  5. World Monitor

    MCP server

    Live geopolitical intelligence dashboard with an API and MCP server for agents

    • Remote
    • Freemium
    • Analytics and data
  6. CompanyData

    MCP server

    Search and enrich company records from official registers via the CompanyData API

    • 3 tools
    • Remote
    • Paid
    • 3 GitHub stars
    • Analytics and data