Login
Login

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.

General

{{sort-under}}

class="wikitable sortable sort-under" style="font-size: 85%; text-align: center"

|+

style="background: #ececec;"

! Product

! Creator

! style="min-width: 60px" | Latest stable release date

! Latest stable release

!License

! {{verth|Runs on
Windows}}

! {{verth|Runs on
macOS}}

! {{verth|Runs on
Linux}}

!{{verth|Oracle}}

!{{verth|MySQL}}

!{{verth|PostgreSQL}}

!{{verth|MS SQL Server}}

!{{verth|ODBC}}

!{{verth|JDBC}}

!{{verth|SQLite}}

! Other

! Programming language

{{rh}} |DatabaseSpy

|Altova

| {{DatabaseSpy version|releasedate}}

| {{DatabaseSpy version}}

| {{proprietary}}

| {{yes}}

| {{no}}

| {{no}}

| {{yes}}

| {{yes}}

| {{yes}}

| {{yes}}

| {{yes}}

| {{yes}}

|

|IBM Db2, Sybase, MS Access

|C++

{{rh}} |Database Workbench

| Upscene Productions

| 2024-12-16

| 6.6.0

| {{proprietary}}

| {{yes}}

| {{needs|needs Wine}}

| {{needs|needs Wine}}

| {{yes}}

| {{yes}}

| {{yes}}

| {{yes}}

| {{yes}}

|

| {{yes}}

|InterBase, Firebird, NexusDB, MariaDB

|Delphi

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

{{rh}} |Galaxy

| Galaxy

| 2025-06-01

| v0.0.105

| {{proprietary}}

| {{Coming Soon}}

| {{yes}}

| {{Coming Soon}}

| {{Coming Soon}}

| {{yes}}

| {{yes}}

| {{Coming Soon}}

| {{Coming Soon}}

| {{yes}}

| {{Coming Soon}}

|Clickhouse

|Typescript

{{rh}} |DBeaver

| Serge Rider

| 2025-04-06

