Menu
Home Explore People Places Arts History Plants & Animals Science Life & Culture Technology
On this page
Comparison of database administration tools

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.

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

General

ProductCreatorLatest stable release dateLatest stable releaseLicenseRuns onWindowsRuns onmacOSRuns onLinuxOracleMySQLPostgreSQLMS SQL ServerODBCJDBCSQLiteOtherProgramming language
DatabaseSpyAltova2019-04-02[±]2019r31ProprietaryYesNoNoYesYesYesYesYesYesIBM Db2, Sybase, MS AccessC++
Database WorkbenchUpscene Productions2024-12-166.6.0ProprietaryYesneeds Wineneeds WineYesYesYesYesYesYesInterBase, Firebird, NexusDB, MariaDBDelphi
DataGripJetBrains2023-08-172023.2.1ProprietaryYesYesYesYesYesYesYesNoYesYesSybase, IBM Db2, H2, Hypersonic SQL, Amazon Redshift, Apache Derby, Redis, MongoDB, Snowflake, Exasol, BigQuery, Cassandra, ClickHouse, CockroachDB, CouchbaseJava
GalaxyGalaxy2025-06-01v0.0.105ProprietaryComing soonYesComing soonComing soonYesYesComing soonComing soonYesComing soonClickhouseTypescript
DBeaverSerge Rider2025-04-0625.0.22Apache LicenseYesYesYesYesYesYesYesYesYesYesEXASOL, IBM Db2, Apache Derby, Firebird, Mimer SQL, all with JDBC driverJava
DBEditJef Van Den Ouweland2012-05-102.4.6GPLYesYesYesYesYesYesYesNoYesYesIBM Db2, HSQLDB, Apache Derby, H2Java
dbForge EdgeDevart2025-04-185.1ProprietaryYesneeds CrossOverneeds Wine or CrossOverYesYesYesYesYes3NoNoMariaDB, 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
HeidiSQLAnsgar Becker2022-08-13[±]12.14GPLYesneeds Wineneeds WineYesYesYesYesDelphi
Microsoft SQL Server Management StudioMicrosoft2025-05-28521.1.3ProprietaryYesNoNoYesincluding SSAS management, and MDX, DMX, XMLA languages.NET
MySQL WorkbenchOracle Corporation2020-09-12[±]8.0.226Community Ed: GPL

Standard Ed: Commercial Proprietary

YesYesYesYesC++–C# Objective-C Python
NavicatPremiumSoft CyberTech Ltd.2021-11-23167ProprietaryYesYesneeds WineYesYesYesYesYesYesDelphi Objective-C
Navicat Data ModelerPremiumSoft CyberTech Ltd.2015-12-102.1ProprietaryYesYesYesYesYesYesYesYesYesDelphi Objective-C
Oracle Enterprise ManagerOracle Corp.2015-06-1612.1.0.5ProprietaryYesNoYesYesYesYesIBM Db2, Sybase, TimesTenJava
Oracle SQL DeveloperOracle Corp.2018-04-0518.1.0.095.1630ProprietaryYesYesYesYesYesNoYesYesYesMicrosoft Access, Sybase, IBM Db2, TeradataJava
pgAdminpgAdmin Development Team2025-04-30; 36 days ago9.38 PostgreSQL LicenseYesYesYesYesC++
phpLiteAdminDane Iracleous, Christopher Kramer, others2019-09-051.9.8.29GPLYesYesYesNoNoNoNoNoNoYesPHP
phpMyAdminphpMyAdmin Development Team

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

5.2.210 

GPLYesYesYesYesDrizzle, MariaDBphp
SQL Database StudioJan Prochazka2016-05-273.4.1ProprietaryYesNoNoNoNoNoYes.NET, WPF, C#
SQLyogWebyog Softworks Pvt. Ltd.2024-07-23[±]13.3.011GPLv2Yesneeds Wineneeds WineYesC++
SQuirreL SQLColin Bell, Gerd Wagner, Rob Manning, others2023-06-04 [±]4.6.012GPLv2 & LGPLv2YesYesYesYesYesYesYesYesYesYesAccess, 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
ToadQuest SoftwareVariousVariousProprietaryYesNoNoYesYesYesYesIBM Db2, SybaseDelphi, C#.NET
Toad Data ModelerQuest Software2020-10-197.313ProprietaryYesNoNoYesYesYesYesIBM Db2, MS Access, SybaseDelphi
TOraCommunity2017-07-043.2GPLYesYesYesYesYesYesTeradataC++–Qt
ProductCreatorLatest stable release dateLatest stable releaseLicenseRuns onWindowsRuns onmacOSRuns onLinuxOracleMySQLPostgreSQLMS SQL ServerODBCJDBCSQLiteOtherProgramming language

Features

Legend

  • User Interface:
  • Create/alter table:
    • Yes - can create table, alter its definition and data, and add new rows
    • Some - can only create/alter table definition, not data
  • Browse table:
    • Yes - can browse table definition and data
    • Some - can only browse table definition
  • Multi-server support:
    • Yes - can manage from the same window/session multiple servers
    • Some - can manage from a different window/session multiple servers
  • Monitoring server:
    • Yes - includes a headless server, that runs checks and reports failures
