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

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.

Sequel Ace is a Mac database management application for working with MySQL and MariaDB databases. It is described as the sequel to the long-standing macOS tool Sequel Pro and is written in Objective-C, with documentation on its own website.

It runs on Intel and Apple Silicon Macs and is available from the Mac App Store, through the mas command-line tool, and via an unofficial community Homebrew cask. Older releases are provided for older versions of macOS and MySQL, but the maintainers state that no support is given for them. The README also describes a built-in Model Context Protocol server that lets AI agents query databases using the connections already saved in Sequel Ace. It is disabled until you enable it, accepts only local connections and is read-only.

Development is supported by sponsorships through Open Collective and GitHub Sponsors. The repository lists its licence as other, so check the project for its exact terms.

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.

TablePro is a database client for macOS written in Swift with native frameworks, with no Electron, JDBC or JavaScript runtime involved. Its author describes it as the open-source, native tool they wished TablePlus would be, and the README compares it with single-database clients such as Sequel Ace for MySQL and Postico for PostgreSQL.

It connects to SQL and NoSQL databases through native drivers, including MySQL, PostgreSQL, SQLite, SQL Server, MongoDB and Redis, and offers a SQL editor and database GUI. AI is built in through chat, inline suggestions and an MCP server, so tools like Cursor, Raycast or Claude Desktop can work with your databases. You bring your own API key, choose your provider, or run models locally with Ollama.

TablePro is licensed under AGPL-3.0 and free to use. It runs as a desktop application on your Mac, so there is no server to host. It suits developers who want a fast native client and an open-source alternative to commercial macOS database tools.