| 25.0.2{{Cite web |url=https://github.com/dbeaver/dbeaver/releases/tag/25.0.2 |title=Release 25.0.2 |date=2025-04-06 |website=GitHub |access-date=2025-04-14}}

|{{open source|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

{{rh}} |DBEdit

| Jef Van Den Ouweland

| 2012-05-10

| 2.4.6

| {{open source|GPL}}

| {{yes}}

| {{yes}}

| {{yes}}

| {{yes}}

| {{yes}}

| {{yes}}

| {{yes}}

| {{no}}

| {{yes}}

| {{yes}}

|IBM Db2, HSQLDB, Apache Derby, H2

|Java

{{rh}} |dbForge Edge

|Devart

| 2025-04-18

| 5.1

| {{proprietary}}

| {{yes}}

| {{needs|needs CrossOver}}

| {{needs|needs Wine or CrossOver}}

| {{yes}}

| {{yes}}

| {{yes}}

| {{yes}}

| {{yes}}{{NoteTag|Only for Data Import/Export features.}}

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

{{rh}} |HeidiSQL

| Ansgar Becker

| {{HeidiSQL version|releasedate}}

| {{HeidiSQL version}}

| {{open source|GPL}}

| {{yes}}

| {{needs|needs Wine}}

| {{needs|needs Wine}}

|

| {{yes}}

| {{yes}}

| {{yes}}

|

|

| {{yes}}

|

|Delphi

{{rh}} |Microsoft SQL Server Management Studio

|Microsoft

| 2025-05-28{{cite web |date=28 May 2025 |title=Release Notes for SQL Server Management Studio (SSMS) |url=https://learn.microsoft.com/ssms/release-notes-21}}

| 21.1.3

| {{proprietary}}

| {{yes}}

| {{no}}

| {{no}}

|

|

|

| {{yes}}

|

|

|

| including SSAS management, and MDX, DMX, XMLA languages

|.NET

{{rh}} |MySQL Workbench

|Oracle Corporation

| {{MySQL Workbench version|releasedate}}

| {{MySQL Workbench version}}

| {{yes-no|Community Ed: GPL

Standard Ed: Commercial Proprietary}}

| {{yes}}

| {{yes}}

| {{yes}}

|

| {{yes}}

|

|

|

|

|

|

|C++–C# Objective-C Python

{{rh}} |Navicat

| PremiumSoft CyberTech Ltd.

| 2021-11-23

| 16{{Cite web |title=Welcome to Navicat's Press Center - Navicat |url=https://www.navicat.com/en/company/press |access-date=2022-04-17 |website=www.navicat.com}}

| {{proprietary}}

| {{yes}}

| {{yes}}

| {{needs|needs Wine}}

| {{yes}}

| {{yes}}

| {{yes}}

| {{yes}}

| {{yes}}

|

| {{yes}}

|

|Delphi Objective-C

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

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

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

{{rh}} |pgAdmin

| pgAdmin Development Team

|{{wikidata|qualifier|raw|Q310572|P348|P577}}; {{Time ago|{{wikidata|qualifier|raw|Q310572|P348|P577}}}}

|{{wikidata|property|reference|edit|Q310572|P348}}

|{{open source|PostgreSQL License}}

| {{yes}}

| {{yes}}

| {{yes}}

|

| |

| {{yes}}

|

|

|

|

|

|C++

{{rh}} |phpLiteAdmin

| Dane Iracleous, Christopher Kramer, others

| 2019-09-05

| 1.9.8.2{{Cite web|url=https://bitbucket.org/phpliteadmin/public/downloads|title=Phpliteadmin / Public / Downloads — Bitbucket}}

| {{open source|GPL}}

| {{yes}}

| {{yes}}

| {{yes}}

| {{no}}

| {{no}}

| {{no}}

| {{no}}

| {{no}}

| {{no}}

| {{yes}}

|

|PHP

{{rh}} |phpMyAdmin

| phpMyAdmin Development Team

|{{phpMyAdmin version|releasedate}}

|{{phpMyAdmin version}}

| {{open source|GPL}}

| {{yes}}

| {{yes}}

| {{yes}}

|

| {{yes}}

|

|

|

|

|

|Drizzle, MariaDB

|php

{{rh}} |SQL Database Studio

| Jan Prochazka

| 2016-05-27

| 3.4.1

| {{proprietary}}

| {{yes}}

| {{no}}

| {{no}}

| {{no}}

| {{no}}

| {{no}}

| {{yes}}

|

|

|

|

| .NET, WPF, C#

{{rh}} |SQLyog

| Webyog Softworks Pvt. Ltd.

| {{SQLyog version|releasedate}}

| {{SQLyog version}}

| {{open source|GPLv2}}

| {{yes}}

| {{needs|needs Wine}}

| {{needs|needs Wine}}

|

| {{yes}}

|

|

|

|

|

|

|C++

{{rh}} |SQuirreL SQL

| Colin Bell, Gerd Wagner, Rob Manning, others

| {{SQuirreL SQL Client version|releasedate}}

| {{SQuirreL SQL Client version}}

| {{open source|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

{{rh}} |Toad

|Quest Software

| Various

| Various

| {{proprietary}}

| {{yes}}

| {{no}}

| {{no}}

| {{yes}}

| {{yes}}

|

| {{yes}}

| {{yes}}

|

|

|IBM Db2, Sybase

|Delphi, C#.NET

{{rh}} |Toad Data Modeler

|Quest Software

| 2020-10-19

| 7.3{{Cite web |title=Toad Data Modeler 7.3 - Release Notes |url=https://support.quest.com/technical-documents/toad-data-modeler/7.3/release-notes |access-date=2022-04-17 |website=support.quest.com}}

| {{proprietary}}

| {{yes}}

| {{no}}

| {{no}}

| {{yes}}

| {{yes}}

| {{yes}}

| {{yes}}

|

|

|

|IBM Db2, MS Access, Sybase

|Delphi

{{rh}} |TOra

| Community

| 2017-07-04

| 3.2

| {{open source|GPL}}

| {{yes}}

| {{yes}}

| {{yes}}

| {{yes}}

| {{yes}}

| {{yes}}

|

|

|

|

| Teradata

|C++–Qt

|+

style="background: #ececec;"

! Product

! Creator

! style="min-width: 60px" | Latest stable release date

! Latest stable release

!License

! {{verth|va=top|Runs on
Windows}}

! {{verth|va=top|Runs on
macOS}}

! {{verth|va=top|Runs on
Linux}}

!{{verth|va=top|Oracle}}

!{{verth|va=top|MySQL}}

!{{verth|va=top|PostgreSQL}}

!{{verth|va=top|MS SQL Server}}

!{{verth|va=top|ODBC}}

!{{verth|va=top|JDBC}}

!{{verth|va=top|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

{{sort-under}}

class="wikitable sortable sort-under" style="font-size: 85%; text-align: center"
rowspan=2 | Tools

! rowspan=2 | User Interface

! colspan=4 | Create & Alter wizard

! colspan=4 | Browse

! rowspan=2 | Auto Completion

! rowspan=2 | Syntax colored

! rowspan=2 | Multi server support

! rowspan=2 | Monitoring server

Database

! Table

! Procedure

! Trigger

! Database

! Table

! Procedure

! Trigger

style="text-align: left; background: #ececec;" | Adminer

| Browser-based

| {{yes}}

| {{yes}}

| {{yes}}

| {{yes}}

| {{yes}}

| {{yes}}

| {{yes}}

| {{yes}}

| {{no}}

| {{Yes}}

| {{dunno}}

| {{dunno}}

style="text-align: left; background: #ececec;" | Altova DatabaseSpy

| desktop

| {{yes}}

| {{yes}}

| {{yes}}

| {{yes}}

| {{yes}}

| {{yes}}

| {{yes}}

| {{yes}}

| {{Yes}}

| {{Yes}}

| {{Yes}}

| {{dunno}}

style="text-align: left; background: #ececec;" | Database Workbench

| desktop

| {{Yes}}

| {{Yes}}

| {{Yes}}

| {{Yes}}

| {{Yes}}

| {{Yes}}

| {{Yes}}

| {{Yes}}

| {{Yes}}

| {{Yes}}

| {{Yes}}

| {{dunno}}

style="text-align: left; background: #ececec;" |DataGrip

| desktop

| {{Yes}}

| {{Yes}}

| {{Yes}}

| {{Yes}}

| {{Yes}}

| {{Yes}}

| {{Yes}}

| {{Yes}}

| {{Yes}}

| {{Yes}}

| {{Yes}}

| {{no}}

style="text-align: left; background: #ececec;" |Galaxy

| desktop

| {{Yes}}

| {{Yes}}

| {{Coming Soon}}

| {{Coming Soon}}

| {{Yes}}

| {{Yes}}

| {{Coming Soon}}

| {{Coming Soon}}

| {{Yes}}

| {{Yes}}

| {{Yes}}

| {{no}}

style="text-align: left; background: #ececec;" | DBeaver

| desktop

| {{Yes}}

| {{Yes}}

| {{Yes}}

| {{Yes}}

| {{Yes}}

| {{Yes}}

| {{Yes}}

| {{Yes}}

| {{Yes}}

| {{Yes}}

| {{Yes}}

| {{yes}}

style="text-align: left; background: #ececec;" | DBEdit

| desktop

| {{No}}

| {{No}}

| {{No}}

| {{No}}

| {{Yes}}

| {{Yes}}

| {{Yes}}

| {{No}}

| {{No}}

| {{Yes}}

| {{No}}

| {{dunno}}

style="text-align: left; background: #ececec;" | dbForge

| desktop

| {{Yes}}

| {{Yes}}

| {{Yes}}

| {{Yes}}

| {{Yes}}

| {{Yes}}

| {{Yes}}

| {{Yes}}

| {{Yes}}

| {{Yes}}

| {{Yes}}

| {{Some}}

style="text-align: left; background: #ececec;" | Microsoft SQL Server Management Studio

| desktop

| {{yes}}

| {{yes}}

| {{yes}}

| {{yes}}

| {{yes}}

| {{yes}}

| {{yes}}

| {{yes}}

| {{yes}}

| {{yes}}

| {{yes}}

| {{no}}

style="text-align: left; background: #ececec;" | MySQL Workbench

| desktop

| {{yes}}

| {{yes}}

| {{yes}}

| {{yes}}

| {{yes}}

| {{yes}}

| {{yes}}

| {{yes}}

| {{yes}}

| {{yes}}

| {{yes}}

| {{some}}

style="text-align: left; background: #ececec;" | Navicat

| desktop

| {{yes}}

| {{yes}}

| {{yes}}

| {{yes}}

| {{yes}}

| {{yes}}

| {{yes}}

| {{yes}}

| {{yes}}

| {{yes}}

| {{yes}}

| {{dunno}}

style="text-align: left; background: #ececec;" | Navicat Data Modeler

| desktop

| {{no}}

| {{yes}}

| {{no}}

| {{yes}}

| {{no}}

| {{no}}

| {{no}}

| {{no}}

| {{yes}}

| {{yes}}

| {{yes}}

| {{dunno}}

style="text-align: left; background: #ececec;" | Oracle Enterprise Manager

| Browser-based

| {{yes}}

| {{yes}}

| {{yes}}

| {{yes}}

| {{yes}}

| {{yes}}

| {{yes}}

| {{yes}}

| {{yes}}

| {{yes}}

| {{dunno}}

| {{yes}}

style="text-align: left; background: #ececec;" | Oracle SQL Developer

| desktop

| {{yes}}

| {{yes}}

| {{yes}}

| {{yes}}

| {{yes}}

| {{yes}}

| {{yes}}

| {{yes}}

| {{yes}}

| {{yes}}

| {{yes}}

| {{no}}

style="text-align: left; background: #ececec;" | pgAdmin

| Browser-based, desktop (TDI)

| {{Yes}}

| {{Yes}}

| {{Yes}}

| {{Yes}}

| {{Yes}}

| {{Yes}}

| {{Yes}}

| {{Yes}}

| {{Yes}}

| {{Yes}}

| {{Yes}}

| {{some}}

style="text-align: left; background: #ececec;" | phpLiteAdmin

| Browser-based

| {{yes}}

| {{yes}}

| {{no}}

| {{yes}}

| {{yes}}

| {{yes}}

| {{no}}

| {{yes}}

| {{yes}}

| {{yes}}

| {{dunno}}

| {{dunno}}

style="text-align: left; background: #ececec;" | phpMyAdmin

| Browser-based

| {{yes}}

| {{yes}}

| {{yes}}

| {{yes}}

| {{yes}}

| {{yes}}

| {{yes}}

| {{yes}}

| {{yes}}

| {{yes}}

| {{yes}}

| {{yes}}

style="text-align: left; background: #ececec;" | SQL Database Studio

| desktop

| {{yes}}

| {{yes}}

| {{yes}}

| {{yes}}

| {{yes}}

| {{yes}}

| {{yes}}

| {{yes}}

| {{yes}}

| {{yes}}

| {{yes}}

| {{no}}

style="text-align: left; background: #ececec;" | SQLyog

| desktop

| {{yes}}

| {{yes}}

| {{yes}}

| {{yes}}

| {{yes}}

| {{yes}}

| {{yes}}

| {{yes}}

| {{yes}}

| {{yes}}

| {{dunno}}

| {{dunno}}

style="text-align: left; background: #ececec;" | SQuirreL SQL

| desktop

| {{dunno}}

| {{dunno}}

| {{dunno}}

| {{dunno}}

| {{yes}}

| {{yes}}

| {{dunno}}

| {{dunno}}

| {{yes}}

| {{yes}}

| {{some}}

| {{dunno}}

style="text-align: left; background: #ececec;" | Toad

| desktop

| {{yes}}

| {{yes}}

| {{yes}}

| {{yes}}

| {{yes}}

| {{yes}}

| {{yes}}

| {{yes}}

| {{yes}}

| {{yes}}

| {{yes}}

| {{yes}}

style="text-align: left; background: #ececec;" | Toad Data Modeler

| desktop

| {{yes}}

| {{yes}}

| {{yes}}

| {{yes}}

| {{some}}

| {{some}}

| {{some}}

| {{some}}

| {{no}}

| {{yes}}

| {{dunno}}

| {{dunno}}

style="text-align: left; background: #ececec;" | TOra

| desktop

| {{no}}

| {{yes}}

| {{yes}}

| {{no}}

| {{yes}}

| {{yes}}

| {{yes}}

| {{yes}}

| {{yes}}

| {{yes}}

| {{yes}}

| {{dunno}}

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

class="wikitable sortable" style="font-size: 85%; text-align: center"
style="background: #ececec;"

!|

!| user manager

!| Plugin

!| Compare

!| Import

!| Export

!| Debugger

!| Source control

!| Spatial Visualization

style="text-align: left; background: #ececec;" | 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

style="text-align: left; background: #ececec;" |Altova DatabaseSpy

| {{no}}

| {{no}}

| {{yes}}

| CSV, XML

| XML, XML Structure, CSV, HTML, MS Excel

| {{no}}

| {{dunno}}

style="text-align: left; background: #ececec;" | Database Workbench

| {{yes}}

| {{no}}

| {{yes}}

| {{yes}}

| {{yes}}

| {{yes}}

| {{yes}}custom system via TeamServer in Enterprise Edition

style="text-align: left; background: #ececec;" |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}}

style="text-align: left; background: #ececec;" |Galaxy

| {{Coming Soon}}

| {{yes}}

| {{yes}}

| {{yes}}

| TXT, CSV, MS Excel

| {{Coming Soon}}

| {{Coming Soon}}

style="text-align: left; background: #ececec;" |DBeaver

| {{yes}}

| {{yes}}

| {{yes}}

| {{yes}}

| {{yes}}

| {{no}}

| With Eclipse plugins

style="text-align: left; background: #ececec;" |DBEdit

| {{no}}

| {{no}}

| {{no}}

| {{no}}

| MS Excel, PDF, Text, SQL script

| {{no}}

| {{dunno}}

style="text-align: left; background: #ececec;" |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}}

| {{yes}}{{NoteTag|Only for SQL Server and MySQL/MariaDB.}}

| {{no}}

style="text-align: left; background: #ececec;" |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[https://www.navicat.com/en/products/navicat-for-mysql-feature-matrix title= Navicat feature matrix])

| {{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)

| {{yes}}

| {{no}}

style="text-align: left; background: #ececec;" |Navicat Data Modeler

| {{no}}

| {{no}}

| {{yes}}

| {{yes}} - Import Database from server/ODBC

| {{yes}} - Export SQL

| {{no}}

| {{no}}

style="text-align: left; background: #ececec;" |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}}

style="text-align: left; background: #ececec;" | Oracle SQL Developer

| {{yes}}

| {{yes}}

| {{yes}}

| {{yes}}

| {{yes}}

| {{yes}}

| {{yes}}

| {{yes}}

style="text-align: left; background: #ececec;" |pgAdmin

| {{yes}}

| {{yes}}

| {{no}}

| CSV, Text, or binary

| CSV, text, HTML, XML

| {{yes}}

| {{no}}

style="text-align: left; background: #ececec;" | 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

style="text-align: left; background: #ececec;" | SQL Database Studio

| {{yes}}

| {{yes}}

| {{no}}

| CSV, XML, MS Excel

| CSV, HTML, MS Excel, SQL INSERTS, Tab-separated, XML

| {{no}}

| {{no}}

style="text-align: left; background: #ececec;" | SQLyog

| {{yes}}

| {{dunno}}

| {{yes}}

| {{yes}}

| {{yes}}

| {{dunno}}

| {{dunno}}

style="text-align: left; background: #ececec;" | SQL Server Management Studio

| {{yes}}

| {{yes}}

| {{dunno}}

| {{yes}}

| {{yes}}

| {{yes}}

| {{yes}}{{Cite web|url=https://blogs.technet.microsoft.com/dataplatforminsider/2016/11/21/source-control-in-sql-server-management-studio-ssms/|title = Source Control in SQL Server Management Studio (SSMS)|date = 21 November 2016}}

| {{yes}}

style="text-align: left; background: #ececec;" | SQuirreL SQL

| {{dunno}}

| {{yes}}

| {{yes}}

| {{yes}}

| {{dunno}}

| {{no}}

| {{dunno}}

style="text-align: left; background: #ececec;" | Toad

| {{some}}

| {{No}}

| {{Yes}}

| {{Yes}}

| {{Yes}}

| {{Yes}}

| SVN, CVS, TFS, VSS

style="text-align: left; background: #ececec;" | Toad Data Modeler

| {{no}}

| {{dunno}}

| {{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}}

| {{dunno}}

style="text-align: left; background: #ececec;" | 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

class="wikitable sortable" style="font-size: 85%; text-align: center"
style="background: #ececec;"

!|

!| Visual query builder

!| Visual schema/model/E-R diagram design

!| Reverse engineering

!| Forward engineering

!| ER diagram groupboxes

style="text-align: left; background: #ececec;" |Adminer

| {{yes}}

| {{yes}}

| {{yes}}

| {{no}}

| {{no}}

style="text-align: left; background: #ececec;" |Altova DatabaseSpy

| {{yes}}

| {{yes}}

| {{yes}}

| {{yes}}

| {{dunno}}

style="text-align: left; background: #ececec;" |Database Workbench

| {{yes}}

| {{yes}}

| {{yes}}

| {{dunno}}

| {{yes}}

style="text-align: left; background: #ececec;" |DBeaver

| {{no}}

| {{yes}}

| {{yes}}

| {{no}}

| {{dunno}}

style="text-align: left; background: #ececec;" |DBEdit

| {{no}}

| {{no}}

| {{no}}

| {{no}}

| {{no}}

style="text-align: left; background: #ececec;" |dbForge

| {{yes}}

| {{yes}}

| {{yes}}

| {{yes}}

| {{no}}

style="text-align: left; background: #ececec;" | Navicat

| {{yes}}

| {{yes}}

| {{yes}}

| {{yes}}

| {{yes}}

style="text-align: left; background: #ececec;" |Navicat Data Modeler

| {{yes}}

| {{yes}}

| {{yes}}

| {{yes}}

| {{yes}}

style="text-align: left; background: #ececec;" |MySQL Workbench

| {{yes}}

| {{yes}}

| {{yes}}

| {{yes}}

| {{yes}}

style="text-align: left; background: #ececec;" |Oracle SQL Developer

| {{yes}}

| {{yes}}

| {{yes}}

| {{yes}}

| {{dunno}}

style="text-align: left; background: #ececec;" |pgAdmin

| {{yes}}

| {{no}}

| {{no}}

| {{no}}

| {{no}}

style="text-align: left; background: #ececec;" | phpMyAdmin

| {{yes}}

| {{yes}}

| {{yes}}

| {{no}}

| {{no}}

style="text-align: left; background: #ececec;" | SQL Database Studio

| {{yes}}

| {{yes}}

| {{yes}}

| {{yes}}

| {{no}}

style="text-align: left; background: #ececec;" | SQL Server Management Studio

| {{dunno}}

| {{yes}}

| {{yes}}

| {{dunno}}

| {{dunno}}

style="text-align: left; background: #ececec;" | SQLyog

| {{yes}}{{Cite web |url=http://www.webyog.com/en/screenshots_sqlyog.php |title=SQLYog query builder |access-date=2008-05-29 |archive-date=2010-10-26 |archive-url=https://web.archive.org/web/20101026070544/http://webyog.com/en/screenshots_sqlyog.php |url-status=dead }}

| {{yes}}{{Cite web |url=http://www.webyog.com/en/screenshots_sqlyog.php |title=SQLYog schema designer |access-date=2008-05-29 |archive-date=2010-10-26 |archive-url=https://web.archive.org/web/20101026070544/http://webyog.com/en/screenshots_sqlyog.php |url-status=dead }}

| {{yes}}

| {{yes}}

| {{dunno}}

style="text-align: left; background: #ececec;" | SQuirreL SQL

| {{yes}}

| {{yes}}

| {{yes}}{{NoteTag|Only incremental, by manually going through each table and clicking "Add to graph".}}

| {{dunno}}

| {{no}}

style="text-align: left; background: #ececec;" | Toad

| {{Yes}}

| {{Yes}}

| {{Yes}}

| {{Yes}}

| {{dunno}}

style="text-align: left; background: #ececec;" | Toad Data Modeler

| {{no}}

| {{yes}}

| {{yes}}

| {{yes}}{{NoteTag|Generated SQL must be executed outside Toad Data Modeler.}}

| {{dunno}}

See also

Notes

{{NoteFoot}}

References

{{Reflist}}

{{Database}}

{{DEFAULTSORT:Comparison Of Database Tools}}

Tools