Introducing
The Slant team built an AI & it’s awesome
Find the best product instantly
Add to Chrome
Add to Edge
Add to Firefox
Add to Opera
Add to Brave
Add to Safari
Try it now
4.7 star rating
0
What is the best alternative to SQLGate?
Ad
Ad
DBeaver
All
10
Experiences
Pros
6
Cons
3
Specs
Top
Pro
Cross-platform
Supported on Windows (2000/XP/2003/Vista/7/8/10), Linux, Mac OS and Solaris (x86).
See More
Top
Con
Never-ending function errors
Like, 'Communications link failure', 'Connection refused' (Community Edition 6.2.1).
See More
Top
Pro
Free
It is licensed under GPL v2.
See More
Top
Con
Cannot view function
See More
Top
Pro
Works for many types of databases
MySQL, Oracle, PostgreSQL, IBM DB2, Microsoft SQL Server, Microsoft Access, Sybase, Java DB (Derby), Firebird (Interbase), Derby (JavaDB), SQLite, Mimer, HSQLDB, H2, IBM Informix, Teradata, SAP MAX DB, Cache, Ingres, Linter, Vertica, MongoDB, Cassandra, ODBC, Any JDBC compliant data source.
See More
Top
Con
Trigger edition
Until version 3.5.8 you can not edit triggers, only view (since 3.5.6).
See More
Top
Pro
Follow foreign key to their primary key
If you have a table with a foreign key you can click on it to see the table row where this key references to.
See More
Top
Pro
Formatted text view
It has the classic grid view and a well-organized text view that you can quick-select with CTRL-A.
See More
Top
Pro
Easy to use, clean neat inteface
See More
Specs
Platforms:
Windows, Linux, MacOS
Technology:
Java
Database management:
PostgreSQL, MySQL, Oracle, IBM DB2, SQL Server, Access, Sybase, Firebird, Derby (JavaDB), SQLite, Mimer, HSQLDB, H2, IBM Informix, Teradata, SAP MAX DB, Cache, Ingres, Linter, Vertica, MongoDB, Cassandra, ODBC, Any JDBC compliant data source
Hide
See All
Experiences
Free / paid
1323
134
Valentina Studio
All
5
Experiences
Pros
4
Specs
Top
Pro
Free version
You can download a free version from the app store.
See More
Top
Pro
Multi DB
Supports several databases, MySQL/ MSSQL / PostGresSQL / and more
See More
Top
Pro
Cross-platform
Valentina Studio works on Windows, Linux and OS X.
See More
Top
Pro
Good UI
Valentina Studio has a responsive and clean user interface.
See More
Specs
Platforms:
Windows, Linux, Mac
Technology:
C++, QT
Hide
Get it
here
46
21
QueryPie
All
10
Experiences
Pros
6
Cons
3
Specs
Top
Con
Requires creating an account
Requiring an account is rare on SQL IDEs...
See More
Top
Pro
Clean and pretty UI/UX
The default color is dark and comfortable for the eyes.
See More
Top
Con
Still in beta
See More
Top
Pro
Multiple Query Tabs!
The multi-tab and multi-SQL-runs are great. It's always good to be able to compare results in one window instead of having to go through and re-run stuff.
See More
Top
Con
No visualization
See More
Top
Pro
Fast Auto-complete
See More
Top
Pro
Multiple Databases
They only support 2 at the moment (MySQL and MariaDB) but their social site says they'll be updating with more DBMSes in the near future which is pretty nice because I hate learning new GUIs~
See More
Top
Pro
Cross-Platform
Not sure about Linux but it works on Windows and Mac just fine!
See More
Top
Pro
Free!
See More
Specs
Platforms:
Mac, Windows, Linux
Auto Complete:
Fast auto-complete on queries
Database management:
PostgreSQL, MariaDB, MySQL, AWS Aurora
Hide
See All
Experiences
Free / paid
72
4
DbVisualizer
All
6
Experiences
Pros
4
Cons
1
Specs
Top
Pro
Professional tool
This is a good and stable tool with really good and useful functionality: import/export, SSH tunnelling, fast searching, duplication, DDL visualization etc. If you are a professional, don't complain about the pricing. If you're an amateur, maybe this isn't for you.
See More
Top
Con
Expensive
License for the full product is costly.
See More
Top
Pro
Duplicate row button
Makes it really easy to stub out example data while developing, just change the values with unique constraints and you have extra data ready to go.
See More
Top
Pro
Wildcard finder
Has a search box that will highlight any matching row, regardless of what field is matched (spans multiple columns).
See More
Top
Pro
In-line editing
Allows you to edit and save db rows through a spread-sheet like editor.
See More
Specs
Platforms:
Windows, Linux, Mac
Technology:
Java
Hide
Get it
here
97
10
DataGrip
All
13
Experiences
Pros
9
Cons
3
Specs
Top
Pro
Supports multiple languages
DataGrip is not a language-specific IDE. It supports a wide variety of languages by default, such as PostgreSQL, MySQL, Oracle, Microsoft SQL Server, Derby, H2, Sqlite, and many more. You can also specify your own JDBC drivers to get support for additional platforms.
See More
Top
Con
Performance can be slow/sluggish when working with high-volume databases
As with all other IDEs, DataGrip is powerful and thus requires more resources than usual. It can use up to several GB's of memory when working with high-volume databases, and this has an impact on performance if your system is not equipped to handle it.
See More
Top
Pro
Much more powerful than its counterparts
DataGrip is a full-featured IDE for working with databases and SQL. It includes commonly found features in database clients, and offers IDE-specific features beyond that — version control, autocompletion, refactoring support, etc.
See More
Top
Con
Not user friendly
For incompetent users that do not have any idea what they are doing this, and any similar product will not seem user friendly. For nearly everyone else this is yet another amazing IDE from the JetBrains family; a must have!
See More
Top
Pro
Beautiful and customizable UI
DataGrip currently provides two theme options, light and dark. The UI is intuitive to navigate and provides powerful features such as a diagram view of table relationships.
See More
Top
Con
Expensive
This is an annual subscription with tiered pricing that diminishes a small amount year over year. But there are other much cheaper or free alternatives. This is the premium priced product of the bunch.
See More
Top
Pro
Helps you avoid mistakes
It can catch SQL bugs and suggest ways to resolve them. It will inform of unresolved objects and the use of keywords as identifiers.
See More
Top
Pro
Refactoring support
You can refactor SQL code with DataGrip — it resolves all references automatically and when an object/variable is renamed, you can choose to update all references to it in your project.
See More
Top
Pro
Powerful data editor
A powerful data editor lets you add, remove, edit, and clone data rows. Navigate through the data by foreign keys and use the text search to find anything in the data displayed in the table editor. All your changes are stored locally and can be submitted at once. Multiple fields can also be edited at once.
See More
Top
Pro
Version control support
DataGrip supports a wide variety of VCS tools out of the box so that you can edit, test, and commit changes without ever leaving the tool.
See More
Top
Pro
Excellent code completion
DataGrip's code completion is context-sensitive and schema-aware code completion. It will take into account tables structure, foreign keys, and even database objects created in your code.
See More
Top
Pro
Cross-platform
See More
Specs
Platforms:
Windows, Linux, Mac
Technology:
Java
Hide
See All
Experiences
$ 89/Y
322
41
HeidiSQL
All
17
Experiences
Pros
10
Cons
6
Specs
Top
Pro
Free
Licensed under GNU GPL.
See More
Top
Con
Can be buggy
HeidiSQL is known to have some bugs that results in crashes.
See More
Top
Pro
Portable
Alongside the possibility of downloading the installer and sourcecode, a portable version of the software is available.
See More
Top
Con
Intellisense is not intelligent
No intellisense for columns unless table name is aliased.
See More
Top
Pro
Great UI and ease of use
HeidiSQL has a comprehensive and intuitive interface.
See More
Top
Con
UI design is very bad
Generic windows form
See More
Top
Pro
Syntax completion
See More
Top
Con
No session backup
You cannot recover your session after close or even worse crash.
See More
Top
Pro
Lightweight
See More
Top
Con
Works under Linux only with Wine
It works quite well under Wine with Linux, but you must always take notice if the last version of HeidiSQL has been tested, for it may not run at all. There are some bugs in the Wine version that can be annoying and you have to kill the program and restart it. A native Linux version would be great.
See More
Top
Pro
Great user management
The user manager of HeidiSQL can easily set privileges on a per-database level or give access to only certain commands.
See More
Top
Con
No built-in debugger included
See More
Top
Pro
Data synchronization
HeidiSQL can compare and synchronize your data and structure between local and remote databases.
See More
Top
Pro
SSH tunnel
HeidiSQL allows connecting to your MySQL database via SSH tunnel.
See More
Top
Pro
Connect to servers via command line
You can use command line parameters to automate connections.
See More
Top
Pro
Works fine with Wine under Linux
See More
Specs
Platforms:
Windows
License:
GPL-2.0
Technology:
Delphi
Database management:
PostgreSQL, MariaDB, MySQL, SQL Server, SQLite
Hide
See All
Experiences
FREE
437
69
ERBuilder
All
7
Experiences
Pros
6
Specs
Top
Pro
Ease of use
See More
Top
Pro
Affordable
Very affordable compared to pricey alternatives.
See More
Top
Pro
Supports many databases
See More
Top
Pro
ER Builder is easy to use and a complete modeling tool
Very interesting tool, powerful and easy to use. Can do reverse and forward engineering, generate SQL script, and more.
See More
Top
Pro
Lightweight
Small install size.
See More
Top
Pro
Supports Amazon Redshift data modeling
See More
Specs
Platforms:
Windows
Hide
See All
Experiences
49$+
22
0
SQL Workbench/J
All
4
Experiences
Pros
3
Specs
Top
Pro
Allows you to edit changes before they are executed.
Any changes to the database generate SQL statements that you can review and edit before running.
See More
Top
Pro
Works with almost any SQL database
Can work with any database with a jdbc driver.
See More
Top
Pro
Can edit data in table mode.
Easy to make changes when viewing data.
See More
Specs
Platforms:
Windows, Linux, Mac
Technology:
Java
Hide
Get it
here
42
16
DbSchema
All
8
Experiences
Pros
7
Specs
Top
Pro
Graphical Diagram Editor
Includes the possibility to edit tables and data directly in the diagram without writing SQL statements.
See More
Top
Pro
Multi-platform
Runs on Windows, Mac, and Linux.
See More
Top
Pro
Virtual Foreign Keys
If the Database schema is missing real foreign keys, it is possible to create virtual ones to be used within the tool.
See More
Top
Pro
Generator for Random Data
Includes the possibility to generate random numerical data or fetch random entries from a text file to populate the database.
See More
Top
Pro
Generate schema from existing database
Includes the possibility to generate an ER diagram from an existing database.
See More
Top
Pro
SQL editor with syntax highlighting
Includes an SQL editor with syntax highlighting and code completion feature.
See More
Top
Pro
Graphical Query Editor
Includes a visual query editor capable of using different join types, filters as well as the 'group by' clause.
See More
Specs
Platforms:
Windows, Linux, Mac
Technology:
Java
Price (2023-06-26):
196$ + Taxes
Hide
See All
Experiences
$127
17
0
DbDesigner
All
5
Experiences
Pros
3
Cons
1
Specs
Top
Pro
Templates
Has lots of templates with example database designs.
See More
Top
Con
Beta
Seems to be in beta status.
See More
Top
Pro
Reverse and forward engineering
Supports MySQL, PostgreSQL and Oracle reverse engineering. Support for MS SQL and SQLite is planned.
See More
Top
Pro
Generic design
Can create a "generic" design for all supported databases.
See More
Specs
Platforms:
Web
Hide
Free / paid
9
0
SchemaCrawler
All
6
Experiences
Pros
3
Cons
2
Specs
Top
Con
Need Java
See More
Top
Pro
Many options for output formats in addition to graphical
The text-based output serves for database documentation, and is designed to be diff-ed against other database schemas.
See More
Top
Con
Does not work with schema dumpfiles
SchemaCrawler has no methods for dealing with when you only have a schema generated via something like (mysqldump --no-data [options] >schema-only_dump.sql) , and do not currently have access to a live database to connect with.
See More
Top
Pro
Extensive and detailed documentation online
Including visuals of the results of command-line option usage.
See More
Top
Pro
Free
See More
Specs
Platforms:
Windows, Linux, Mac
Technology:
Java
Hide
Free
8
0
A5:SQL Mk-2
All
5
Experiences
Pros
3
Cons
1
Specs
Top
Pro
ER diagrams
Supports two-way Entity Relationship diagrams.
See More
Top
Con
Website
The website is mostly in Japanese.
See More
Top
Pro
Excel support
Support for Excel input and output.
See More
Top
Pro
Portable
Can be made portable by simply creating a folder "Portable" in the app folder.
See More
Specs
Platforms:
Windows
Hide
Free
5
0
SchemaSpy
All
6
Experiences
Pros
2
Cons
3
Specs
Top
Pro
Entity Relationship Digramming for nearly any JDBC-compliant database
SchemaSpy can analyze database metadata in order to reverse engineer ER (Entity Relationship) diagrams for any JDBC-compliant database which includes Oracle, MySQL, Sql-Server and Postgres among others.
See More
Top
Con
Does not work with schema dumpfiles
SchemaSpy has no methods for dealing with when you only have a schema generated via something like (mysqldump --no-data [options] >schema-only_dump.sql) , and do not currently have access to a live database to connect with.
See More
Top
Pro
Has a GUI option available
SchemaSpy is a CLI tool. For people who prefer GUI-based tools there's one available from a different maintainer which stands on top of the CLI version.
See More
Top
Con
GUI option is a separate download by a different maintainer
Since the GUI version is from a different maintainer, it may be abandoned and eventually break if SchemaSpy development continues beyond that. Or it may implement new features much later than the CLI version.
See More
Top
Con
Project may be dead or dying
The codebase on sourceforge hasn't seen an update since 2010.
See More
Specs
Platforms:
Windows, Linux, Mac
Technology:
Java
Database management:
JDBC-compliant
Hide
Get it
here
13
1
Navicat for PostgreSQL
All
5
Experiences
Pros
4
Cons
1
Top
Con
Expensive
Navicat is quite expensive at $149 for the standard edition, and $199 for enterprise.
See More
Top
Pro
Fast UI
The Navicat UI is extremely quick to respond to requests.
See More
Top
Pro
Good autocomplete
Navicat offers a strong code completion feature.
See More
Top
Pro
Saves queries by name
See More
Top
Pro
Very stable
See More
Hide
Get it
here
80
5
AQT
All
4
Experiences
Pros
4
Top
Pro
Intuitive visual data explorer
A visual data explorer to view your SQL result set and easily total, sort, format, and group it (grouping is done by dragging columns to the header and groups can easily be collapsed/expanded and show column subtotals). You can also freeze columns on the left to for easy viewing of wide result sets, copy any row or rows to excel or other tool including column headings and get totals by highlighting adjacent columns.
See More
Top
Pro
Easy scripting language for repeatable processes
See More
Top
Pro
Point-and-click data loader
A point-and-click data loader that generates your create table statement when creating a new table and includes the ability to add column expressions to alter/clean your source data during the load.
See More
Top
Pro
Visual query builder
A robust visual query builder that has the ability to easily create SQL including complex sub-queries, supports with clauses and can save your table relationships for re-use.
See More
Hide
Paid
3
0
Database .NET
All
4
Experiences
Pros
3
Cons
1
Top
Con
Website
The website looks chaotic and gives a bad first impression of an otherwise good product.
See More
Top
Pro
Portable
See More
Top
Pro
Multiple databases
Supported databases: SQL Server SQL Azure LocalDB MySQL Oracle IBM DB2 Informix PostgreSQL HP Vertica NuoDB Teradata Sybase ASE Firebird SQLite SQLCe Access Excel VistaDB dBase FoxPro OleDB ODBC OData Text NoSQL
See More
Top
Pro
Diagrams
Can generate diagrams.
See More
Hide
Free / paid
9
1
Adminer
All
6
Experiences
Pros
5
Cons
1
Top
Pro
Lightweight
The installation and Adminer itself only requires a single PHP file. Once it's uploaded you can log in and start using it.
See More
Top
Con
Bulk edition problems
See More
Top
Pro
Supports more than MySQL
It supports several database management systems (Postgres, SQLite, Oracle, MS SQL and of course MySQL).
See More
Top
Pro
Database views
Anyone who uses the views function will appreciate Adminer better. You can click on a view and edit to change the view. In phpMyAdmin, you can edit a view, but it's not easy or intuitive. SQL Buddy doesn't have any way of doing this.
See More
Top
Pro
Themes
Has a great variety of themes which transfers pretty ugly application into a great looking one.
See More
Top
Pro
Installation
No need to install, it's available to use out of the box.
See More
Hide
Get it
here
17
2
OmniDB
All
7
Experiences
Pros
6
Specs
Top
Pro
Open source and actively developed
See More
Top
Pro
PL/pgSQL Debugger
See More
Top
Pro
Web-based, can be run locally or deployed on server
OmniDB is web-based and works similarly to pgAdmin 4. You can run the web server locally or deploy it on a server, and connect to it through a web browser.
See More
Top
Pro
Multi-database
Supports PostgreSQL, Oracle, MySQL and MariaDB, with support in the pipeline for Firebird, SQLite, SQL Server and DB2.
See More
Top
Pro
Simple and intuitive interface for everyone.
An easy-to-discover tree panel to classify features/objects on left (with context menus if you don't know what you're doing). Tabs panels for ins and outs on right. That's it.
See More
Top
Pro
OmniDB has 2ndQuadrant as its main sponsor
See More
Specs
Technology:
Python, Django
Database management:
PostgreSQL, Oracle, MySQL, MariaDB
Hide
See All
Experiences
Free
75
12
Model Xtractor
All
6
Experiences
Pros
4
Cons
1
Specs
Top
Pro
Complete diagrams
Generates complete diagrams of a database with one click.
See More
Top
Con
Driver download
Some database drivers need to be installed manually, e.g. for PostgreSQL the Npgsql MSI installer.
See More
Top
Pro
Lightweight
Only a 5 Mb download.
See More
Top
Pro
Multiple databases
Supports multiple databases: Oracle, SQL Server, PostgreSQL, MySQL, Azure, Amazon Redshift, SQLite and Firebird.
See More
Top
Pro
Easy
Very user friendly.
See More
Specs
Platforms:
Windows
Hide
Free
1
0
Postico
All
5
Experiences
Pros
2
Cons
2
Specs
Top
Pro
Native experience and clean user interface
Postico is a native OS X app which is available through Mac App Store. The UI is fast, responsive and integrates seamlessly with the OS.
See More
Top
Con
No multiple query tabs in the free trial version
To be fair, multiple windows / tabs IS a feature. It's just part of the paid version.
See More
Top
Pro
Created by an experienced developer in the field
Postico is the successor of PG Commander, an older Mac Posgres GUI tool which is also widely used. They are both maintained by the same person.
See More
Top
Con
Commercial
Postico is a commercial app, with a one-time fee of $35. There is a free trial available.
See More
Specs
Platforms:
Mac
Hide
$39.99
54
12
Built By the Slant team
Find the best product instantly.
4.7 star rating
Add to Chrome
Add to Edge
Add to Firefox
Add to Opera
Add to Brave
Add to Safari
Try it now - it's free
{}
undefined
url next
price drop