DBeaver – open-source Database client

1. dbeaver

   1 31 44,429 9.9 Java

   Free universal database tool and SQL client

   

   Yes but not in the community version:

   https://github.com/dbeaver/dbeaver/wiki/Schema-compare

2. InfluxDB

   www.influxdata.com featured

   InfluxDB – Built for High-Performance Time Series Workloads. InfluxDB 3 OSS is now GA. Transform, enrich, and act on time series data directly in the database. Automate critical tasks and eliminate the need to move data externally. Download now.

   

3. harlequin

   2 22 4,745 8.4 Python

   The SQL IDE for Your Terminal.

   

4. babelfish_extensions

   3 7 296 9.6 TSQL

   Babelfish for PostgreSQL provides the capability for PostgreSQL to work with applications written for Microsoft SQL Server. Babelfish understands the SQL Server wire-protocol and T-SQL, the Microsoft SQL Server query and procedural language, so you don’t have to switch database drivers or rewrite all of your application queries.

   

   DBeaver works surprisingly nicely with less popular DBs. I work with Babelfish for PostgreSQL [1], it supports connections with SQL Server client libs. Most GUI client tools (like SSMS) expect "real" SQL Server on the other end of the wire - depend on various system views for DB introspection, so only partially work with Babelfish. Even if client tool is based on JDBC (like SQuirell SQL), it doesn't guarantee that this tool won't use additional SQL Server-specific querues for i trospection. DBeaver is much better at this, I guess it is using JDBC API or DB-neutral INFORMATION_SCHEMA views.

   [1] https://babelfishpg.org/

5. meow-sql

   4 3 420 4.5 C++

   MeowSQL is an attempt to port HeidiSQL to C++/Qt (Linux/Windows)

   

   Someone started a cross-platform rewrite at https://github.com/ragnar-lodbrok/meow-sql which has made incredible progress.

6. dbgate

   5 36 6,227 10.0 Svelte

   Database manager for MySQL, PostgreSQL, SQL Server, MongoDB, SQLite and others. Runs under Windows, Linux, Mac or as web application

   

7. Sequel-Ace

   6 25 7,047 9.2 Objective-C

   MySQL/MariaDB database management for macOS

   

   On Mac OS I use Sequel Ace for MariaDB/MySQL, it's a spiritual successor to Sequel Pro. Native UI. Works great. https://sequel-ace.com/

8. Jailer

   7 226 3,017 9.2 Java

   Database Subsetting and Relational Data Browsing Tool.

   

   Some other tools I have also enjoyed:

   DBVisualizer: https://www.dbvis.com/ (for exploring the schema)

   Jailer: https://wisser.github.io/Jailer/ (for data browsing)

   Aside from that, it's usually just been a mix of using specialized tools like MySQL Workbench, SQL Developer, pgAdmin and others, or something that tries to do it all like DataGrip.

   Didn't actually find anything particularly amazing about DataGrip, but if I'm paying for the JetBrains Ultimate subscription, might as well use it because it's pretty okay.

9. Stream

   getstream.io featured

   Stream - Scalable APIs for Chat, Feeds, Moderation, & Video. Stream helps developers build engaging apps that scale to millions with performant and flexible Chat, Feeds, Moderation, and Video APIs and SDKs powered by a global edge network and enterprise-grade infrastructure.

   

10. Adminer

    8 58 6,917 9.9 PHP

    Database management in a single PHP file

    

Suggest a related project