Comparison of database administration tools

Short description: None

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.

## Contents

* 1 General
* 2 Features
* 3 Features (continued)
* 4 Features - visual design and reverse engineering
* 5 See also
* 6 Notes
* 7 References

## General

Product  | Creator  | Latest stable release date  | Latest stable release  | License | Runs on Windows | Runs on Mac OS X | Runs on Linux | Oracle | MySQL | PostgreSQL | MS SQL Server | ODBC  | JDBC  | SQLite | Other  | Programming language

|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|

DatabaseSpy | Altova  | 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  | requires Wine | requires Wine | Yes  | Yes  | Yes  | Yes  | Yes  |  |  | InterBase, Firebird, SQL Anywhere, NexusDB and 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[1] | Apache License | Yes  | Yes  | Yes  | Yes  | Yes  | Yes  | Yes  | Yes  | Yes  | Yes  | EXASOL, IBM Db2, Apache Derby, Firebird, Mimer SQL, and 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  | GPL | Yes  | requires Wine | requires Wine |  | Yes  | Yes  | Yes  |  |  | Yes  |  | Embarcadero Delphi
Maatkit | Baron Schwartz  | 2010-06-01  | 5247  | GPL | Yes  | Yes  | Yes  |  | Yes  |  |  |  |  |  |  | Perl
Microsoft SQL Server Management Studio | Microsoft | 2023-11-13[2] | 19.2  | Proprietary | Yes  | No  | No  |  |  |  | Yes  |  |  |  | including SSAS management, and MDX, DMX, and XMLA languages  | .Net
ModelRight | ModelRight | 2016-12-??  | 4.1[3][4] | Proprietary | Yes  | No  | No  | Yes  | Yes  | Yes  | Yes  | Yes  |  |  | IBM Db2, Db2/zOS, MS Access  | C++
MySQL Workbench | Oracle Corporation | Community Ed: GPL

Standard Ed: Commercial Proprietary

| Yes  | Yes  | Yes  |  | Yes  |  |  |  |  |  |  | C++/C# Objective-C Python (programming language)
Navicat | PremiumSoft CyberTech Ltd.  | 2021-11-23  | 16[5] | Proprietary | Yes  | Yes  | requires Wine | Yes  | Yes  | Yes  | Yes  | Yes  |  | Yes  |  | Borland Delphi Objective-C
Navicat Data Modeler | PremiumSoft CyberTech Ltd.  | 2015-12-10  | 2.1  | Proprietary | Yes  | Yes  | Yes  | Yes  | Yes  | Yes  | Yes  | Yes  |  | Yes  |  | Borland 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  | 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[6] | PostgreSQL License | Yes  | Yes  | Yes  |  |  | Yes  |  |  |  |  |  | C++
phpLiteAdmin | Dane Iracleous, Christopher Kramer and others  | 2019-09-05  | 1.9.8.2[7] | GPL | Yes  | Yes  | Yes  | No  | No  | No  | No  | No  | No  | Yes  |  | PHP
phpMyAdmin | phpMyAdmin Development Team  | 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.  | GPLv2  | Yes  | requires Wine | requires Wine |  | Yes  |  |  |  |  |  |  | C++
SQuirreL SQL | Colin Bell, Gerd Wagner, Rob Manning and others  | GPLv2 & LGPLv2  | 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 | Embarcadero Delphi, C#.NET
Toad Data Modeler | Quest Software | 2020-10-19  | 7.3[8] | Proprietary | Yes  | No  | No  | Yes  | Yes  | Yes  | Yes  |  |  |  | IBM Db2, MS Access, Sybase | Embarcadero 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 Mac OS X | 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  | 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[9]
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[10])  | 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[10])  | 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[11] | 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

| Visual query builder  | Visual schema/model/E-R diagram design  | Reverse engineering | Forward engineering  | ER diagram groupboxes

|
|
|
|
|

