Comparison of database administration tools

Last updated

The following tables compare general and technical information for a number of available database administration tools. Please see individual product articles for further information. This article is neither all-inclusive nor necessarily up to date.

Contents

Systems listed on a light purple background are no longer in active development.

General

ProductCreatorLatest stable release dateLatest stable release version License
Runs on
Windows
Runs on
macOS
Runs on
Linux
Other Programming language
SQL CommanderElphsoft Ltd.2025-08-171.0.0.5 Proprietary YesComing soonComing soonYesYesYesYesYesYes MongoDB, IBM DB2, IBM Informix, MariaDB, InterBase, Firebird, MariaDB, SAP Advantage Database, SAP SQL Anywhere, MS Access, Teradata, DBF, Excel Delphi
DatabaseSpy Altova 2019-04-02 [±] 2019r3 [1] Proprietary YesNoNoYesYesYesYesYesYes IBM Db2, Sybase, MS Access C++
Database Workbench Upscene Productions2024-12-166.6.0 Proprietary Yesneeds Wine needs Wine YesYesYesYesYesYes InterBase, Firebird, NexusDB, MariaDB Delphi
DataGrip JetBrains2023-08-172023.2.1 Proprietary YesYesYesYesYesYesYesNoYesYes Sybase, IBM Db2, H2, Hypersonic SQL, Amazon Redshift, Apache Derby, Redis, MongoDB, Snowflake, Exasol, BigQuery, Cassandra, ClickHouse, CockroachDB, Couchbase Java
Galaxy Galaxy2025-06-01v0.0.105 Proprietary Coming soonYesComing soonComing soonYesYesComing soonComing soonYesComing soon Clickhouse Typescript
DBeaver Serge Rider2025-04-0625.0.2 [2] Apache License YesYesYesYesYesYesYesYesYesYes EXASOL, IBM Db2, Apache Derby, Firebird, Mimer SQL, all with JDBC driver Java
DBEdit Jef Van Den Ouweland2012-05-102.4.6 GPL YesYesYesYesYesYesYesNoYesYes IBM Db2, HSQLDB, Apache Derby, H2 Java
dbForge EdgeDevart2025-04-185.1 Proprietary Yesneeds CrossOver needs Wine or CrossOver YesYesYesYesYes [note 1] NoNo MariaDB, Galera Cluster, Percona, HeatWave MySQL, Google Cloud, Oracle Cloud, Amazon RDS, Amazon Aurora, Amazon Redshift, Alibaba Cloud, SQL Azure, Tencent Cloud, Heroku, Aiven Cloud, SkySQL, DigitalOcean Managed Database, Kamatera Performance Cloud .NET
HeidiSQL Ansgar Becker2022-08-13 [±] 12.1 [3] GPL Yesneeds Wine needs Wine YesYesYesYes Delphi
Microsoft SQL Server Management Studio Microsoft 2025-08-12 [4] 21.4.12 Proprietary YesNoNoYesincluding SSAS management, and MDX, DMX, XMLA languages .NET
MySQL Workbench Oracle Corporation 2020-09-12 [±] 8.0.22 [5] Community Ed: GPL

Standard Ed: Commercial Proprietary

YesYesYesYes C++C# Objective-C Python
Navicat PremiumSoft CyberTech Ltd.2021-11-2316 [6] Proprietary YesYesneeds Wine YesYesYesYesYesYes Delphi Objective-C
Navicat Data Modeler PremiumSoft CyberTech Ltd.2015-12-102.1 Proprietary YesYesYesYesYesYesYesYesYes Delphi Objective-C
Oracle Enterprise Manager Oracle Corp. 2015-06-1612.1.0.5 Proprietary YesNoYesYesYesYes IBM Db2, Sybase, TimesTen Java
Oracle SQL Developer Oracle Corp. 2018-04-0518.1.0.095.1630 Proprietary YesYesYesYesYesNoYesYesYes Microsoft Access, Sybase, IBM Db2, Teradata Java
pgAdmin pgAdmin Development Team2025-07-25; 27 days ago9.6 [7]   OOjs UI icon edit-ltr-progressive.svg PostgreSQL License YesYesYesYes C++
phpLiteAdmin Dane Iracleous, Christopher Kramer, others2019-09-051.9.8.2 [8] GPL YesYesYesNoNoNoNoNoNoYes PHP
phpMyAdmin phpMyAdmin Development Team

2025-01-21; 7 months ago [±]

5.2.2 [9]   OOjs UI icon edit-ltr-progressive.svg

