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

Another Redis Desktop Manager is a graphical client for working with Redis servers from a desktop computer. It is positioned as a faster and more stable alternative to other Redis desktop tools and is designed to keep running when a database holds a very large number of keys, a case where some clients freeze or crash.

The project covers Redis cluster setups as well as single instances, and it is available for Linux, Windows and macOS. On Windows it can be installed with Chocolatey or winget, on Linux through an AppImage or Snap, and on macOS with Homebrew or a downloadable disk image. Paid listings in the Windows and Mac app stores exist as a way to support the author.

The code is written in JavaScript and released under the MIT license. Releases are published on GitHub, with a mirror on Gitee for users in China, and the README is also provided in Simplified Chinese. It is a local client, so it connects to Redis servers you already run rather than hosting data itself.

Redis Insight is a graphical client for Redis, published by Redis. It helps developers design, build and tune applications by letting them browse, filter and visualize key-value data and view values in formats such as JSON, Hex and ASCII.

It offers create, read, update and delete support for lists, hashes, strings, sets, sorted sets, streams and JSON, plus management of vector sets, including similarity search. A Workbench provides a command-line interface with command auto-complete, while Profiler shows commands sent to Redis in real time and SlowLog highlights slow operations. Pub/Sub support, bulk deletion by filter and in-context recommendations for performance and memory use round out the tool, along with interactive tutorials.

The application is built with Electron, the Monaco editor and Node.js, and it works with Redis modules. The repository licence is listed as non-standard rather than a common open-source licence, so check the repository for the exact terms before redistributing.

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.

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.

Harlequin is a SQL IDE that runs entirely in your terminal. It is a Python application built on the Textual framework, giving developers a keyboard-driven way to write queries, browse a database and view results without leaving the command line. It also ships hsql, a companion client aimed at AI coding agents.

Database support comes from adapters. Topics on the repository list DuckDB, SQLite, PostgreSQL, MySQL, MariaDB, SQL Server, ODBC, Redshift and Snowflake. Installation is recommended with uv as an isolated tool, though pip, pipx and poetry also work on Python 3.9 or newer. Detailed guides live on the project website, since the README covers only a subset.

Harlequin is MIT-licensed, runs locally on your own machine and has no hosted version. It suits developers and analysts who work over SSH or simply prefer terminal tools to graphical database clients.