spotdb

Overview

spotdb provides a secure, containerized SQL sandbox for agents. It uses DuckDB and offers MCP or API access. Users can push CSV files for ad-hoc querying and analysis without managing infrastructure.

Best for

Best for
Developers building agent-based tools that need on-demand SQL analysis of tabular data

Use cases

• Give agents ad-hoc SQL access to uploaded CSV data
• Spin up disposable query environments for rapid analysis
• Integrate DuckDB queries into agent workflows via MCP or API

How to use

Install

brew tap aliengiraffe/spaceship && brew install spotdb && spotdb

Tools exposed

• brew
• curl
• npx

Tested with

Claude Code

Example client config

{\n  "mcp_servers": [\n    {\n      "name": "spotdb",\n      "url": "http://localhost:8081/stream",\n      "type": "mcp-remote"\n    }\n  ]\n}

Notes

spotdb provides a secure, containerized SQL sandbox for agents. It uses DuckDB and offers MCP or API access. Users can push CSV files for ad-hoc querying and analysis without managing infrastructure.

20 stars on GitHub. Last updated 2026-05-29. Licensed MIT.

Use cases

• Give agents ad-hoc SQL access to uploaded CSV data
• Spin up disposable query environments for rapid analysis
• Integrate DuckDB queries into agent workflows via MCP or API

Pros

• Secure containerized sandbox isolates queries
• Zero infrastructure setup with quick spin-up
• Leverages DuckDB for efficient SQL processing

Cons

• Limited to DuckDB as the query engine
• Small community and few GitHub stars
• Primarily supports CSV data ingestion

Indexed from mcp-official-registry and enriched against its public facts.