GPL YesYesYesYes Drizzle, MariaDB php
SQL Database Studio Jan Prochazka2016-05-273.4.1 Proprietary YesNoNoNoNoNoYes .NET, WPF, C#
SQLyog Webyog Softworks Pvt. Ltd.2024-07-23 [±] 13.3.0 [10] GPLv2 Yesneeds Wine needs Wine Yes C++
SQuirreL SQL Colin Bell, Gerd Wagner, Rob Manning, others2023-06-04 [±] 4.6.0 [11] GPLv2 & LGPLv2YesYesYesYesYesYesYesYesYesYes Access, Axion Java RDBMS, Apache Derby, Daffodil DB, FileMaker (JDBC), Fujitsu Siemens SESAM/SQL, Firebird, FrontBase, HSQLDB, Hypersonic SQL, H2 (DBMS), IBM Db2, Informix, Ingres, OpenIngres, InstantDB, InterBase, Mckoi SQL Database, Mimer SQL, Netezza, Pointbase, SAPDB, Sybase, Sunopsis XML Driver, Teradata Warehouse, ThinkSQL RDBMS, Vertica Analytic Database. Java
Toad Quest Software VariousVarious Proprietary YesNoNoYesYesYesYes IBM Db2, Sybase Delphi, C#.NET
Toad Data Modeler Quest Software 2020-10-197.3 [12] Proprietary YesNoNoYesYesYesYes IBM Db2, MS Access, Sybase Delphi
TOra Community2017-07-043.2 GPL YesYesYesYesYesYes Teradata C++Qt
ProductCreatorLatest stable release dateLatest stable release version License
Runs on
Windows
Runs on
macOS
Runs on
Linux
OtherProgramming language

Features

Legend

Tools User Interface Create & Alter wizard Browse Auto CompletionSyntax coloredMulti server supportMonitoring server
Database Table Procedure Trigger Database Table Procedure Trigger
Adminer Browser-basedYesYesYesYesYesYesYesYesNoYes??
Altova DatabaseSpy desktopYesYesYesYesYesYesYesYesYesYesYes?
Database Workbench desktopYesYesYesYesYesYesYesYesYesYesYes?
DataGrip desktopYesYesYesYesYesYesYesYesYesYesYesNo
Galaxy desktopYesYesComing soonComing soonYesYesComing soonComing soonYesYesYesNo
DBeaver desktopYesYesYesYesYesYesYesYesYesYesYesYes
DBEdit desktopNoNoNoNoYesYesYesNoNoYesNo?
dbForge desktopYesYesYesYesYesYesYesYesYesYesYesSome
Microsoft SQL Server Management Studio desktopYesYesYesYesYesYesYesYesYesYesYesNo
MySQL Workbench desktopYesYesYesYesYesYesYesYesYesYesYesSome
Navicat desktopYesYesYesYesYesYesYesYesYesYesYes?
Navicat Data Modeler desktopNoYesNoYesNoNoNoNoYesYesYes?
Oracle Enterprise Manager Browser-basedYesYesYesYesYesYesYesYesYesYes?Yes
Oracle SQL Developer desktopYesYesYesYesYesYesYesYesYesYesYesNo
pgAdmin Browser-based, desktop (TDI)YesYesYesYesYesYesYesYesYesYesYesSome
phpLiteAdmin Browser-basedYesYesNoYesYesYesNoYesYesYes??
phpMyAdmin Browser-basedYesYesYesYesYesYesYesYesYesYesYesYes
SQL Database Studio desktop Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes No
SQLyog desktopYesYesYesYesYesYesYesYesYesYes??
SQuirreL SQL desktop????YesYes??YesYesSome?
Toad desktopYesYesYesYesYesYesYesYesYesYesYesYes
Toad Data Modeler desktopYesYesYesYesSomeSomeSomeSomeNoYes??
TOra desktopNoYesYesNoYesYesYesYesYesYesYes?

Features (continued)

Legend:

