Spotdb

🚀 SpotDB

A lightweight data sandbox for AI workflows and data exploration, equipped with guardrails and security to safeguard your data.

🚀 Quick Start

1. Tap the repository and install the package:

brew tap aliengiraffe/spaceship && \
brew install spotdb

2. Start the server:

spotdb

3. 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"

4. Query the data:

curl -X POST \
  http://localhost:8080/api/v1/query \
  -H "Content-Type: application/json" \
  -d '{"query": "SELECT * FROM mytable LIMIT 10"}'

5. Setup Claude Code You must have the claude command installed. Then, you can add the spotdb mcp:

claude mcp add spotdb -s user -- npx -y mcp-remote http://localhost:8081/stream

✨ 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.

💻 Usage Examples

Basic Usage

Use Explorer UI

Open the Explorer UI in your browser and upload files and query the data:

open http://localhost:8080/explorer

📚 Documentation

👉 https://github.com/aliengiraffe/spotdb/blob/main/DOCS.md