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.

General

Product	Creator	Latest stable release date	Latest stable release	License	Runs on Windows	Runs on macOS	Runs on Linux	Oracle	MySQL	PostgreSQL	MS SQL Server	ODBC	JDBC	SQLite	Other	Programming language
	DatabaseSpy	Altova														IBM Db2, Sybase, MS Access	C++
	Database Workbench	Upscene Productions	2024-05-14	6.5.0												InterBase, Firebird, NexusDB, MariaDB	Delphi
	DataGrip	JetBrains	2023-08-17	2023.2.1												Sybase, IBM Db2, H2, Hypersonic SQL, Amazon Redshift, Apache Derby, Redis, MongoDB, Snowflake, Exasol, BigQuery, Cassandra, ClickHouse, CockroachDB, Couchbase	Java
	DBeaver	Serge Rider	2023-11-20	23.2.5^[1]	Apache License											EXASOL, IBM Db2, Apache Derby, Firebird, Mimer SQL, all with JDBC driver	Java
	DBEdit	Jef Van Den Ouweland	2012-05-10	2.4.6												IBM Db2, HSQLDB, Apache Derby, H2	Java
	Epictetus	Antilogic Software														Sybase, InterBase–Firebird, H2, HSQLDB	Java
	HeidiSQL	Ansgar Becker															Delphi
	Maatkit	Baron Schwartz	2010-06-01	5247													Perl
	Microsoft SQL Server Management Studio	Microsoft	2024-04-09^[2]	20.1												including SSAS management, and MDX, DMX, XMLA languages	.NET
	ModelRight	ModelRight	2016-12-??	4.1^[3] ^[4]												IBM Db2, Db2/zOS, MS Access	C++
	MySQL Workbench	Oracle Corporation															C++–C# Objective-C Python
	Navicat	PremiumSoft CyberTech Ltd.	2021-11-23	16^[5]													Delphi Objective-C
	Navicat Data Modeler	PremiumSoft CyberTech Ltd.	2015-12-10	2.1													Delphi Objective-C
	Oracle Enterprise Manager	Oracle Corp.	2015-06-16	12.1.0.5												IBM Db2, Sybase, TimesTen	Java
	Oracle SQL Developer	Oracle Corp.	2018-04-05	18.1.0.095.1630												Microsoft Access, Sybase, IBM Db2, Teradata	Java
	Orbada	Andrzej Kaluza														Firebird, HSQL, InterBase, Derby all with JDBC driver	Java
	pgAdmin	pgAdmin Development Team	2020-03-05	4.19^[6]	PostgreSQL License													C++
	phpLiteAdmin	Dane Iracleous, Christopher Kramer, others	2019-09-05	1.9.8.2^[7]													PHP
	phpMyAdmin	phpMyAdmin Development Team														Drizzle, MariaDB	php
	SQL Database Studio	Jan Prochazka	2016-05-27	3.4.1													.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	Various	Various												IBM Db2, Sybase	Delphi, C#.NET
	Toad Data Modeler	Quest Software	2020-10-19	7.3^[8]												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	License	Runs on Windows	Runs on macOS	Runs on Linux	Oracle	MySQL	PostgreSQL	MS SQL Server	ODBC	JDBC	SQLite	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
DBEdit	desktop
Epictetus	desktop
Microsoft SQL Server Management Studio	desktop
ModelRight	desktop
MySQL Workbench	desktop
Navicat	desktop
Navicat Data Modeler	desktop
Oracle Enterprise Manager	Browser-based
Oracle SQL Developer	desktop
Orbada	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							^[9]
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
DBeaver							With Eclipse plugins
DBEdit					MS Excel, PDF, Text, SQL script
Epictetus					Excel
ModelRight				- from supported databases using native interfaces, or from any ODBC source	SQL XML; DTD; Diagram as BMP, JPEG
Navicat				- TXT, CSV, DBF, HTML, MS Excel, MS Access, Paradox file, WK1, WQ1, XML, or from any ODBC source (See link for limitations^[10])	- 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
Orbada				SQL script	SQL script, CSV, XML, HTML, PDF, Excel, DBF, DataText
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							^[11]
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
• SQL programming tool

Notes and References

1. Web site: Release 23.2.5 . 2023-11-20 . GitHub . 2023-11-29.
2. Web site: 9 April 2024 . Download SQL Server Management Studio (SSMS) .
3. Web site: An Overview of Database Diagram Tools Available for PostgreSQL . 2019-07-05 . Severalnines . en . 2019-07-24.
4. Web site: ModelRight Download full version trials . www.modelright.com . 2019-07-24.
5. Web site: Welcome to Navicat's Press Center - Navicat . 2022-04-17 . www.navicat.com.
6. Web site: pgAdmin - PostgreSQL Tools . www.pgadmin.org . 2020-03-18.
7. Web site: Phpliteadmin / Public / Downloads — Bitbucket.
8. Web site: Toad Data Modeler 7.3 - Release Notes . 2022-04-17 . support.quest.com.
9. custom system via TeamServer in Enterprise Edition
10. https://www.navicat.com/en/products/navicat-for-mysql-feature-matrix title= Navicat feature matrix
11. Web site: Source Control in SQL Server Management Studio (SSMS). 21 November 2016.
12. 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 .
13. 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 .