Open source · Windows · macOS · Linux

Your databases,
and their twins.

A fast database client and real wire-protocol mock servers in one desktop app. Give your code a PostgreSQL, MySQL, SQL Server, Redis, MongoDB, DynamoDB or Firestore server in one click — no Docker. Preview every change before it runs, document everything, let your AI agent help, and learn how databases really work in the built-in Bootcamp.

TwinBase running SQL against a PostgreSQL mock server
PostgreSQLMySQLSQL ServerRedisMongoDBDynamoDBFirestoreSQLiteOracleClickHouseCassandraSpannerBigQueryElasticsearch
Mock servers

Real protocols. Zero containers.

TwinBase mocks speak the actual wire protocols, so your app, ORM, migration tool or psql connects with its normal driver — only the host and port change. A few megabytes of memory, started in milliseconds.

  • PostgreSQL, MySQL and SQL Server on TwinLite, with the real catalogs, types and error codes
  • pgvector built in: vector, halfvec, sparsevec, <=>, <->, HNSW DDL — embedding code runs unchanged
  • Redis, MongoDB, DynamoDB, Firestore with SDK-level compatibility
  • Seeds, one-click reset, live traffic, and fault injection to test the unhappy paths
# the same mocks, headless, in CI
twinbase mock postgres --port 5433 --seed db/schema.sql
psql "postgres://dev@127.0.0.1:5433/app"
ER diagram of a mock database
Database client

Everything you reach for, in one calm place.

Browse and edit fourteen kinds of databases with the same grid, editors and diagrams.

Change preview

Run an UPDATE on a local twin first: every changed, added and removed row — cascades included. The commit is refused if the row count no longer matches.

Query plans

EXPLAIN, SHOWPLAN, Spanner and BigQuery plans drawn as a tree with the expensive steps highlighted and index hints.

Schema diff

Snapshots, diffs and generated up/down migration scripts, plus DDL conversion between dialects.

Docs everywhere

Markdown with Mermaid diagrams on the workspace, every connection, mock, table and column — plain files you commit with your code.

Redis, properly

Numbered databases, a namespace tree, typed editors, streams, JSON, server info and a script console.

Local and private

No account, no cloud, no telemetry. Passwords live in your OS keychain; SSH tunnels and TLS built in.

The TwinBase Bootcamp
Bootcamp

Learn how databases really work.

Ten chapters, from your first SELECT to indexes, transactions, storage internals, Redis caching, sharding, CAP and vector search. Short lessons in plain words, interactive illustrations, playful quizzes and hands-on labs on real mock servers.

  • Six kinds of quick checks: choice, select-all, true/false, fill-the-blank, match the pairs, put in order
  • Labs auto-checked against real PostgreSQL, Redis and MongoDB servers
  • XP, levels, streaks and sixteen badges to collect
  • Runs in its own workspace — your projects stay untouched
Foundations badge Query Crafter badge Data Architect badge Speed Demon badge ACID Keeper badge Under the Hood badge Cache Master badge Document Ranger badge Scale Architect badge Vector Voyager badge Bootcamp Graduate badge
A Bootcamp lesson with an interactive embedding space
Interactive lessons: drag a query through embedding space and watch the nearest neighbours change
AI agents

Your coding agent, with a database it can actually use.

TwinBase is an MCP server. Claude Code, Codex, Gemini CLI, Antigravity, Cursor, VS Code, Windsurf and friends can design schemas, run SQL, edit rows, write docs, manage mocks and inject faults — every action shows up live in the Activity panel.

Real databases stay read-only for agents unless you allow writes per connection, and agents can never raise their own access.

# one line, or one click in Settings → AI agents
claude mcp add --transport http --scope user twinbase \
  http://127.0.0.1:47800/mcp --header "Authorization: Bearer <token>"
codex mcp add twinbase -- twinbase mcp
twinbase agent install cursor
Agent setup in TwinBase settings
Download

Free and open source. Apache-2.0.

Installers for every platform, with checksums and build provenance on each release.

Builds aren't code-signed yet: on Windows choose More info → Run anyway; on macOS open System Settings → Privacy & Security → Open Anyway.