dbx

DBX is an open-source, lightweight database management tool built with Rust, designed as a single small binary (~25 MB) that runs on macOS, Windows, and Linux without requiring Java JRE, Python venv, or bundled Chromium. It supports over 90 databases including MySQL, PostgreSQL, SQLite, Redis, MongoDB, DuckDB, ClickHouse, SQL Server, Oracle, Elasticsearch, Meilisearch, MariaDB, TiDB, OceanBase, openGauss, GaussDB, Doris, StarRocks, Redshift, DM (Dameng), TDengine, CockroachDB, and many more. Agent-based profiles extend support to H2, Snowflake, Trino, PrestoSQL, Hive, DB2, Informix, Neo4j, Cassandra, BigQuery, Cloud Spanner, 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, Consul KV, IRIS, and more. Message queue admin is available for Pulsar, Kafka, and RocketMQ. The tool offers multiple deployment modes: a native desktop application, a Docker-based web version for self-hosted team access, a CLI package for terminal and scripting workflows, and a standalone MCP (Model Context Protocol) server that enables AI coding agents like Claude Code, Cursor, and Windsurf to query databases through connections configured in DBX. The MCP server is distributed independently and can be installed via npm or as precompiled native binaries for macOS, Linux, and Windows. Key features include a CodeMirror 6-based query editor 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. The virtual-scrolled data grid handles large result sets with 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 tools include a schema browser (databases, schemas, tables, columns, indexes, foreign keys, triggers, with sidebar search and pin), an object browser (grouped procedures, functions, views, and source editing where supported), a table structure editor (reviewable column and index changes for supported engines), ER diagram visualization, schema diff comparison across connections, explain plan visualization, field lineage analysis, and database search across large schemas. Data operations cover table import from CSV and Excel, data transfer between databases, full database export, data comparison with synchronization output review, SQL file execution, file preview (drag and drop Parquet, CSV, JSON to preview instantly powered by DuckDB), and connection import from DBeaver or Navicat. The built-in AI SQL assistant allows users to describe queries in plain language and receive SQL back, with support for Claude, OpenAI, local models via Ollama, or any OpenAI-compatible endpoint. AI-generated SQL passes through built-in safety checks before execution. The MCP server provides read-only, safe-write, and high-risk-write access modes with connection allowlist management. The machine-readable values are read_only, safe_write, and high_risk_write. Specialized browsers are available for Redis (key pattern search, batch key operations, command runner, TTL editing, and all data types including String, Hash, List, Set, ZSet, Stream) and MongoDB (document CRUD with pagination, Atlas and replica set URL connection). Safety and connectivity features include SSH tunnel (key and 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. The UI supports dark mode with native title bar sync, 9 editor themes, English, Simplified Chinese, and Spanish, layout preferences, and built-in auto-update. Installation is available through Homebrew (macOS), Scoop and WinGet (Windows), Flatpak (Linux), direct download from GitHub Releases, and Docker for self-hosted deployments. The CLI can be installed via npm or Homebrew. Docker deployments use the t8y2/dbx:latest image with a cross-platform named volume for data persistence, and a CNB mirror image is available for faster pulls in China. The project is sponsored by several cloud and AI infrastructure providers including RainYun, TrustAsia, Jalapeño Cloud, UCloud, HuaLongAI, Atlas Cloud, and Qiniu Cloud, and partners with 1Panel and Easysearch.