🛠️ Developer CLI Open Source

SpinDB

13 Containerized DB & Lakehouse CLI

Fast, Unified Developer CLI (spinctl) for Spinning Up 13 Containerized Databases, Caches & Lakehouse Engines.

spinctl CLIRootless PodmanDocker Fallback13 Database Enginespgvector & AIClickHouse OLAPSpark & DuckDB

View Source Code ↗License Information

🖼️ Visual Showcase & Highlights

A fast, unified developer CLI (spinctl) for spinning up 13 containerized databases, in-memory caches, and lakehouse engines using Podman (default, secure, rootless) with seamless automatic fallback to Docker. Eliminates complex engine syntax and provisions isolated database environments in seconds.

Developer Productivity & Multi-Engine Power

🦭 Rootless Podman & Docker Fallback

Daemonless and rootless by default for superior system security. Automatically falls back to Docker if Podman is absent. Built-in --preflight checks output exact OS package installation commands.

🏢 13 Engines Supported

Spin up PostgreSQL, pgvector (AI embeddings), MySQL, MariaDB, SQL Server 2022, Oracle Free, IBM DB2, MongoDB, Redis/Valkey, ClickHouse (OLAP), CockroachDB, Snowflake Emulator (DuckDB), and Databricks (Spark + Delta Lake).

🏷️ Version Discovery & Concurrent Variants

Unified version catalog (spinctl versions) with 24h TTL registry caching. Spin up multiple major/minor database versions concurrently on auto-allocated isolated host ports (e.g. postgres-14-5432 vs postgres-17-5435).

💻 Unified CLI Control (spinctl)

Control container lifecycles without remembering engine syntax: spinctl status, start, stop, restart, logs, connect (launches interactive psql/mysql client directly inside container), and env (.env exporter).

🤖 AI Vector & Lakehouse Processing

Run pgvector for AI vector embeddings & similarity search, ClickHouse for columnar OLAP analytics, Databricks local engine (Spark + Delta Lake), and Snowflake local emulator (DuckDB-backed).

Local Security Hardening & Resource Limits

🛡️ Local Hardening & Resource Limits

Binds container ports to 127.0.0.1 by default for host isolation. Configurable memory (--memory 512m) and CPU (--cpus 1.5) limits prevent host exhaustion. Supports gitignored Database.properties.local credentials.

🛠️ Quickstart with spinctl

1. Preflight System Verification

Inspect container engine readiness and host tool availability.

./bin/spinctl --preflight

2. Spin Up PostgreSQL + pgvector AI

Launch vector database with persistent storage volume.

./bin/spinctl -t pgvector -p 5432 -n dev-vector -d /data/pgvector

3. Connect & Export Environment

Launch interactive DB shell or dump connection strings.

./bin/spinctl connect dev-vector
./bin/spinctl env dev-vector

⚡ Developer Quickstart & Source Access

This enterprise system tool is fully configured for cloud-native containerized execution (Podman, Docker, Helm) and local development workflows.

View Repository on GitHub ↗