Lightweight, AI-native database management for 70+ databases. Desktop, Docker, CLI, and MCP Server.
|
No Java JRE. No Python venv. No bundled Chromium. PanDB ships as a single small binary — download, install, connect. DBeaver needs Java; TablePlus is macOS-only. PanDB runs everywhere with nothing extra. |
Highlight a table, describe what you want, get SQL back — no copy-paste between tools. Works with Claude, OpenAI, or local models via Ollama. Built-in safety checks review AI-generated SQL before it runs. |
|
PanDB speaks the Model Context Protocol. Claude Code, Cursor, Windsurf, and other AI coding agents can query your databases through connections you already set up. One config, everywhere. |
Native app on macOS, Windows, and Linux. Self-host via Docker for team access. Web version for browser-only environments. Same feature set. Same connections. |
MySQL, PostgreSQL, SQLite, Cloudflare D1, Redis, MongoDB, DuckDB, ClickHouse, SQL Server, Oracle, Elasticsearch, Easysearch, Qdrant, Milvus, Weaviate, MariaDB, TiDB, OceanBase, openGauss, GaussDB, KWDB, KingBase, Vastbase, GoldenDB, Doris, SelectDB, StarRocks, Manticore Search, Redshift, DM, TDengine, XuguDB, CockroachDB, Access, HighGo, UXDB, and more. Agent/JDBC-oriented profiles extend PanDB to H2, Snowflake, Trino, PrestoSQL, Hive, DB2, Informix, Neo4j, Cassandra, BigQuery, Kylin, SunDB, JDBCX, and custom JDBC connections. New native and agent-driven drivers also cover Databricks, SAP HANA, Teradata, Vertica, Firebird, Exasol, YashanDB, GBase 8a/8s, Databend, RQLite, Turso, InfluxDB, QuestDB, IoTDB, etcd, ZooKeeper, Nacos, IRIS, and more. Message queue admin is also available for Pulsar, Kafka, and RocketMQ. All in a single ~20 MB app. No bundled Chromium.
CodeMirror 6 with SQL syntax highlighting, metadata-aware autocomplete, Cmd+Enter execution, selected SQL execution, SQL formatting, diagnostics, and 9 editor themes. Persistent query history, saved SQL snippets, tab restore, and SQL file execution keep repeat work close at hand.
Describe what you want in plain language — get SQL back. PanDB can explain queries, optimize SQL, fix errors, and run AI-generated SQL through built-in safety checks. Works with Claude, OpenAI, local models, or any OpenAI-compatible endpoint.
Virtual-scrolled table that handles large result sets. Inline editing, SQL preview before save, WHERE / ORDER BY controls, DataGrip-style filters, LIKE / NOT LIKE context filters, sorting, full-text search, pagination, column resize, auto-fit, row numbers, zebra stripes, and full cell details. Export or copy as CSV, JSON, Markdown, XLSX, or INSERT statements.
- Schema browser — databases, schemas, tables, columns, indexes, foreign keys, triggers, with sidebar search & pin
- Object browser — grouped procedures, functions, views, and source editing where supported
- Table structure editor — reviewable column and index changes for supported engines
- ER diagram — visualize table relationships
- Schema diff — compare structures across connections
- Explain plan — visual query execution plan
- Field lineage — column-level lineage analysis
- Database search — find objects across large schemas
- Table import — CSV, Excel
- Data transfer — migrate between databases
- Database export — full database dump
- Data compare — compare table data and review synchronization output
- SQL file execution — run
.sqlfiles directly - File preview — drag & drop Parquet, CSV, JSON to preview instantly (powered by DuckDB)
- Connection import — bring connection profiles from DBeaver or Navicat
- Redis — key pattern search, batch key operations, command runner, TTL editing, and all data types (String, Hash, List, Set, ZSet, Stream)
- MongoDB — document CRUD with pagination, Atlas & replica set URL connection
SSH tunnel (key & password) · database and AI proxy settings · auto-reconnect on connection loss · confirmation dialogs for destructive operations · encrypted config export/import · color-coded connections · driver store and optional JDBC plugin
Dark mode with native title bar sync · 9 editor themes · English, 简体中文 & Español · layout preferences · built-in auto-update
PanDB provides a separate Rust-powered MCP server that lets AI coding agents query databases using connections configured in PanDB. The MCP server is distributed independently from the desktop application, so installing PanDB does not automatically install the MCP executable.
npx @dbx-app/mcp-serverAdd to your .mcp.json:
{
"mcpServers": {
"dbx": { "command": "npx", "args": ["-y", "@dbx-app/mcp-server"] }
}
}Manage the connection allowlist and the Read only, Data read/write, and Full access modes in PanDB Settings → MCP. The machine-readable values remain read_only, safe_write, and high_risk_write; client configs do not need permission or connection-scope environment variables.
For upgrade compatibility, an existing DBX_MCP_ALLOW_WRITES=0 (or false) remains a read-only restriction only until a central MCP policy is saved for the first time; it can never enable writes or override a saved policy.
Windows portable builds need PANDB_DATA_DIR in the MCP config, pointing to the data directory next to PanDB.exe (the folder that contains dbx.db).
For PanDB Web or Docker deployments, point the MCP server at the Web backend API. If the Web login page requires a password, set PANDB_WEB_PASSWORD to the same password used there:
{
"mcpServers": {
"pandb": {
"command": "pandb-mcp-server",
"env": {
"PANDB_WEB_URL": "http://localhost:4224",
"PANDB_WEB_PASSWORD": "your-web-login-password"
}
}
}
}Works with Claude Code, Cursor, Windsurf, and any MCP-compatible agent. Supports listing connections, browsing tables, executing SQL, and opening tables directly in PanDB's UI.
PanDB is currently distributed from source while its first public release is prepared. Clone this repository and follow the development instructions below. Existing installations remain compatible during the transition, but legacy download channels are not PanDB release channels.
Build and run the Web edition from this checkout:
docker compose -f deploy/docker-compose.yml up --buildOpen http://localhost:4224 after the containers are ready. To publish under a reverse-proxy context path such as /pandb, use the new runtime variables:
environment:
- PANDB_PUBLIC_BASE_PATH=/pandbWhen building the frontend with an absolute asset base, set VITE_PANDB_BASE_PATH=/pandb/ before pnpm build. The legacy DBX_* forms remain supported for existing deployments.
macOS:
No additional dependencies required.
Linux (Ubuntu/Debian):
sudo apt-get install -y libwebkit2gtk-4.1-dev libgtk-3-dev libappindicator3-dev librsvg2-dev patchelf libssl-devNIXOS/NIX :
Windows:
No additional dependencies required.
makemake installs root dependencies when needed and starts the local Tauri desktop development environment.
Development builds can run alongside an installed PanDB instance and share its local data, including connections and history. Avoid changing the same connection or global setting in both windows at once.
Tip
DuckDB compilation takes a while. If you're not working on DuckDB features, skip it to speed up local builds:
# Fast checks (skip DuckDB)
make cargo-check-fast
make cargo-test-fast
# Tauri dev without DuckDB
make dev-fastThe --no-default-features flag only affects local development.
Release builds (pnpm tauri build) always include DuckDB.
Web version:
make dev-web # frontend
make dev-backend # backendDocumentation site:
make docsThe official PanDB documentation site lives in docs/. If you want to improve the website content or documentation pages, edit the files under docs/ and run make docs to preview the site locally.
For clean, reproducible local database instances, use the versioned Docker Compose recipes under deploy/database/:
make db-list
make db-verify DB=mysql@8.4JDBC agent driver development projects live in agents/:
cd agents
./gradlew testBuild artifacts from agents/drivers/<db-type>/build/libs/ are picked up by local driver install flows when available.
make packageThe installer will be in src-tauri/target/release/bundle/.
| Layer | Technology |
|---|---|
| Framework | Tauri 2 |
| Frontend | Vue 3 + TypeScript |
| UI | shadcn-vue + Tailwind CSS |
| Editor | CodeMirror 6 |
| Backend | Rust + sqlx / tiberius / redis-rs / mongodb |
- Documentation source — feature guides and tutorials
- Database Test Lab — local database recipes for development and verification
- Contributing — how to pick up issues and open PRs
- Web API reference — HTTP API for Docker/Web deployments
- Examples — CLI, MCP, Docker, and API samples
PanDB is free and open source, but ongoing maintenance, database compatibility testing, infrastructure, and release work require sustained time and resources.