DBX vs SQL Data Dictionary

DBX is a free, open-source workspace for database connections, object browsing, SQL editing, data changes, schema work, and automation. It supports more than 100 databases and data systems across relational, NoSQL, vector, time-series, embedded, and messaging categories. The CodeMirror 6 SQL editor includes metadata-aware autocomplete, formatting, selected-query execution, diagnostics, history, and saved snippets. Other tools cover virtualized data grids, schema browsing and comparison, ER diagrams, field lineage, imports, exports, and transfers between connections. Its AI SQL assistant works with Claude, OpenAI, local models through Ollama, and OpenAI-compatible endpoints. DBX also has MCP integrations for compatible agents and a command-line interface. It runs as a desktop app on macOS, Windows, and Linux, or as a self-hosted Docker web deployment. Safeguards include read-only connections, confirmations for production writes, reviewable SQL changes, MCP access policies, and encrypted configuration exports. Stored credentials are encrypted, and the plugin store offers signed, sandboxed extensions.

SQL Data Dictionary has no write-up on Specifiction yet; its figures are above.