Comparison of database administration tools

From Wikipedia, the free encyclopedia
Jump to navigation Jump to search

Template:Short description

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

Template:Sort-under

Product Creator Latest stable release date Latest stable release License Template:Verth Template:Verth Template:Verth Template:Verth Template:Verth Template:Verth Template:Verth Template:Verth Template:Verth Template:Verth Other Programming language
Template:Rh |DatabaseSpy Altova Template:DatabaseSpy version Template:DatabaseSpy version Proprietary Yes No No Yes Yes Yes Yes Yes Yes IBM Db2, Sybase, MS Access C++
Template:Rh |Database Workbench Upscene Productions 2024-12-16 6.6.0 Proprietary Yes Template:Needs Template:Needs Yes Yes Yes Yes Yes Yes InterBase, Firebird, NexusDB, MariaDB Delphi
Template:Rh |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
Template:Rh |Galaxy Galaxy 2025-06-01 v0.0.105 Proprietary
  1. REDIRECT Template:Coming soon
 Yes
  1. REDIRECT Template:Coming soon
  1. REDIRECT Template:Coming soon
 Yes Yes
  1. REDIRECT Template:Coming soon
  1. REDIRECT Template:Coming soon
 Yes
  1. REDIRECT Template:Coming soon
 Clickhouse Typescript
Template:Rh |DBeaver Serge Rider 2025-04-06 25.0.2[1] Template:Open source Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes EXASOL, IBM Db2, Apache Derby, Firebird, Mimer SQL, all with JDBC driver Java
Template:Rh |DBEdit Jef Van Den Ouweland 2012-05-10 2.4.6 Template:Open source Yes Yes Yes Yes Yes Yes Yes No Yes Yes IBM Db2, HSQLDB, Apache Derby, H2 Java
Template:Rh |dbForge Edge Devart 2025-04-18 5.1 Proprietary Yes Template:Needs Template:Needs Yes Yes Yes Yes YesTemplate:NoteTag No No 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
Template:Rh |HeidiSQL Ansgar Becker Template:HeidiSQL version Template:HeidiSQL version Template:Open source Yes Template:Needs Template:Needs Yes Yes Yes Yes Delphi
Template:Rh |Microsoft SQL Server Management Studio Microsoft 2025-06-23[2] 21.3.7 Proprietary Yes No No Yes including SSAS management, and MDX, DMX, XMLA languages .NET
Template:Rh |MySQL Workbench Oracle Corporation Template:MySQL Workbench version Template:MySQL Workbench version Template:Yes-no Yes Yes Yes Yes C++–C# Objective-C Python
Template:Rh |Navicat PremiumSoft CyberTech Ltd. 2021-11-23 16[3] Proprietary Yes Yes Template:Needs Yes Yes Yes Yes Yes Yes Delphi Objective-C
Template:Rh |Navicat Data Modeler PremiumSoft CyberTech Ltd. 2015-12-10 2.1 Proprietary Yes Yes Yes Yes Yes Yes Yes Yes Yes Delphi Objective-C
Template:Rh |Oracle Enterprise Manager Oracle Corp. 2015-06-16 12.1.0.5 Proprietary Yes No Yes Yes Yes Yes IBM Db2, Sybase, TimesTen Java
Template:Rh |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
Template:Rh |pgAdmin pgAdmin Development Team Template:Wikidata; Template:Time ago Template:Wikidata Template:Open source Yes Yes Yes Yes C++
Template:Rh |phpLiteAdmin Dane Iracleous, Christopher Kramer, others 2019-09-05 1.9.8.2[4] Template:Open source Yes Yes Yes No No No No No No Yes PHP
Template:Rh |phpMyAdmin phpMyAdmin Development Team Template:PhpMyAdmin version Template:PhpMyAdmin version Template:Open source Yes Yes Yes Yes Drizzle, MariaDB php
Template:Rh |SQL Database Studio Jan Prochazka 2016-05-27 3.4.1 Proprietary Yes No No No No No Yes .NET, WPF, C#
Template:Rh |SQLyog Webyog Softworks Pvt. Ltd. Template:SQLyog version Template:SQLyog version Template:Open source Yes Template:Needs Template:Needs Yes C++
Template:Rh |SQuirreL SQL Colin Bell, Gerd Wagner, Rob Manning, others Template:SQuirreL SQL Client version Template:SQuirreL SQL Client version Template:Open source 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
Template:Rh |Toad Quest Software Various Various Proprietary Yes No No Yes Yes Yes Yes IBM Db2, Sybase Delphi, C#.NET
Template:Rh |Toad Data Modeler Quest Software 2020-10-19 7.3[5] Proprietary Yes No No Yes Yes Yes Yes IBM Db2, MS Access, Sybase Delphi
Template:Rh |TOra Community 2017-07-04 3.2 Template:Open source Yes Yes Yes Yes Yes Yes Teradata C++–Qt
Product Creator Latest stable release date Latest stable release License Template:Verth Template:Verth Template:Verth Template:Verth Template:Verth Template:Verth Template:Verth Template:Verth Template:Verth Template:Verth 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

Template:Sort-under

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
Galaxy desktop Yes Yes
  1. REDIRECT Template:Coming soon
  1. REDIRECT Template:Coming soon
 Yes Yes
  1. REDIRECT Template:Coming soon
  1. REDIRECT Template:Coming soon
 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 ?
dbForge desktop Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Some
Microsoft SQL Server Management Studio desktop Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes No
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
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[6]
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
Galaxy
  1. REDIRECT Template:Coming soon
 Yes Yes Yes TXT, CSV, MS Excel
  1. REDIRECT Template:Coming soon
  1. REDIRECT Template:Coming soon
DBeaver Yes Yes Yes Yes Yes No With Eclipse plugins
DBEdit No No No No MS Excel, PDF, Text, SQL script No ?
dbForge Yes No Yes Yes - TXT, CSV, XML, XLS, XLSX, DBF, JSON, Google Sheets, MS Access, or from any ODBC source Yes - TXT, CSV, XML, XLS, XLSX, DBF, JSON, Google Sheets, MS Access, PDF, HTML, RTF, SQL script, or from any ODBC source Yes YesTemplate:NoteTag 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[7]) 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[7]) 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
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[8] 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
dbForge Yes Yes Yes Yes No
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 ?
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[9] Yes[10] Yes Yes ?
SQuirreL SQL Yes Yes YesTemplate:NoteTag ? No
Toad Yes Yes Yes Yes ?
Toad Data Modeler No Yes Yes YesTemplate:NoteTag ?

See also

Notes

Template:NoteFoot

References

<templatestyles src="Reflist/styles.css" />

  1. ↑ Script error: No such module "citation/CS1".
  2. ↑ Script error: No such module "citation/CS1".
  3. ↑ Script error: No such module "citation/CS1".
  4. ↑ Script error: No such module "citation/CS1".
  5. ↑ Script error: No such module "citation/CS1".
  6. ↑ custom system via TeamServer in Enterprise Edition
  7. ↑ a b title= Navicat feature matrix
  8. ↑ Script error: No such module "citation/CS1".
  9. ↑ Script error: No such module "citation/CS1".
  10. ↑ Script error: No such module "citation/CS1".

Script error: No such module "Check for unknown parameters".

Template:Database

Retrieved from "http://debianws.lexgopc.com/wiki143/index.php?title=Comparison_of_database_administration_tools&oldid=5835874"