user manager Plugin CompareImportExport Debugger Source control Spatial Visualization
Adminer YesYesYesSQL script, CSV, TSV or the above in zip (as a plugin); imports of server-site file in SQL or SQL in zip, gzip or bzip2 SQL script, CSV, TSV or the above in zip, gzip, bzip2; XML (as a plugin)No Git
Altova DatabaseSpy NoNoYesCSV, XMLXML, XML Structure, CSV, HTML, MS ExcelNo?
Database Workbench YesNoYesYesYesYesYes [13]
DataGrip NoYesYesYes TXT, CSV, HTML, XML, DBF, SQL script, RTF, MS Word, MS Excel, MS Access, MS Windows Clipboard, Paradox file, WK1, WQ1, SLK, DIF, LDIF NoYes
Galaxy Coming soonYesYesYes TXT, CSV, MS Excel Coming soonComing soon
DBeaver YesYesYesYesYesNoWith Eclipse plugins
DBEdit NoNoNoNo MS Excel, PDF, Text, SQL scriptNo?
dbForge YesNoYesYes - TXT, CSV, XML, XLS, XLSX, DBF, JSON, Google Sheets, MS Access, or from any ODBC sourceYes - TXT, CSV, XML, XLS, XLSX, DBF, JSON, Google Sheets, MS Access, PDF, HTML, RTF, SQL script, or from any ODBC sourceYesYes [note 2] No
Navicat YesNoYesYes - TXT, CSV, DBF, HTML, MS Excel, MS Access, Paradox file, WK1, WQ1, XML, or from any ODBC source (See link for limitations [14] )Yes - TXT, CSV, HTML, XML, DBF, SQL script, RTF, MS Word, MS Excel, MS Access, MS Windows Clipboard, Paradox file, WK1, WQ1, SLK, DIF, LDIF (See link for limitations [14] )YesNo
Navicat Data Modeler NoNoYesYes - Import Database from server/ODBCYes - Export SQLNoNo
MySQL Workbench YesYesYesYes - CSV, HTML, JSON, MS Excel, SQL INSERTS, Tab-separated, XML Yes - CSV, HTML, JSON, MS Excel, SQL INSERTS, Tab-separated, XML YesNo
Oracle SQL Developer YesYesYesYesYesYesYesYes
pgAdmin YesYesNo CSV, Text, or binary CSV, text, HTML, XML YesNo
phpMyAdmin YesSomeYesYes - CSV, SQL, XML, Excel, ODS Yes - CSV, LaTeX, Excel, Word, ODS, ODT, XML, SQL, YAML, Texy!, JSON, NHibernate, PHP, PDF, MediaWiki Yes Git
SQL Database Studio Yes Yes No CSV, XML, MS Excel CSV, HTML, MS Excel, SQL INSERTS, Tab-separated, XML No No
SQLyog Yes?YesYesYes??
SQL Server Management Studio YesYes?YesYesYesYes [15] Yes
SQuirreL SQL ?YesYesYes?No?
Toad SomeNoYesYesYesYes SVN, CVS, TFS, VSS
Toad Data Modeler No?YesToad for Oracle ERD, ERWin 7.1(XML) via pluginSQL; meta data in XML; report in HTML/RTF/CSV; diagram as BMP, JPEG, PNGNo?
TOra SomeNoYesYesYesYesNo

Features - visual design and reverse engineering

Legend:

Visual query builderVisual schema/model/E-R diagram design Reverse engineering Forward engineeringER diagram groupboxes
Adminer YesYesYesNoNo
Altova DatabaseSpy YesYesYesYes?
Database Workbench YesYesYes?Yes
DBeaver NoYesYesNo?
DBEdit NoNoNoNoNo
dbForge YesYesYesYesNo
Navicat YesYesYesYesYes
Navicat Data Modeler YesYesYesYesYes
MySQL Workbench YesYesYesYesYes
Oracle SQL Developer YesYesYesYes?
pgAdmin YesNoNoNoNo
phpMyAdmin YesYesYesNoNo
SQL Database Studio YesYesYesYesNo
SQL Server Management Studio ?YesYes??
SQLyog Yes [16] Yes [17] YesYes?
SQuirreL SQL YesYesYes [note 3] ?No
Toad YesYesYesYes?
Toad Data Modeler NoYesYesYes [note 4] ?

See also

Notes

  1. Only for Data Import/Export features.
  2. Only for SQL Server and MySQL/MariaDB.
  3. Only incremental, by manually going through each table and clicking "Add to graph".
  4. Generated SQL must be executed outside Toad Data Modeler.

References

  1. "What's New in DatabaseSpy". altova.com. Retrieved 2019-07-24.
  2. "Release 25.0.2". GitHub. 2025-04-06. Retrieved 2025-04-14.
  3. "Releases - HeidiSQL/HeidiSQL". github.com. Retrieved 2022-08-26.
  4. "Release Notes for SQL Server Management Studio (SSMS)". 2025-08-12.
  5. "Releases - mysql/mysql-workbench". github.com. Retrieved 2020-11-19.
  6. "Welcome to Navicat's Press Center - Navicat". www.navicat.com. Retrieved 2022-04-17.
  7. "Release 9.6". 25 July 2025. Retrieved 16 August 2025.
  8. "Phpliteadmin / Public / Downloads — Bitbucket".
  9. "phpMyAdmin 5.2.2". 21 January 2025. Retrieved 21 January 2025.
  10. Team, Webyog (2024-07-23). "New Release – SQLyog 13.3.0". Webyog. Retrieved 2024-11-29.
  11. "SQuirrel SQL Client - Browse/1-stable". sourceforge.net. Retrieved 2023-11-25.
  12. "Toad Data Modeler 7.3 - Release Notes". support.quest.com. Retrieved 2022-04-17.
  13. custom system via TeamServer in Enterprise Edition
  14. 1 2 title= Navicat feature matrix
  15. "Source Control in SQL Server Management Studio (SSMS)". 21 November 2016.
  16. "SQLYog query builder". Archived from the original on 2010-10-26. Retrieved 2008-05-29.
  17. "SQLYog schema designer". Archived from the original on 2010-10-26. Retrieved 2008-05-29.