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

DB Browser for SQLite, often abbreviated DB4S, is a visual, open-source tool for creating, designing and editing database files compatible with SQLite. It is aimed at people who build, query and modify databases and would rather not work purely in the command line, and it uses a familiar spreadsheet-like interface. The project was previously known as SQLite Database Browser.

It is a cross-platform desktop application written in C++ with the Qt toolkit, with builds and nightly versions for Windows, macOS and Linux, including packages for Arch Linux, Debian, Fedora, openSUSE, Ubuntu, FreeBSD, Snap, Nix and Flox. The README also has sections on what the tool is and is not, links to a wiki, build instructions and release history. Chat and donation channels support the community.

The repository's license is listed as 'Other' on GitHub, so check the terms for your use. As a local desktop program there is nothing to host; you open a SQLite file and work with it directly, which makes it popular with developers, students and analysts who handle SQLite databases.

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.

Letos is a free and open-source database manager for SQLite, written in C++ with the Qt framework and available on multiple platforms. It was previously called SQLiteStudio. The rename prevents confusion with the official SQLite project, since Letos is independent and not affiliated with the SQLite authors.

The topics mention SQLCipher and wxSQLite3 support alongside general database management. Downloads come from the releases page on GitHub or from operating system package managers, older 3.x and legacy 2.x versions are archived, and Windows builds use free code signing from SignPath. The official builds contain a proprietary Icons8 icon set that is licensed to the project.

Use is free, even in commercial settings, and the maintainer invites donations from people whom it saves time. Documentation lives in the project wiki, including how to compile from source and contribute. The repository lists the license as Other. It suits developers and analysts who need a graphical tool to browse, edit and query SQLite files.

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.

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.