ToolsUser InterfaceCreate & Alter wizardBrowseAuto CompletionSyntax coloredMulti server supportMonitoring server
DatabaseTableProcedureTriggerDatabaseTableProcedureTrigger
AdminerBrowser-basedYesYesYesYesYesYesYesYesNoYes??
Altova DatabaseSpydesktopYesYesYesYesYesYesYesYesYesYesYes?
Database WorkbenchdesktopYesYesYesYesYesYesYesYesYesYesYes?
DataGripdesktopYesYesYesYesYesYesYesYesYesYesYesNo
GalaxydesktopYesYesComing soonComing soonYesYesComing soonComing soonYesYesYesNo
DBeaverdesktopYesYesYesYesYesYesYesYesYesYesYesYes
DBEditdesktopNoNoNoNoYesYesYesNoNoYesNo?
dbForgedesktopYesYesYesYesYesYesYesYesYesYesYesSome
Microsoft SQL Server Management StudiodesktopYesYesYesYesYesYesYesYesYesYesYesNo
MySQL WorkbenchdesktopYesYesYesYesYesYesYesYesYesYesYesSome
NavicatdesktopYesYesYesYesYesYesYesYesYesYesYes?
Navicat Data ModelerdesktopNoYesNoYesNoNoNoNoYesYesYes?
Oracle Enterprise ManagerBrowser-basedYesYesYesYesYesYesYesYesYesYes?Yes
Oracle SQL DeveloperdesktopYesYesYesYesYesYesYesYesYesYesYesNo
pgAdminBrowser-based, desktop (TDI)YesYesYesYesYesYesYesYesYesYesYesSome
phpLiteAdminBrowser-basedYesYesNoYesYesYesNoYesYesYes??
phpMyAdminBrowser-basedYesYesYesYesYesYesYesYesYesYesYesYes
SQL Database StudiodesktopYesYesYesYesYesYesYesYesYesYesYesNo
SQLyogdesktopYesYesYesYesYesYesYesYesYesYes??
SQuirreL SQLdesktop????YesYes??YesYesSome?
ToaddesktopYesYesYesYesYesYesYesYesYesYesYesYes
Toad Data ModelerdesktopYesYesYesYesSomeSomeSomeSomeNoYes??
TOradesktopNoYesYesNoYesYesYesYesYesYesYes?

Features (continued)

Legend:

  • User manager:
    • Yes - user manager with support for database and schema permissions as well as for individual object (table, view, functions) permissions
    • Some - simple user manager with support for database and schema permissions
    • No - no user manager, or read-only user manager
user managerPluginCompareImportExportDebuggerSource controlSpatial Visualization
AdminerYesYesYesSQL script, CSV, TSV or the above in zip (as a plugin); imports of server-site file in SQL or SQL in zip, gzip or bzip2SQL script, CSV, TSV or the above in zip, gzip, bzip2; XML (as a plugin)NoGit
Altova DatabaseSpyNoNoYesCSV, XMLXML, XML Structure, CSV, HTML, MS ExcelNo?
Database WorkbenchYesNoYesYesYesYesYes14
DataGripNoYesYesYesTXT, CSV, HTML, XML, DBF, SQL script, RTF, MS Word, MS Excel, MS Access, MS Windows Clipboard, Paradox file, WK1, WQ1, SLK, DIF, LDIFNoYes
GalaxyComing soonYesYesYesTXT, CSV, MS ExcelComing soonComing soon
DBeaverYesYesYesYesYesNoWith Eclipse plugins
DBEditNoNoNoNoMS Excel, PDF, Text, SQL scriptNo?
dbForgeYesNoYesYes - 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 sourceYesYes15No
NavicatYesNoYesYes - TXT, CSV, DBF, HTML, MS Excel, MS Access, Paradox file, WK1, WQ1, XML, or from any ODBC source (See link for limitations16)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 limitations17)YesNo
Navicat Data ModelerNoNoYesYes - Import Database from server/ODBCYes - Export SQLNoNo
MySQL WorkbenchYesYesYesYes - CSV, HTML, JSON, MS Excel, SQL INSERTS, Tab-separated, XMLYes - CSV, HTML, JSON, MS Excel, SQL INSERTS, Tab-separated, XMLYesNo
Oracle SQL DeveloperYesYesYesYesYesYesYesYes
pgAdminYesYesNoCSV, Text, or binaryCSV, text, HTML, XMLYesNo
phpMyAdminYesSomeYesYes - CSV, SQL, XML, Excel, ODSYes - CSV, LaTeX, Excel, Word, ODS, ODT, XML, SQL, YAML, Texy!, JSON, NHibernate, PHP, PDF, MediaWikiYesGit
SQL Database StudioYesYesNoCSV, XML, MS ExcelCSV, HTML, MS Excel, SQL INSERTS, Tab-separated, XMLNoNo
SQLyogYes?YesYesYes??
SQL Server Management StudioYesYes?YesYesYesYes18Yes
SQuirreL SQL?YesYesYes?No?
ToadSomeNoYesYesYesYesSVN, CVS, TFS, VSS
Toad Data ModelerNo?YesToad for Oracle ERD, ERWin 7.1(XML) via pluginSQL; meta data in XML; report in HTML/RTF/CSV; diagram as BMP, JPEG, PNGNo?
TOraSomeNoYesYesYesYesNo

