csv-ingest-mcp

MCP server for ingesting CSV / TSV / Parquet / Excel / JSON / JSONL files into any SQLAlchemy-supported database (Postgres, MySQL, SQLite, MSSQL, ...). Plug into Claude Desktop, Cursor, Cline, or Continue and let the LLM load tabular data on demand.

Install

uvx csv-ingest-mcp        # one-shot, no global install
# or
pip install csv-ingest-mcp

Quick start (Claude Desktop)

~/.config/Claude/claude_desktop_config.json (Linux) / ~/Library/Application Support/Claude/claude_desktop_config.json (macOS):

{
  "mcpServers": {
    "csv-ingest": {
      "command": "uvx",
      "args": ["csv-ingest-mcp"],
      "env": {
        "CSV_MCP_ALLOWED_DIRS": "/home/you/data",
        "CSV_MCP_DB_URL": "postgresql://user:pass@localhost/mydb"
      }
    }
  }
}

Restart Claude Desktop. The model now has six tools.

Tools

Configuration

Cursor / Cline / Continue

{
  "mcp": {
    "servers": {
      "csv-ingest": {
        "command": "uvx",
        "args": ["csv-ingest-mcp"],
        "env": { "CSV_MCP_ALLOWED_DIRS": "/abs/data" }
      }
    }
  }
}

Async + watcher (optional)

# 1. Redis
docker run -d -p 6379:6379 redis:7

# 2. Celery worker
CSV_MCP_ALLOWED_DIRS=/data CSV_MCP_DB_URL=postgresql://... \
  uv run celery -A csv_ingest_mcp.tasks worker -l info

# 3. File watcher (drops a CSV in /data/inbox -> table auto-created)
CSV_MCP_ALLOWED_DIRS=/data uv run csv-ingest-watch

Docker (self-host)

docker compose up -d

See docker-compose.yml (server + worker + redis).

Security

• Path allowlist (CSV_MCP_ALLOWED_DIRS) — only listed dirs readable
• SQL identifier regex — table/column names validated
• Parametrized inserts (no string concat)
• Row cap + chunk streaming — bounded memory
• JSON-only Celery serializer — no pickle RCE

Disclose security issues to: priyank.salot@dbcorp.in

Architecture

See ARCHITECTURE.md for component map, request flows, and publishing approach.

Development

git clone https://github.com/priyak-salot/csv-ingest-mcp
cd csv-ingest-mcp
uv sync
uv run pytest

License

MIT