Overview

DBX is a lightweight, 25 MB database client that runs on Windows, macOS, and Linux. It bundles connection management, an SQL editor, a data grid, and a schema viewer into one tiny package. The tool is free and open‑source, with a GitHub repository that has over 27 k stars.

The core workflow of DBX starts with creating a connection to a database. Supported engines include MySQL, PostgreSQL, SQLite, Redis, MongoDB, DuckDB, SQL Server, Dameng, and many others listed on the site. A single connection window lets you pick the driver, enter credentials, and test the link. Once connected, the left pane shows schemas, tables, fields, indexes, foreign keys, and triggers. Navigation is straightforward: click a table to open a virtual‑scrolled grid, edit rows inline, and use the built‑in WHERE/ORDER BY controls to filter or sort data.

On the right side you find the SQL editor, built with CodeMirror 6. It offers metadata completion, formatting, and a query history pane. A “preview” button lets you see the generated SQL before executing it. After execution, results appear in the data grid, and you can export them to CSV or copy the SQL to the clipboard. The editor also supports SQL files, so you can load scripts and run them as a batch. In addition to ordinary SQL, DBX can execute database‑specific commands like schema migration, table import, and cross‑engine data transfer.

DBX's AI assistant is an optional feature. When enabled, the assistant can generate SQL from natural language queries, explain results, or suggest optimizations. The assistant is integrated into the main UI; you type a question in the chat panel and receive a response that can be copied back into the editor. Also, DBX ships an MCP Server that allows external tools such as Claude Code to query your databases directly through the client's local API.

The application supports three deployment modes: a standard desktop installer (25 MB), a Docker image, and a command‑line interface. The Docker build uses the official Docker Hub image, while the CLI allows you to run DBX headless for scripting or automation. For environments without internet access, the installer can use an offline package that excludes database drivers but still includes the app and its WebView2 runtime.