Adminer | Yes  | Yes  | Yes  | No  | No
Altova DatabaseSpy | Yes  | Yes  | Yes  | Yes  | ?
Database Workbench | Yes  | Yes  | Yes  | ?  | Yes
DBeaver | No  | Yes  | Yes  | No  | ?
DBEdit | No  | No  | No  | No  | No
ModelRight | No  | Yes  | Yes  | Yes  | Yes
Navicat | Yes  | Yes  | Yes  | Yes  | Yes
Navicat Data Modeler | Yes  | Yes  | Yes  | Yes  | Yes
MySQL Workbench | Yes  | Yes  | Yes  | Yes  | Yes
Oracle SQL Developer | Yes  | Yes  | Yes  | Yes  | ?
Orbada  | No  | No  | No  | No  | No
pgAdmin | Yes  | No  | No  | No  | No
phpMyAdmin | Yes  | Yes  | Yes  | No  | No
SQL Database Studio | Yes  | Yes  | Yes  | Yes  | No
SQL Server Management Studio | ?  | Yes  | Yes  | ?  | ?
SQLyog | Yes[12] | Yes[13] | Yes  | Yes  | ?
SQuirreL SQL  | Yes  | Yes  | Yes[note 1] | ?  | No
Toad | Yes  | Yes  | Yes  | Yes  | ?
Toad Data Modeler | No  | Yes  | Yes  | Yes[note 2] | ?

## 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

1. ↑ Only incremental, by manually going through each table and clicking "Add to graph".
2. ↑ Generated SQL must be executed outside Toad Data Modeler.

## References

1. ↑ "Release 23.2.5". 2023-11-20. https://github.com/dbeaver/dbeaver/releases/tag/23.2.5.
2. ↑ "Download SQL Server Management Studio (SSMS)". 24 May 2023. https://docs.microsoft.com/en-us/sql/ssms/download-sql-server-management-studio-ssms.
3. ↑ "An Overview of Database Diagram Tools Available for PostgreSQL" (in en). 2019-07-05. https://severalnines.com/blog/overview-database-diagram-tools-available-postgresql.
4. ↑ "ModelRight Download full version trials". http://www.modelright.com/downloads.asp.
5. ↑ "Welcome to Navicat's Press Center - Navicat". https://www.navicat.com/en/company/press.
6. ↑ "pgAdmin - PostgreSQL Tools". https://www.pgadmin.org/.
7. ↑ "Phpliteadmin / Public / Downloads — Bitbucket". https://bitbucket.org/phpliteadmin/public/downloads.
8. ↑ "Toad Data Modeler 7.3 - Release Notes". https://support.quest.com/technical-documents/toad-data-modeler/7.3/release-notes.
9. ↑ custom system via TeamServer in Enterprise Edition
10. ↑ 10.0 10.1 title= Navicat feature matrix
11. ↑ "Source Control in SQL Server Management Studio (SSMS)". 21 November 2016. https://blogs.technet.microsoft.com/dataplatforminsider/2016/11/21/source-control-in-sql-server-management-studio-ssms/.
12. ↑ "SQLYog query builder". http://www.webyog.com/en/screenshots_sqlyog.php.
13. ↑ "SQLYog schema designer". http://www.webyog.com/en/screenshots_sqlyog.php.

* v
* t
* e

Database

Main|

* Requirements
* Theory
* Models
* Database management system
* Machine
* Server
* Application
* Connection
* datasource
* DSN
* Administrator
* Lock
* Types
* Tools

Languages|

* Data definition
* Data manipulation
* Query
* information retrieval

Security|

* Activity monitoring
* Audit
* Forensics
* Negative database

Design|

* Entities and relationships (and Enhanced notation)
* Normalization
* Refactoring
* Cardinality

Programming|

* Abstraction layer
* Object-relational mapping

Management|

* Virtualization
* Tuning
* caching
* Migration
* Preservation
* Integrity

See also|

* Database-centric architecture
* Intelligent database
* Two-phase locking
* Locks with ordered sharing
* Load file
* Publishing
* Halloween Problem
* Log shipping

* Book
* Category
* WikiProject

0.00

(0 votes)

Original source: https://en.wikipedia.org/wiki/Comparison of database administration tools. Read more

|

Retrieved from "https://handwiki.org/wiki/index.php?title=Software:Comparison_of_database_administration_tools&oldid=1058997"
*[TSV]: Tab Separated Values
*[v]: View this template
*[t]: Discuss this template
*[e]: Edit this template