DBeaver – open-source Database client

• dbeaver

  27 37,679 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

• harlequin

  14 2,640 9.3 Python

  The SQL IDE for Your Terminal.

• InfluxDB

  www.influxdata.com featured

  Power Real-Time Data Analytics at Scale. Get real-time insights from all types of time series data with InfluxDB. Ingest, query, and analyze billions of data points in real-time with unbounded cardinality.

  

• babelfish_extensions

  7 263 9.7 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/

• meow-sql

  3 385 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.

• dbgate

  27 4,409 8.0 Svelte

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

  

• Sequel-Ace

  24 6,473 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/

• Jailer

  218 2,715 9.6 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.

• SaaSHub

  www.saashub.com featured

  SaaSHub - Software Alternatives and Reviews. SaaSHub helps you find the best software and product alternatives

  

• Adminer

  53 6,066 0.0 PHP

  Database management in a single PHP file

Suggest a related project