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 release versionLicenseRuns on WindowsRuns on macOSRuns on LinuxOracleMySQLPostgreSQLMS SQL ServerODBCJDBCSQLiteOtherProgramming language
SQL CommanderElphsoft Ltd.2026-07-033.0.0.20ProprietaryYesYesYesYesYesYesYesYesYesMongoDB, IBM DB2, IBM Informix, MariaDB, InterBase, Firebird, MariaDB, SAP Advantage Database, SAP SQL Anywhere, MS Access, Teradata, DBF, ExcelDelphi
SQLPro StudioHankinsoft Development, Inc.2026-03-012025.1ProprietaryYesYesNoYesYesYesYesNoNoYesMariaDB, Amazon RedshiftSwift Objective-C
DatabaseSpyAltova2025-10-21[±]2026ProprietaryYesNoNoYesYesYesYesYesYesIBM Db2, Sybase, MS AccessC++
Database WorkbenchUpscene Productions2026-03-196.10.4ProprietaryYesneeds Wineneeds WineYesYesYesYesYesYesInterBase, Firebird, NexusDB, MariaDBDelphi
DataGripJetBrains2026-02-052025.3.5ProprietaryYesYesYesYesYesYesYesNoYesYesSybase, IBM Db2, H2, Hypersonic SQL, Amazon Redshift, Apache Derby, Redis, MongoDB, Snowflake, Exasol, BigQuery, Cassandra, ClickHouse, CockroachDB, CouchbaseJava
DBeaverSerge Rider2026-08-1626.1.5Apache LicenseYesYesYesYesYesYesYesYesYesYesEXASOL, IBM Db2, Apache Derby, Firebird, Mimer SQL, all with JDBC driverJava
DbVisualizerDbVis Software2026-03-0626.1ProprietaryYesYesYesYesYesYesYesNoYesYesMongoDB, Redis, Snowflake, Elasticsearch, IBM Db2, SQLite, Microsoft Access, Databricks, Apache Cassandra, MariaDB, DynamoDB, Azure SQL Database, Google BigQuery, Apache Hive, Teradata, Apache Solr, SAP ASE, ClickHouse, Amazon Redshift, Presto, H2, DuckDB, Trino, SingleStore, 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 CrossOverYesYesYesYesYesNoNoMariaDB, 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 Becker2026-04-12[±]12.17GPLYesYesYesYesYesYesYesDelphi
Microsoft SQL Server Management StudioMicrosoft2026-03-1822.4.1ProprietaryYesNoNoYesincluding SSAS management, and MDX, DMX, XMLA languages.NET
MySQL WorkbenchOracle Corporation2026-04-02[±]8.0.47Community Ed: GPL Standard Ed: Commercial ProprietaryYesYesYesYesC++–C# Objective-C Python
NavicatPremiumSoft CyberTech Ltd.2025-07-2117.3ProprietaryYesYesYesYesYesYesYesYesYesDelphi Objective-C
Navicat Data ModelerPremiumSoft CyberTech Ltd.2024-05-134ProprietaryYesYesYesYesYesYesYesYesYesDelphi Objective-C
Oracle Enterprise ManagerOracle Corp.2025-05-2113.5ProprietaryYesNoYesYesYesYesIBM Db2, Sybase, TimesTenJava
Oracle SQL DeveloperOracle Corp.2024-12-1624.3.1.347.1826ProprietaryYesYesYesYesYesNoYesYesYesMicrosoft Access, Sybase, IBM Db2, TeradataJava
pgAdminpgAdmin Development Team2026-07-31; 30 days ago9.17PostgreSQL LicenseYesYesYesYesC++
phpLiteAdminDane Iracleous, Christopher Kramer, others2019-09-051.9.8.2GPLYesYesYesNoNoNoNoNoNoYesPHP
phpMyAdminphpMyAdmin Development Team2025-10-08; 10 months ago[±]5.2.3GPLYesYesYesYesDrizzle, MariaDBphp
PopSQLPopSQL, Inc. (TigerData)Web-based, rolling releases—N/aProprietaryYesYesYesNoYesYesYesNoNoNoAmazon Redshift, Snowflake, BigQuery, ClickHouse, Amazon Athena, Azure Synapse, Presto, TrinoTypeScript
SaturnSQLPanda Capital Oy AbWeb-based, rolling releases—N/aProprietaryYesYesYesYesYesYesYesNoNoNoMariaDB, Amazon Redshift, ClickHouse, BigQuery, Amazon DynamoDBTypeScript
SQL Database StudioJan Prochazka2017-05-103.6.2ProprietaryYesNoNoNoNoNoYes.NET, WPF, C#
SQLyogWebyog Softworks Pvt. Ltd.2025-09-26[±]13.3.1GPLv2Yesneeds Wineneeds WineYesC++
SQuirreL SQLColin Bell, Gerd Wagner, Rob Manning, others2026-03-26[±]5.1.0GPLv2 & 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 Software2025-03-058.0ProprietaryYesNoNoYesYesYesYesIBM Db2, MS Access, SybaseDelphi
TOraCommunity2017-07-043.2GPLYesYesYesYesYesYesTeradataC++–Qt
TablePlusTablePlus Inc.2026-08-2626.9.8ProprietaryYesYesYesYesYesYesYesNoNoYesMariaDB, Amazon Redshift, CockroachDB, Redis, Cassandra
ProductCreatorLatest stable release dateLatest stable release versionLicenseRuns on WindowsRuns on macOSRuns on LinuxOracleMySQLPostgreSQLMS SQL ServerODBCJDBCSQLiteOtherProgramming language

Features

Legend

  • User Interface: Browser based - executes on a computer server and is accessed via a network using a web browser desktop - executes on a personal computer
  • 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
DBeaverdesktopYesYesYesYesYesYesYesYesYesYesYesYes
DbVisualizerdesktopYesYesYesYesYesYesYesYesYesYesYesYes
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 WorkbenchYesNoYesYesYesYesYes
DataGripNoYesYesYesTXT, CSV, HTML, XML, DBF, SQL script, RTF, MS Word, MS Excel, MS Access, MS Windows Clipboard, Paradox file, WK1, WQ1, SLK, DIF, LDIFNoYes
DBeaverYesYesYesYesYesNoWith Eclipse plugins
DbVisualizerNoNoYesYesYesNoGit
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 sourceYesYesNo
NavicatYesNoYesYes - TXT, CSV, DBF, HTML, MS Excel, MS Access, Paradox file, WK1, WQ1, XML, or from any ODBC source (See link for limitations)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)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?YesYesYesYesYes
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?
DbVisualizerYesYes???
DBEditNoNoNoNoNo
dbForgeYesYesYesYesNo
NavicatYesYesYesYesYes
Navicat Data ModelerYesYesYesYesYes
MySQL WorkbenchYesYesYesYesYes
Oracle SQL DeveloperYesYesYesYes?
pgAdminYesNoNoNoNo
phpMyAdminYesYesYesNoNo
SQL Database StudioYesYesYesYesNo
SQL Server Management Studio?YesYes??
SQLyogYesYesYesYes?
SQuirreL SQLYesYesYes?No
ToadYesYesYesYes?
Toad Data ModelerNoYesYesYes?

See also

Notes