ai.aliengiraffe/spotdb
Ephemeral data sandbox for AI workflows with guardrails and security
SpotDB
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
- Tap the repository and install the package:
brew tap aliengiraffe/spaceship && \\
brew install spotdb
- Start the server:
spotdb
- 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"
- Query the data:
curl -X POST \
http://localhost:8080/api/v1/query \
-H "Content-Type: application/json" \
-d '{"query": "SELECT * FROM mytable LIMIT 10"}'
- Setup Claude Code
You must have the
claudecommand installed.
Then, you can add the spotdb mcp:
claude mcp add spotdb -s user -- npx -y mcp-remote http://localhost:8081/stream
Use Explorer UI
Open the Explorer UI in your browser and upload files and query the data:
open http://localhost:8080/explorer
Full Documentation
Installation
Source-derived launch command. Check the maintainer’s required arguments and credentials before running:
docker run -i --rm docker.io/aliengiraffe/spotdb:0.1.0Set up in your AI client
Merge this template into ~/Library/Application Support/Claude/claude_desktop_config.json. Keep existing servers. Add any arguments, credentials, and permissions required by the maintainer; this template has not been install-tested.
{
"mcpServers": {
"ai-aliengiraffe-spotdb": {
"command": "docker",
"args": [
"run",
"-i",
"--rm",
"docker.io/aliengiraffe/spotdb:0.1.0"
]
}
}
}Restart Claude Desktop completely for changes to take effect. Confirm the server appears connected in the client’s tool list, then try a read-only example from its documentation.
Claude Desktop setup referencePackage
docker.io/aliengiraffe/spotdb:0.1.0dockerCompatible MCP Clients
ai.aliengiraffe/spotdb works with any MCP-compatible client. Copy the config snippet from the Configuration section above and add it to the file shown for your client, then restart the application.
- Claude Desktop
~/Library/Application Support/Claude/claude_desktop_config.jsonRestart Claude Desktop completely for changes to take effect. - Cursor
~/.cursor/mcp.jsonRestart Cursor for changes to take effect. - VS Code
.vscode/mcp.jsonReload VS Code window for changes to take effect. - Windsurf
~/.codeium/windsurf/mcp_config.jsonRestart Windsurf for changes to take effect. - Claude Code
.mcp.jsonSave at the project root, then start Claude Code in that project and review the MCP server approval prompt. Keep real credentials out of shared files.