Comparison of database administration tools explained

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.^[1]

General

Product	Creator	Latest stable release date	Latest stable release version	License											Other	Programming language
	SQL Commander	Elphsoft Ltd.	2026-01-25	2.0.0.11												MongoDB, IBM DB2, IBM Informix, MariaDB, InterBase, Firebird, MariaDB, SAP Advantage Database, SAP SQL Anywhere, MS Access, Teradata, DBF, Excel	Delphi
	DatabaseSpy	Altova														IBM Db2, Sybase, MS Access	C++
	Database Workbench	Upscene Productions	2026-02-11	6.10.0												InterBase, Firebird, NexusDB, MariaDB	Delphi
	DataGrip	JetBrains	2026-02-05	2025.3.5[2]												Sybase, IBM Db2, H2, Hypersonic SQL, Amazon Redshift, Apache Derby, Redis, MongoDB, Snowflake, Exasol, BigQuery, Cassandra, ClickHouse, CockroachDB, Couchbase	Java
	DBeaver	Serge Rider														EXASOL, IBM Db2, Apache Derby, Firebird, Mimer SQL, all with JDBC driver	Java
	DbVisualizer	DbVis Software	2026-01-21	25.3.2												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 driver	Java
	DBEdit	Jef Van Den Ouweland	2012-05-10	2.4.6												IBM Db2, HSQLDB, Apache Derby, H2	Java
	dbForge Edge	Devart	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	.NET
	HeidiSQL	Ansgar Becker															Delphi
	Microsoft SQL Server Management Studio	Microsoft	2026-02-24[3]	22.3.2												including SSAS management, and MDX, DMX, XMLA languages	.NET
	MySQL Workbench	Oracle Corporation															C++–C# Objective-C Python
	Navicat	PremiumSoft CyberTech Ltd.	2025-07-21	17.3[4]													Delphi Objective-C
	Navicat Data Modeler	PremiumSoft CyberTech Ltd.	2024-05-13	4													Delphi Objective-C
	Oracle Enterprise Manager	Oracle Corp.	2025-05-21	13.5												IBM Db2, Sybase, TimesTen	Java
	Oracle SQL Developer	Oracle Corp.	2024-12-16	24.3.1.347.1826												Microsoft Access, Sybase, IBM Db2, Teradata	Java
	pgAdmin	pgAdmin Development Team																C++
	phpLiteAdmin	Dane Iracleous, Christopher Kramer, others	2019-09-05	1.9.8.2[5]													PHP
	phpMyAdmin	phpMyAdmin Development Team														Drizzle, MariaDB	php
	SQL 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.	Java
	Toad	Quest Software														IBM Db2, Sybase	Delphi, C#.NET
	Toad Data Modeler	Quest Software	2025-03-05	8.0[6]												IBM Db2, MS Access, Sybase	Delphi
	TOra	Community	2017-07-04	3.2												Teradata	C++–Qt	+
Product	Creator	Latest stable release date	Latest stable release version	License											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
Galaxy	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
	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)		Git
Altova DatabaseSpy				CSV, XML	XML, XML Structure, CSV, HTML, MS Excel
Database Workbench							[7]
DataGrip					TXT, CSV, HTML, XML, DBF, SQL script, RTF, MS Word, MS Excel, MS Access, MS Windows Clipboard, Paradox file, WK1, WQ1, SLK, DIF, LDIF
Galaxy					TXT, CSV, MS Excel
DBeaver							With Eclipse plugins
DbVisualizer							Git
DBEdit					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 limitations[8])	- 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
SQLyog
SQL Server Management Studio							[9]
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

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 and References

1. News: K . Vijay . Top 10 Database Administration Tools in 2025: Features, Pros, Cons & Comparison . November 3, 2025 . DevOpsSchool.
2. Web site: 2026-02-05. Download DataGrip: Cross-Platform IDE for Databases & SQL .
3. Web site: 2026-02-24 . Release Notes for SQL Server Management Studio (SSMS) .
4. Web site: Welcome to Navicat's Press Center - Navicat . 2026-02-11 . www.navicat.com.
5. Web site: Phpliteadmin / Public / Downloads — Bitbucket.
6. Web site: Toad Data Modeler 8.0 - Release Notes . 2026-02-11 . support.quest.com.
7. custom system via TeamServer in Enterprise Edition
8. https://www.navicat.com/en/products/navicat-for-mysql-feature-matrix title= Navicat feature matrix
9. Web site: Source Control in SQL Server Management Studio (SSMS). 21 November 2016.
10. Web site: SQLYog query builder . 2008-05-29 . 2010-10-26 . https://web.archive.org/web/20101026070544/http://webyog.com/en/screenshots_sqlyog.php . dead .
11. Web site: SQLYog schema designer . 2008-05-29 . 2010-10-26 . https://web.archive.org/web/20101026070544/http://webyog.com/en/screenshots_sqlyog.php . dead .