Open-source DBCode alternatives

DBeaver is a free, multi-platform database tool aimed at developers, SQL programmers, database administrators and analysts. A single desktop application lets you browse schemas, write and run SQL, edit data and administer many different database systems, instead of switching between vendor-specific clients.

Its feature set covers a schema editor, an SQL editor, a data editor, ER diagrams, data export, import and migration, SQL execution plans, administration tools, database dashboards, a spatial data viewer, proxy and SSH tunneling, and an editor for custom database drivers. An AI chat integrates AI tools for working with data, SQL and database structure. More than 100 drivers are supported out of the box, and anything with a JDBC or ODBC driver can be connected.

DBeaver is a Java application, with OpenJDK included in all distributions so no separate Java install is needed. It is Apache-2.0 licensed and can be downloaded as prebuilt binaries from the website or GitHub releases, with an Early Access build published daily. The vendor also sells paid editions with additional capabilities.

Chat2DB is a free desktop database client and SQL workspace aimed at developers, DBAs, analysts and data teams on any platform. The Community edition runs entirely on your own machine on Windows, macOS and Linux, and pairs a full SQL editor with an AI assistant that you connect to the model of your choice rather than one bundled with the app.

It connects to more than 40 databases, including MySQL, Oracle, PostgreSQL, SQL Server, MongoDB, Redis, ClickHouse, SQLite, MariaDB, TiDB, Snowflake and BigQuery, and new JDBC databases can be added through configuration alone. The SQL workspace covers editing, completion, formatting, execution, saved queries and history. Database management features let you browse metadata, manage tables and other objects and edit data in place, and there are tools for data import and export, dashboards and charts, plus a command line interface.

The AI assistant generates, explains and optimizes SQL from natural-language requests, and topics mention MCP support. Chat2DB is written in Java and powered by OtterMind, and its license is listed as 'Other' on GitHub, so check the terms before redistribution. It suits people who want one tool for many databases and would like to keep queries and credentials local.

DBX is a cross-platform database client built with Rust and Tauri, billed as lightweight at around 25 MB. It connects to more than a hundred databases, among them SQLite, MySQL, PostgreSQL, MongoDB, Redis, DuckDB, SQL Server and Dameng, and aims to cover many systems with one small application instead of several heavier tools.

Beyond the desktop app, it can be run through Docker and a command line interface, and it includes a built-in AI assistant and an MCP server, so AI tools can query and work with your databases through a standard protocol. The interface is built with Vue, and topics highlight support for ClickHouse, MySQL, MongoDB, PostgreSQL, Redis, SQL Server and SQLite along with general database management features. The project was created in 2026 and its documentation includes Chinese-language material.

DBX is Apache-2.0 licensed. It is meant for developers and administrators who want a fast, small client that works across relational and NoSQL systems, and who like the idea of connecting AI assistants to databases through MCP.

Beekeeper Studio is a modern, easy-to-use SQL editor and database manager for Linux, macOS and Windows. It supports a long list of databases, including PostgreSQL, MySQL, SQLite, SQL Server, Amazon Redshift, CockroachDB, BigQuery, Cassandra and Firebird, and is built with TypeScript and Electron.

It is free to download and offers many features at no cost, with no sign-up, registration or credit card required. Some premium features are sold under a paid license. The repository explains the arrangement: most of the code is open source under the GPLv3, while the paid features live in the same repository under a commercial source-available license. A table in the README shows which databases have full support in the community and paid editions.

The project welcomes community contributions and has translated READMEs in a dozen languages. Because its license is listed as 'Other' on GitHub, it is worth reading the terms to see which parts are free. It suits developers and analysts who want a clean, approachable client for everyday querying and schema browsing.

DbGate is a cross-platform database client for working with several databases at once. It supports SQL and NoSQL systems including MySQL, PostgreSQL, SQL Server, Oracle, MongoDB, Redis, SQLite, MariaDB, CockroachDB, ClickHouse, Cassandra and DuckDB, and runs on Windows, Linux and macOS or as a web application.

Day-to-day tools include table browsing with Excel-like and multi-value filters, table data editing with a preview of the generated SQL change script, schema editing for indexes and keys, and an SQL editor. More advanced features include comparing and synchronizing database structure, ER diagrams, a visual query designer that builds queries without hand-written SQL, master/detail views, foreign key lookups, a JSON view for MongoDB collections, and batch export and import.

The Community edition is licensed under GPL-3.0 and is free to use for any purpose. The web version can be run as an NPM package or Docker image, a Node.js scripting interface is available, and an online demo lets you try it first. The README marks some database drivers, such as Amazon Redshift and CosmosDB, as Premium.

WhoDB is a single workspace for browsing databases, changing rows, running queries and seeing how a schema is put together. It works in a browser, is straightforward to self-host, and is also available as a desktop app and a terminal CLI. The authors position it for inspecting a local database or helping a teammate explore unfamiliar data without a heavyweight client.

Optional AI features let you ask questions in plain English by hooking up a local or hosted model through Ollama, LM Studio, OpenAI, Anthropic or any compatible API. Repository topics also mention an SQL editor, a visual query builder, ER diagrams, text-to-SQL, data lineage and catalog features, and an MCP server. MySQL, PostgreSQL, SQL Server and Oracle are among the topics, and the backend is written in Go.

WhoDB is licensed under Apache-2.0 and offers a live demo and documentation. It suits developers, analysts and internal tool builders who want a simple database front end that they control, rather than a heavyweight client.

Outerbase Studio is a lightweight graphical client for SQL databases that runs in the browser. It started as a tool for LibSQL and SQLite and now covers several SQLite-based services, including Turso, local SQLite files, Cloudflare D1, rqlite, StarbaseDB and Val.town. MySQL and PostgreSQL are supported in beta with a reduced feature set.

The query editor offers auto-completion and function hints and can run several queries at once. The data editor lets you stage edits and preview them before committing, and its table view is built to handle thousands of rows and columns. A schema editor creates, changes and removes columns without hand-written SQL, and a connection manager stores connections in the browser or on a server so they can be shared across devices.

A desktop edition for Windows and Mac wraps the web app in Electron, which allows drivers that cannot run inside a browser, such as the MySQL and PostgreSQL ones. The code is TypeScript and licensed under AGPL-3.0, and a hosted version is available at studio.outerbase.com.