spotdb

MCP.Pizza Chef: aliengiraffe

SpotDB provides a secure, temporary environment where you can upload CSV files and run SQL queries without risking your main data. It runs locally or on a server, requires no complex setup, and integrates with AI assistants like Claude via MCP or REST APIs. You can explore data safely, capture snapshots, and quickly spin up a data sandbox for analysis or AI workflows.

Data
Other

Use This MCP server To

Upload a CSV file and run SQL queries on it Explore and analyze data safely without affecting original files Create temporary databases for AI to query during workflows Capture snapshots of data to save and restore later Integrate data querying into AI assistants like Claude or GPT-4

README

SpotDB

Quality Gate Status

Lightweight data sandbox for AI workflows and data exploration, enabled with guardrails and security to keep your data safe.

This project provides a lightweight, ephemeral data sandbox designed for large language models (LLMs) and agentic workflows. By providing a secure, isolated environment, it allows AI agents and scripts to analyze data without direct access to production databases. This setup prevents accidental data modification, ensures data privacy, and enforces guardrails for safe data exploration.

Features

  • 🏖️ Ephemeral Data Sandbox: Create temporary databases for AI workflows and data exploration.
  • 📸 Snapshot: Capture and store data snapshots, recover point-in-time data states or continue from a previous state.
  • 🧠 MCP API: Access data through a Model Context Protocol for seamless integration with AI models and agentic workflows.
  • ⚙️ REST API: Access data through a RESTful API for integration with traditional systems and workflows.
  • 🚂 Guardrails: Enforce rules and constraints to ensure data safety and privacy.
  • 🛡️ Security: Protect data from unauthorized access and modification.

Quick Start

  1. Tap the repository and install the package:
brew tap aliengiraffe/spaceship && \\
brew install spotdb
  1. Start the server:
spotdb
  1. Upload a CSV file:
curl -X POST \
  http://localhost:8080/api/v1/upload \
  -F "table_name=mytable" \
  -F "has_header=true" \
  -F "csv_file=@data.csv"
  1. Query the data:
curl -X POST \
  http://localhost:8080/api/v1/query \
  -H "Content-Type: application/json" \
  -d '{"query": "SELECT * FROM mytable LIMIT 10"}'
  1. Setup Claude Code You must have the claude command installed.

spotdb FAQ

Can I use this to analyze CSV data securely?
Yes — you can upload CSV files and run SQL queries safely in a temporary sandbox without affecting your main data.
Can I use this with Claude or other AI assistants?
Yes — it supports integration via MCP API and can be added as a context source for Claude, GPT-4, Gemini, and others.
Do I need an API key or account to use spotdb?
No — spotdb runs locally or on your server without requiring accounts or API keys.
How hard is it to set up spotdb?
Setup is easy — you can install it with a simple command and start it quickly, then upload files and query them.
Which apps or clients work with spotdb?
It works with any AI or tool that supports MCP or REST API calls, including Claude and other LLM hosts.
Can I keep data between sessions?
Spotdb is designed as an ephemeral sandbox, but it supports snapshots to save and restore data states.