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
+ Product Creator Latest stable release date Latest stable release versionLicense Other Programming languageSQL Commander Elphsoft Ltd. 2026-07-03 3.0.0.20 MongoDB, IBM DB2, IBM Informix, MariaDB, InterBase, Firebird, MariaDB, SAP Advantage Database, SAP SQL Anywhere, MS Access, Teradata, DBF, ExcelDelphiSQLPro Studio Hankinsoft Development, Inc. 2026-03-01 2025.1 MariaDB, Amazon RedshiftSwift Objective-CDatabaseSpyAltova IBM Db2, Sybase, MS AccessC++Database Workbench Upscene Productions 2026-03-19 6.10.4 InterBase, Firebird, NexusDB, MariaDBDelphiDataGrip JetBrains 2026-02-05 2025.3.5 Sybase, IBM Db2, H2, Hypersonic SQL, Amazon Redshift, Apache Derby, Redis, MongoDB, Snowflake, Exasol, BigQuery, Cassandra, ClickHouse, CockroachDB, CouchbaseJavaDBeaver Serge Rider EXASOL, IBM Db2, Apache Derby, Firebird, Mimer SQL, all with JDBC driver JavaDbVisualizer DbVis Software 2026-03-06 26.1 MongoDB, 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 driverJavaDBEdit Jef Van Den Ouweland 2012-05-10 2.4.6 IBM Db2, HSQLDB, Apache Derby, H2JavadbForge EdgeDevart 2025-04-18 5.1 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.NETHeidiSQL Ansgar Becker DelphiMicrosoft SQL Server Management StudioMicrosoft 2026-03-18 22.4.1 including SSAS management, and MDX, DMX, XMLA languages.NETMySQL WorkbenchOracle Corporation C++–C# Objective-C PythonNavicat PremiumSoft CyberTech Ltd. 2025-07-21 17.3 Delphi Objective-CNavicat Data Modeler PremiumSoft CyberTech Ltd. 2024-05-13 4 Delphi Objective-COracle Enterprise ManagerOracle Corp. 2025-05-21 13.5 IBM Db2, Sybase, TimesTenJavaOracle SQL DeveloperOracle Corp. 2024-12-16 24.3.1.347.1826 Microsoft Access, Sybase, IBM Db2, TeradataJavapgAdmin pgAdmin Development Team; C++phpLiteAdmin Dane Iracleous, Christopher Kramer, others 2019-09-05 1.9.8.2 PHPphpMyAdmin phpMyAdmin Development Team Drizzle, MariaDBphpPopSQL PopSQL, Inc. (TigerData) Amazon Redshift, Snowflake, BigQuery, ClickHouse, Amazon Athena, Azure Synapse, Presto, TrinoTypeScriptSaturnSQL Panda Capital Oy Ab MariaDB, Amazon Redshift, ClickHouse, BigQuery, Amazon DynamoDBTypeScriptSQL Database Studio Jan Prochazka 2017-05-10 3.6.2 .NET, WPF, C#SQLyog Webyog Softworks Pvt. Ltd. C++SQuirreL SQL Colin Bell, Gerd Wagner, Rob Manning, others 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.JavaToadQuest Software IBM Db2, SybaseDelphi, C#.NETToad Data ModelerQuest Software 2025-03-05 8.0 IBM Db2, MS Access, SybaseDelphiTOra Community 2017-07-04 3.2 TeradataC++–QtTablePlus TablePlus Inc. 2026-08-26 26.9.8 MariaDB, Amazon Redshift, CockroachDB, Redis, Cassandra Product Creator Latest stable release date Latest stable release versionLicense Other Programming 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
Tools User Interface Create & Alter wizard Browse Auto Completion Syntax colored Multi server support Monitoring server Database Table Procedure Trigger Database Table Procedure Trigger Adminer Browser-based Altova DatabaseSpy desktop Database Workbench desktop DataGrip desktop DBeaver desktop DbVisualizer desktop DBEdit desktop dbForge desktop Microsoft SQL Server Management Studio desktop MySQL Workbench desktop Navicat desktop Navicat Data Modeler desktop Oracle Enterprise Manager Browser-based Oracle SQL Developer desktop pgAdmin Browser-based, desktop (TDI) phpLiteAdmin Browser-based phpMyAdmin Browser-based SaturnSQL Browser-based SQL Database Studio desktop
SQLyog desktop SQuirreL SQL desktop Toad desktop Toad Data Modeler desktop TOra desktop
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 manager Plugin Compare Import Export Debugger Source control Spatial Visualization Adminer SQL 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) GitAltova DatabaseSpy CSV, XML XML, XML Structure, CSV, HTML, MS Excel Database Workbench custom system via TeamServer in Enterprise EditionDataGrip TXT, CSV, HTML, XML, DBF, SQL script, RTF, MS Word, MS Excel, MS Access, MS Windows Clipboard, Paradox file, WK1, WQ1, SLK, DIF, LDIF DBeaver With Eclipse pluginsDbVisualizer GitDBEdit MS Excel, PDF, Text, SQL script dbForge - TXT, CSV, XML, XLS, XLSX, DBF, JSON, Google Sheets, MS Access, or from any ODBC source - TXT, CSV, XML, XLS, XLSX, DBF, JSON, Google Sheets, MS Access, PDF, HTML, RTF, SQL script, or from any ODBC source Navicat - TXT, CSV, DBF, HTML, MS Excel, MS Access, Paradox file, WK1, WQ1, XML, or from any ODBC source (See link for limitationstitle= Navicat feature matrix) - 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) Navicat Data Modeler - Import Database from server/ODBC - Export SQL MySQL Workbench - CSV, HTML, JSON, MS Excel, SQL INSERTS, Tab-separated, XML - CSV, HTML, JSON, MS Excel, SQL INSERTS, Tab-separated, XML Oracle SQL Developer pgAdmin CSV, Text, or binary CSV, text, HTML, XML phpMyAdmin - CSV, SQL, XML, Excel, ODS - CSV, LaTeX, Excel, Word, ODS, ODT, XML, SQL, YAML, Texy!, JSON, NHibernate, PHP, PDF, MediaWiki Git SQL Database Studio
CSV, XML, MS Excel CSV, HTML, MS Excel, SQL INSERTS, Tab-separated, XML
SQLyog SQL Server Management Studio SQuirreL SQL Toad SVN, CVS, TFS, VSS Toad Data Modeler Toad for Oracle ERD, ERWin 7.1(XML) via plugin SQL; meta data in XML; report in HTML/RTF/CSV; diagram as BMP, JPEG, PNG TOra
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 builder Visual schema/model/E-R diagram design Reverse engineering Forward engineering ER diagram groupboxesAdminer Altova DatabaseSpy Database Workbench DBeaver DbVisualizer DBEdit dbForge Navicat Navicat Data Modeler MySQL Workbench Oracle SQL Developer pgAdmin phpMyAdmin SQL Database Studio SQL Server Management Studio SQLyog SQuirreL SQL Toad Toad Data Modeler
See also Comparison of data modeling tools Comparison of object database management systems Comparison of object–relational database management systems Comparison of relational database management systems List of relational database management systems List of SQL software and tools SQL programming tool
Notes
References