Comparison of database tools
The following tables compare general and technical information for a number of available :Category:Database administration tools|database administrator 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
Features
Legend- 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
Features (continued)
- User manager:
- * Yes - user manager with support for database and schema permissions as well as for individual object 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 ; 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 | Git | - | ||||
| Altova DatabaseSpy | CSV, XML | XML, XML Structure, CSV, HTML, MS Excel | - | |||||
| DaDaBIK | CSV | - | ||||||
| Database Workbench | - | |||||||
| 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 | - TXT, CSV, HTML, XML, DBF, SQL script, RTF, MS Word, MS Excel, MS Access, MS Windows Clipboard, Paradox file, WK1, WQ1, SLK, DIF, LDIF | - | |||||
| 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 | - | ||||
| SQL Database Studio | CSV, XML, MS Excel | CSV, HTML, MS Excel, SQL INSERTS, Tab-separated, XML | - | |||||
| SQLyog | - | |||||||
| SQL Server Management Studio | ||||||||
| SQuirreL SQL | - | |||||||
| Toad | SVN, CVS, TFS, VSS | - | ||||||
| Toad Data Modeler | Toad for Oracle ERD, ERWin 7.1 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
- 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 | |||||
| Altova DatabaseSpy | |||||
| Database Deployment Manager | |||||
| Database Workbench | |||||
| DBeaver | |||||
| DBEdit | |||||
| ModelRight | |||||
| Navicat | |||||
| Navicat Data Modeler | |||||
| MySQL Workbench | |||||
| Oracle SQL Developer | |||||
| Orbada | |||||
| pgAdmin | |||||
| phpMyAdmin | |||||
| SQL Database Studio | |||||
| SQL Server Management Studio | |||||
| SQLyog | |||||
| SQuirreL SQL | |||||
| Toad | |||||
| Toad Data Modeler |