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
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
2019-04-02[±]
2019r3[1]
Proprietary
Yes
No
No
Yes
Yes
Yes
Yes
Yes
Yes
IBM Db2 , Sybase , MS Access
C++
Database Workbench
Upscene Productions
2022-09-20
6.1.0
Proprietary
Yes
needs Wine
needs Wine
Yes
Yes
Yes
Yes
Yes
InterBase , Firebird , SQL Anywhere , NexusDB , MariaDB
Delphi
DataGrip
JetBrains
2023-08-17
2023.2.1
Proprietary
Yes
Yes
Yes
Yes
Yes
Yes
Yes
No
Yes
Yes
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[2]
Apache License
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
EXASOL , IBM Db2 , Apache Derby , Firebird , Mimer SQL , all with JDBC driver
Java
DBEdit
Jef Van Den Ouweland
2012-05-10
2.4.6
GPL
Yes
Yes
Yes
Yes
Yes
Yes
Yes
No
Yes
Yes
IBM Db2 , HSQLDB , Apache Derby , H2
Java
Epictetus
Antilogic Software
?
?
Proprietary
Yes
Yes
Yes
Yes
Yes
Yes
Sybase , InterBase –Firebird , H2 , HSQLDB
Java
HeidiSQL
Ansgar Becker
2022-08-13[±]
12.1[3]
GPL
Yes
needs Wine
needs Wine
Yes
Yes
Yes
Yes
Delphi
Maatkit
Baron Schwartz
2010-06-01
5247
GPL
Yes
Yes
Yes
Yes
Perl
Microsoft SQL Server Management Studio
Microsoft
2024-04-09[4]
20.1
Proprietary
Yes
No
No
Yes
including SSAS management, and MDX, DMX, XMLA languages
.NET
ModelRight
ModelRight
2016-12-??
4.1[5] [6]
Proprietary
Yes
No
No
Yes
Yes
Yes
Yes
Yes
IBM Db2 , Db2/zOS, MS Access
C++
MySQL Workbench
Oracle Corporation
2020-09-12[±]
8.0.22[7]
Community Ed: GPL
Standard Ed: Commercial Proprietary
Yes
Yes
Yes
Yes
C++ –C# Objective-C Python
Navicat
PremiumSoft CyberTech Ltd.
2021-11-23
16[8]
Proprietary
Yes
Yes
needs Wine
Yes
Yes
Yes
Yes
Yes
Yes
Delphi Objective-C
Navicat Data Modeler
PremiumSoft CyberTech Ltd.
2015-12-10
2.1
Proprietary
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Delphi Objective-C
Oracle Enterprise Manager
Oracle Corp.
2015-06-16
12.1.0.5
Proprietary
Yes
No
Yes
Yes
Yes
Yes
IBM Db2 , Sybase , TimesTen
Java
Oracle SQL Developer
Oracle Corp.
2018-04-05
18.1.0.095.1630
Proprietary
Yes
Yes
Yes
Yes
Yes
No
Yes
Yes
Yes
Microsoft Access , Sybase , IBM Db2 , Teradata
Java
Orbada
Andrzej Kaluza
2016-12-06[±]
1.2.5.395[9]
GPL
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Firebird , HSQL , InterBase , Derby all with JDBC driver
Java
pgAdmin
pgAdmin Development Team
2020-03-05
4.19[10]
PostgreSQL License
Yes
Yes
Yes
Yes
C++
phpLiteAdmin
Dane Iracleous, Christopher Kramer, others
2019-09-05
1.9.8.2[11]
GPL
Yes
Yes
Yes
No
No
No
No
No
No
Yes
PHP
phpMyAdmin
phpMyAdmin Development Team
2023-02-08; 16 months ago[±]
5.2.1[12]
GPL
Yes
Yes
Yes
Yes
Drizzle , MariaDB
php
SQL Database Studio
Jan Prochazka
2016-05-27
3.4.1
Proprietary
Yes
No
No
No
No
No
Yes
.NET , WPF , C#
SQLyog
Webyog Softworks Pvt. Ltd.
2022-01-11[±]
13.1.9[13]
GPLv2
Yes
needs Wine
needs Wine
Yes
C++
SQuirreL SQL
Colin Bell, Gerd Wagner, Rob Manning, others
2023-06-04 [±]
4.6.0[14]
GPLv2 & LGPLv 2
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
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
Proprietary
Yes
No
No
Yes
Yes
Yes
Yes
IBM Db2 , Sybase
Delphi , C#.NET
Toad Data Modeler
Quest Software
2020-10-19
7.3[15]
Proprietary
Yes
No
No
Yes
Yes
Yes
Yes
IBM Db2 , MS Access , Sybase
Delphi
TOra
Community
2017-07-04
3.2
GPL
Yes
Yes
Yes
Yes
Yes
Yes
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:
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
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
No
Yes
?
?
Altova DatabaseSpy
desktop
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
?
Database Workbench
desktop
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
?
DataGrip
desktop
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
No
DBeaver
desktop
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
DBEdit
desktop
No
No
No
No
Yes
Yes
Yes
No
No
Yes
No
?
Epictetus
desktop
No
Yes
No
No
Yes
Yes
Yes
Yes
Yes
Yes
?
?
Microsoft SQL Server Management Studio
desktop
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
No
ModelRight
desktop
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
No
Yes
?
?
MySQL Workbench
desktop
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Some
Navicat
desktop
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
?
Navicat Data Modeler
desktop
No
Yes
No
Yes
No
No
No
No
Yes
Yes
Yes
?
Oracle Enterprise Manager
Browser-based
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
?
Yes
Oracle SQL Developer
desktop
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
No
Orbada
desktop
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
No
pgAdmin
Browser-based, desktop (TDI )
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Some
phpLiteAdmin
Browser-based
Yes
Yes
No
Yes
Yes
Yes
No
Yes
Yes
Yes
?
?
phpMyAdmin
Browser-based
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
SQL Database Studio
desktop
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
No
SQLyog
desktop
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
?
?
SQuirreL SQL
desktop
?
?
?
?
Yes
Yes
?
?
Yes
Yes
Some
?
Toad
desktop
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Toad Data Modeler
desktop
Yes
Yes
Yes
Yes
Some
Some
Some
Some
No
Yes
?
?
TOra
desktop
No
Yes
Yes
No
Yes
Yes
Yes
Yes
Yes
Yes
Yes
?
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
Yes
Yes
Yes
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)
No
Git
Altova DatabaseSpy
No
No
Yes
CSV, XML
XML, XML Structure, CSV, HTML, MS Excel
No
?
Database Workbench
Yes
No
Yes
Yes
Yes
Yes
Yes[16]
DataGrip
No
Yes
Yes
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
No
Yes
DBeaver
Yes
Yes
Yes
Yes
Yes
No
With Eclipse plugins
DBEdit
No
No
No
No
MS Excel , PDF , Text, SQL script
No
?
Epictetus
No
Yes
No
No
Excel
No
?
ModelRight
Some
Yes
Yes
Yes - from supported databases using native interfaces, or from any ODBC source
SQL ; XML ; DTD ; Diagram as BMP, JPEG
No
?
Navicat
Yes
No
Yes
Yes - TXT , CSV , DBF , HTML , MS Excel , MS Access , Paradox file , WK1 , WQ1 , XML , or from any ODBC source (See link for limitations[17] )
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[17] )
Yes
No
Navicat Data Modeler
No
No
Yes
Yes - Import Database from server/ODBC
Yes - Export SQL
No
No
MySQL Workbench
Yes
Yes
Yes
Yes - CSV , HTML , JSON , MS Excel , SQL INSERTS, Tab-separated, XML
Yes - CSV , HTML , JSON , MS Excel , SQL INSERTS, Tab-separated, XML
Yes
No
Oracle SQL Developer
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Orbada
No
Yes
Yes
SQL script
SQL script, CSV, XML, HTML, PDF, Excel, DBF, DataText
No
No
pgAdmin
Yes
Yes
No
CSV , Text , or binary
CSV , text , HTML , XML
Yes
No
phpMyAdmin
Yes
Some
Yes
Yes - CSV , SQL , XML , Excel , ODS
Yes - CSV , LaTeX , Excel , Word , ODS , ODT , XML , SQL , YAML , Texy! , JSON , NHibernate , PHP , PDF , MediaWiki
Yes
Git
SQL Database Studio
Yes
Yes
No
CSV , XML , MS Excel
CSV , HTML , MS Excel , SQL INSERTS, Tab-separated, XML
No
No
SQLyog
Yes
?
Yes
Yes
Yes
?
?
SQL Server Management Studio
Yes
Yes
?
Yes
Yes
Yes
Yes[18]
Yes
SQuirreL SQL
?
Yes
Yes
Yes
?
No
?
Toad
Some
No
Yes
Yes
Yes
Yes
SVN , CVS , TFS , VSS
Toad Data Modeler
No
?
Yes
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
No
?
TOra
Some
No
Yes
Yes
Yes
Yes
No
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
Notes
^ Only incremental, by manually going through each table and clicking "Add to graph".
^ Generated SQL must be executed outside Toad Data Modeler.
References