Features - visual design and reverse engineering

Legend:

  • Visual schema/E-R design: the ability to draw entity-relationship diagrams for the database. If missing, the following two features will also be missing
  • Reverse engineering - the ability to produce an ER diagram from a database, complete with foreign key relationships
    • Yes - supports incremental reverse engineering, preserving user modifications to the diagram and importing only changes from the database
    • Some - can only reverse engineer the entire database at once and drops any user modifications to the diagram (can't "refresh" the diagram to match the database)
  • Forward engineering - the ability to update the database schema with changes made to its entities and relationships via the ER diagram visual designer
    • Yes - can update user-selected entities
    • Some - can only update the entire database at once
Visual query builderVisual schema/model/E-R diagram designReverse engineeringForward engineeringER diagram groupboxes
AdminerYesYesYesNoNo
Altova DatabaseSpyYesYesYesYes?
Database WorkbenchYesYesYes?Yes
DBeaverNoYesYesNo?
DBEditNoNoNoNoNo
dbForgeYesYesYesYesNo
NavicatYesYesYesYesYes
Navicat Data ModelerYesYesYesYesYes
MySQL WorkbenchYesYesYesYesYes
Oracle SQL DeveloperYesYesYesYes?
pgAdminYesNoNoNoNo
phpMyAdminYesYesYesNoNo
SQL Database StudioYesYesYesYesNo
SQL Server Management Studio?YesYes??
SQLyogYes19Yes20YesYes?
SQuirreL SQLYesYesYes21?No
ToadYesYesYesYes?
Toad Data ModelerNoYesYesYes22?

See also

Notes

References

  1. "What's New in DatabaseSpy". altova.com. Retrieved 2019-07-24. https://www.altova.com/databasespy/whatsnew ↩

  2. "Release 25.0.2". GitHub. 2025-04-06. Retrieved 2025-04-14. https://github.com/dbeaver/dbeaver/releases/tag/25.0.2 ↩

  3. Only for Data Import/Export features. ↩

  4. "Releases - HeidiSQL/HeidiSQL". github.com. Retrieved 2022-08-26. https://github.com/HeidiSQL/HeidiSQL/releases ↩

  5. "Release Notes for SQL Server Management Studio (SSMS)". 28 May 2025. https://learn.microsoft.com/ssms/release-notes-21 ↩

  6. "Releases - mysql/mysql-workbench". github.com. Retrieved 2020-11-19. https://github.com/mysql/mysql-workbench/releases ↩

  7. "Welcome to Navicat's Press Center - Navicat". www.navicat.com. Retrieved 2022-04-17. https://www.navicat.com/en/company/press ↩

  8. "Release 9.3". 30 April 2025. Retrieved 25 May 2025. https://github.com/pgadmin-org/pgadmin4/releases/tag/REL-9_3 ↩

  9. "Phpliteadmin / Public / Downloads — Bitbucket". https://bitbucket.org/phpliteadmin/public/downloads ↩

  10. "phpMyAdmin 5.2.2". 21 January 2025. Retrieved 21 January 2025. https://www.phpmyadmin.net/files/5.2.2/ ↩

  11. Team, Webyog (2024-07-23). "New Release – SQLyog 13.3.0". Webyog. Retrieved 2024-11-29. https://webyog.com/sqlyog-13-3-release-notes/ ↩

  12. "SQuirrel SQL Client - Browse/1-stable". sourceforge.net. Retrieved 2023-11-25. https://sourceforge.net/projects/squirrel-sql/files/1-stable/ ↩

  13. "Toad Data Modeler 7.3 - Release Notes". support.quest.com. Retrieved 2022-04-17. https://support.quest.com/technical-documents/toad-data-modeler/7.3/release-notes ↩

  14. custom system via TeamServer in Enterprise Edition ↩

  15. Only for SQL Server and MySQL/MariaDB. ↩

  16. title= Navicat feature matrix https://www.navicat.com/en/products/navicat-for-mysql-feature-matrix ↩

  17. title= Navicat feature matrix https://www.navicat.com/en/products/navicat-for-mysql-feature-matrix ↩

  18. "Source Control in SQL Server Management Studio (SSMS)". 21 November 2016. https://blogs.technet.microsoft.com/dataplatforminsider/2016/11/21/source-control-in-sql-server-management-studio-ssms/ ↩

  19. "SQLYog query builder". Archived from the original on 2010-10-26. Retrieved 2008-05-29. https://web.archive.org/web/20101026070544/http://webyog.com/en/screenshots_sqlyog.php ↩

  20. "SQLYog schema designer". Archived from the original on 2010-10-26. Retrieved 2008-05-29. https://web.archive.org/web/20101026070544/http://webyog.com/en/screenshots_sqlyog.php ↩

  21. Only incremental, by manually going through each table and clicking "Add to graph". ↩

  22. Generated SQL must be executed outside Toad Data Modeler. ↩