DBeaver is a free desktop program for working with databases, letting you write queries, browse data, and move or export information between systems. It is aimed at developers, database administrators, and analysts who manage data.
Has 4 of 6
How many people bookmarked its code on GitHub. It shows how popular it is, not how good it is or how well it replaces the app.
How hard it is to start using it. Easy: install it like a normal app, or use it in your browser. Advanced: you run it on your own server, use the command line, or it is a tool for developers.
Its code changed within the last year, so someone is still looking after it.
Does the whole job.
Ordered by how fully it replaces the app, Verified, setup and, when there are enough, people's votes.
Beekeeper Studio is a program for viewing and working with databases, the places where organizations store their information. It is made for people who write and run database queries, and it runs on Linux, Mac, and Windows.
Has 2 of 6
How many people bookmarked its code on GitHub. It shows how popular it is, not how good it is or how well it replaces the app.
How hard it is to start using it. Easy: install it like a normal app, or use it in your browser. Advanced: you run it on your own server, use the command line, or it is a tool for developers.
Its code changed within the last year, so someone is still looking after it.
Does the whole job.
Ordered by how fully it replaces the app, Verified, setup and, when there are enough, people's votes.
pgAdmin is a free tool for managing PostgreSQL databases, the kind that stores information for websites and businesses. It is for people who build, check, and run those databases, and it can run in a web browser or as a desktop program.
Has 1 of 6 · Works with many databases ✗
How many people bookmarked its code on GitHub. It shows how popular it is, not how good it is or how well it replaces the app.
How hard it is to start using it. Easy: install it like a normal app, or use it in your browser. Advanced: you run it on your own server, use the command line, or it is a tool for developers.
Its code changed within the last year, so someone is still looking after it.
Does part of the job.
Ordered by how fully it replaces the app, Verified, setup and, when there are enough, people's votes.
SQLAlchemy is a toolkit for Python programmers that helps their programs talk to SQL databases, both by writing queries in Python and by mapping database tables to Python objects. It is for software developers who build applications that store data in databases.
Has 0 of 6 · No commands needed ✗ +3
How many people bookmarked its code on GitHub. It shows how popular it is, not how good it is or how well it replaces the app.
How hard it is to start using it. Easy: install it like a normal app, or use it in your browser. Advanced: you run it on your own server, use the command line, or it is a tool for developers.
Its code changed within the last year, so someone is still looking after it.
Does part of the job.
Ordered by how fully it replaces the app, Verified, setup and, when there are enough, people's votes.
None of these match. Try another device.
Help me choose
I want to pick an open-source replacement for Navicat. Below is a list from Open Source Everything (CC BY-SA 4.0), in the order its website shows it. The order is a starting point, not a verdict.
- DBeaver Community: DBeaver is a free desktop program for working with databases, letting you write queries, browse data, and move or export information between systems. It is aimed at developers, database administrators, and analysts who manage data. [Easy setup; Windows · Mac · Linux; replaces fully; Apache-2.0; https://github.com/dbeaver/dbeaver]
- Beekeeper Studio: Beekeeper Studio is a program for viewing and working with databases, the places where organizations store their information. It is made for people who write and run database queries, and it runs on Linux, Mac, and Windows. [Easy setup; Windows · Mac · Linux; replaces fully; GPL-3.0-or-later; https://github.com/beekeeper-studio/beekeeper-studio]
- pgAdmin: pgAdmin is a free tool for managing PostgreSQL databases, the kind that stores information for websites and businesses. It is for people who build, check, and run those databases, and it can run in a web browser or as a desktop program. [Easy setup; Windows · Mac · Linux; replaces partly; PostgreSQL; https://github.com/pgadmin-org/pgadmin4]
- SQLAlchemy: SQLAlchemy is a toolkit for Python programmers that helps their programs talk to SQL databases, both by writing queries in Python and by mapping database tables to Python objects. It is for software developers who build applications that store data in databases. [Advanced setup; Windows · Mac; replaces partly; MIT; https://github.com/sqlalchemy/sqlalchemy]
Setup rating: "Easy setup" means you can install it like a normal app, use it in a browser. "Advanced setup" means you must run it on your own server or use the command line, or it is a tool for developers.
Full details: https://opensourceeverything.org/data/groups/database-tools.json
Before recommending anything, ask me these three questions (one at a time, in plain words): 1) Which device or devices will I use it on (Windows, Mac, Linux, Android, iPhone)? 2) How comfortable am I with technical setup: only installing apps from a store, happy to follow a step-by-step guide, or comfortable with servers and the command line? 3) What is my budget: free only, or willing to pay for hosting or support? Then recommend one to three projects from this list only, and for each say why, using how fully it replaces the app, its setup rating, and the devices it runs on. If nothing on the list fits me, say so plainly instead of stretching.
Before you build
Read the list of open-source projects at https://opensourceeverything.org/data/groups/database-tools.json. Compare it with my project or idea below. Tell me which projects overlap, what I could reuse instead of rewriting, and what mine does that none of them do.
My project or idea:
