Comparison of database administration tools
Topic: Software
From HandWiki - Reading time: 8 min
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.
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
References
- ↑ "Release 23.2.5". 2023-11-20. https://github.com/dbeaver/dbeaver/releases/tag/23.2.5.
- ↑ "Download SQL Server Management Studio (SSMS)". 24 May 2023. https://docs.microsoft.com/en-us/sql/ssms/download-sql-server-management-studio-ssms.
- ↑ "An Overview of Database Diagram Tools Available for PostgreSQL" (in en). 2019-07-05. https://severalnines.com/blog/overview-database-diagram-tools-available-postgresql.
- ↑ "ModelRight Download full version trials". http://www.modelright.com/downloads.asp.
- ↑ "Welcome to Navicat's Press Center - Navicat". https://www.navicat.com/en/company/press.
- ↑ "pgAdmin - PostgreSQL Tools". https://www.pgadmin.org/.
- ↑ "Phpliteadmin / Public / Downloads — Bitbucket". https://bitbucket.org/phpliteadmin/public/downloads.
- ↑ "Toad Data Modeler 7.3 - Release Notes". https://support.quest.com/technical-documents/toad-data-modeler/7.3/release-notes.
- ↑ custom system via TeamServer in Enterprise Edition
- ↑ "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/.
- ↑ "SQLYog query builder". http://www.webyog.com/en/screenshots_sqlyog.php.
- ↑ "SQLYog schema designer". http://www.webyog.com/en/screenshots_sqlyog.php.
| Main | |
|---|---|
| Languages | |
| Security | |
| Design |
|
| Programming | |
| Management | |
| See also | |
 |  |
Licensed under CC BY-SA 3.0 | Source: https://handwiki.org/wiki/Software:Comparison_of_database_administration_tools1 | Status: cached on July 30 2024 00:41:17↧ Download this article as ZWI file
EncycloReader
is supported by the 
KSF