Open-source SQLyog 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.

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.

Adminer is a database management tool written in PHP and distributed as a single file that you drop onto a server. It offers a web interface for browsing, querying and editing databases, and serves as a lighter alternative to heavier admin suites.

Supported systems are MySQL, MariaDB, PostgreSQL, CockroachDB, SQLite, MS SQL and Oracle, with plugins adding Elasticsearch, OpenSearch, SimpleDB, MongoDB, Redis, Firebird, ClickHouse, IGDB and IMAP. A related tool, Adminer Editor, provides data manipulation for end users rather than administrators. The compiled single file needs PHP 5.3 or later, while the source code needs PHP 7.4 or later, and many user-contributed plugins are listed on the plugins page.

The development version can be run from the adminer and editor directories, a compile script produces the single-file build, translations are updated with a language script, and end-to-end tests use Playwright. The repository lists the license as Other. Adminer suits developers and administrators who need quick access to a database from the browser.

phpMyAdmin is free software written in PHP that administers MySQL and MariaDB through a web browser. It provides an interface for managing databases, tables, columns, relations, indexes and users, and it also lets you run SQL commands directly.

Operations include browsing, creating, copying, renaming and dropping databases, tables, fields and indexes, plus managing views, stored procedures and triggers, and managing MySQL user accounts and privileges. Statements can be executed, edited and bookmarked, including batch queries. Data can be imported from CSV and SQL and exported to formats such as CSV, SQL, XML and PDF. Multi-server administration allows control of several MySQL servers from one place, and the server maintenance pages offer configuration suggestions.

The interface is translated into 98 languages, including both left-to-right and right-to-left scripts. The project is licensed under GPL-2.0, is a member of the Software Freedom Conservancy, and offers a public demo so you can try it before installing it on your own web server.

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.