DBX is an open-source, lightweight, cross-platform database client designed for developers and power users. It simplifies management across a wide array of databases, including SQL and NoSQL variants, by offering a unified interface with advanced features like an AI SQL assistant and instant file previewing, aiming to boost productivity.

How It Works

Built with the Tauri 2 framework, DBX combines a Rust backend (utilizing sqlx, tiberius, redis-rs, mongodb) with a Vue 3 + TypeScript frontend. This architecture enables a compact ~15MB installer without a bundled Chromium, prioritizing native performance and a smaller footprint. The UI is crafted with shadcn-vue and Tailwind CSS, featuring CodeMirror 6 for an enhanced code editing experience.

Quick Start & Requirements

• Install:
  • macOS: brew install --cask t8y2/tap/dbx
  • Windows: scoop bucket add dbx https://github.com/t8y2/scoop-bucket then scoop install dbx
• Prerequisites (Development): Node.js >= 18, pnpm, Rust >= 1.77.
• Development: Run pnpm install then pnpm tauri dev.
• Build: Execute pnpm tauri build; the installer is located in src-tauri/target/release/bundle/.
• macOS Note: DBX is not signed. On first launch, users must run xattr -cr /Applications/dbx.app or select "Open Anyway" in System Settings → Privacy & Security.

Highlighted Details

• Extensive Database Support: Connects to MySQL, PostgreSQL, SQLite, Redis, MongoDB, DuckDB, ClickHouse, SQL Server, Oracle, MariaDB, TiDB, OceanBase, openGauss, GaussDB, KingBase, Vastbase, and GoldenDB.
• AI SQL Assistant: Integrates with Claude/OpenAI for natural language to SQL queries, query explanation, optimization, and error correction.
• Interactive Data Grid: Features virtual scrolling, inline editing, sorting, search, pagination, and column resizing for efficient data manipulation.
• Instant File Preview: Drag-and-drop support for Parquet, CSV, and JSON files, with instant preview powered by DuckDB.
• Specialized Browsers: Includes dedicated interfaces for Redis (key pattern search, value viewing) and MongoDB (document CRUD, direct URL connections).

Maintenance & Community

• Community: WeChat Group, QQ Group.
• Contributors: Listed in the README.

Licensing & Compatibility

• License: MIT License.
• Compatibility: The MIT license is permissive, generally allowing commercial use and integration into closed-source projects.

Limitations & Caveats

macOS users face an initial hurdle requiring manual security bypass due to the application not being Apple-signed.