Movatterモバイル変換

[0]ホーム
URL:

Jump to content
WikipediaThe Free Encyclopedia
Search

Comparison of database administration tools

From Wikipedia, the free encyclopedia
(Redirected fromComparison of database tools)

This article has multiple issues. Please helpimprove it or discuss these issues on thetalk page.(Learn how and when to remove these messages)
icon
This articlemay need to be rewritten to comply with Wikipedia'squality standards. Relevant discussion may be found on thetalk page.You can help. The talk page may contain suggestions.(August 2025)
Parts of this article (those related to table) need to beupdated. The reason given is:terms llike "coming soon" etc... Please help update this article to reflect recent events or newly available information.(August 2025)
This articlemay containoriginal research. Pleaseimprove it byverifying the claims made and addinginline citations. Statements consisting only of original research should be removed.(August 2025) (Learn how and when to remove this message)
Some of this article'slisted sourcesmay not bereliable. Please help improve this article by looking for better, more reliable sources. Unreliable citations may be challenged and removed.(August 2025) (Learn how and when to remove this message)
(Learn how and when to remove this message)

The following tables compare general and technical information for a number of availabledatabase 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.[1]

General

[edit]
ProductCreatorLatest stable release dateLatest stable release versionLicense
Runs on
Windows
Runs on
macOS
Runs on
Linux
OtherProgramming language
SQL CommanderElphsoft Ltd.2026-01-252.0.0.11ProprietaryYesYesYesYesYesYesYesYesMongoDB,IBM DB2,IBM Informix,MariaDB,InterBase,Firebird,MariaDB,SAP Advantage Database,SAP SQL Anywhere,MS Access,Teradata,DBF,ExcelDelphi
DatabaseSpyAltova2025-10-21[±]2026[2]ProprietaryYesNoNoYesYesYesYesYesYesIBM Db2,Sybase,MS AccessC++
Database WorkbenchUpscene Productions2026-02-116.10.0ProprietaryYesneedsWineneedsWineYesYesYesYesYesYesInterBase,Firebird,NexusDB,MariaDBDelphi
DataGripJetBrains2025-12-022025.3ProprietaryYesYesYesYesYesYesYesNoYesYesSybase,IBM Db2,H2,Hypersonic SQL,Amazon Redshift,Apache Derby,Redis,MongoDB,Snowflake,Exasol,BigQuery,Cassandra,ClickHouse,CockroachDB,CouchbaseJava
DBeaverSerge Rider2026-01-2925.3.4[3]Apache LicenseYesYesYesYesYesYesYesYesYesYesEXASOL,IBM Db2,Apache Derby,Firebird,Mimer SQL, all withJDBC driverJava
DbVisualizerDbVis Software2025-12-0125.3ProprietaryYesYesYesYesYesYesYesNoYesYesMongoDB,Redis,Snowflake,Elasticsearch,IBM Db2,SQLite,Microsoft Access,Databricks,Apache Cassandra,MariaDB,DynamoDB,Azure SQL Database,Google BigQuery,Apache Hive,Teradata,Apache Solr,SAP ASE,ClickHouse,Amazon Redshift,Presto,H2,DuckDB,Trino,SingleStore, all withJDBC driverJava
DBEditJef Van Den Ouweland2012-05-102.4.6GPLYesYesYesYesYesYesYesNoYesYesIBM Db2,HSQLDB,Apache Derby,H2Java
dbForge EdgeDevart2025-04-185.1ProprietaryYesneedsCrossOverneedsWine orCrossOverYesYesYesYesYes[note 1]NoNoMariaDB, 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
HeidiSQLAnsgar Becker2026-01-30[±]12.15.1.1[4]GPLYesYesYesYesYesYesYesDelphi
Microsoft SQL Server Management StudioMicrosoft2026-02-10[5]22.3.0ProprietaryYesNoNoYesincluding SSAS management, and MDX, DMX, XMLA languages.NET
MySQL WorkbenchOracle Corporation2025-12-17[±]8.0.46[6]Community Ed:GPL

Standard Ed: Commercial Proprietary

YesYesYesYesC++–C#Objective-CPython
NavicatPremiumSoft CyberTech Ltd.2025-07-2117.3[7]ProprietaryYesYesYesYesYesYesYesYesYesDelphiObjective-C
Navicat Data ModelerPremiumSoft CyberTech Ltd.2024-05-134ProprietaryYesYesYesYesYesYesYesYesYesDelphiObjective-C
Oracle Enterprise ManagerOracle Corp.2025-05-2113.5ProprietaryYesNoYesYesYesYesIBM Db2,Sybase,TimesTenJava
Oracle SQL DeveloperOracle Corp.2024-12-1624.3.1.347.1826ProprietaryYesYesYesYesYesNoYesYesYesMicrosoft Access,Sybase,IBM Db2,TeradataJava
pgAdminpgAdmin Development Team2025-12-11; 2 months ago9.11[8] Edit this on WikidataPostgreSQL LicenseYesYesYesYesC++
phpLiteAdminDane Iracleous, Christopher Kramer, others2019-09-051.9.8.2[9]GPLYesYesYesNoNoNoNoNoNoYesPHP
phpMyAdminphpMyAdmin Development Team

2025-10-08; 4 months ago[±]

5.2.3[10] Edit this on Wikidata

GPLYesYesYesYesDrizzle,MariaDBphp
SQL Database StudioJan Prochazka2017-05-103.6.2ProprietaryYesNoNoNoNoNoYes.NET,WPF,C#
SQLyogWebyog Softworks Pvt. Ltd.2025-09-26[±]13.3.1[11]GPLv2YesneedsWineneedsWineYesC++
SQuirreL SQLColin Bell, Gerd Wagner, Rob Manning, others2025-09-18[±]5.0.0[12]GPLv2 &LGPLv2YesYesYesYesYesYesYesYesYesYesAccess, 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
ToadQuest SoftwareVariousVariousProprietaryYesNoNoYesYesYesYesIBM Db2,SybaseDelphi,C#.NET
Toad Data ModelerQuest Software2025-03-058.0[13]ProprietaryYesNoNoYesYesYesYesIBM Db2,MS Access,SybaseDelphi
TOraCommunity2017-07-043.2GPLYesYesYesYesYesYesTeradataC++–Qt
ProductCreatorLatest stable release dateLatest stable release versionLicense
Runs on
Windows
Runs on
macOS
Runs on
Linux
OtherProgramming language

Features

[edit]

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
ToolsUser InterfaceCreate & Alter wizardBrowseAuto CompletionSyntax coloredMulti server supportMonitoring server
DatabaseTableProcedureTriggerDatabaseTableProcedureTrigger
AdminerBrowser-basedYesYesYesYesYesYesYesYesNoYes??
Altova DatabaseSpydesktopYesYesYesYesYesYesYesYesYesYesYes?
Database WorkbenchdesktopYesYesYesYesYesYesYesYesYesYesYes?
DataGripdesktopYesYesYesYesYesYesYesYesYesYesYesNo
GalaxydesktopYesYesYesYesYesYesYesNo
DBeaverdesktopYesYesYesYesYesYesYesYesYesYesYesYes
DbVisualizerdesktopYesYesYesYesYesYesYesYesYesYesYesYes
DBEditdesktopNoNoNoNoYesYesYesNoNoYesNo?
dbForgedesktopYesYesYesYesYesYesYesYesYesYesYesSome
Microsoft SQL Server Management StudiodesktopYesYesYesYesYesYesYesYesYesYesYesNo
MySQL WorkbenchdesktopYesYesYesYesYesYesYesYesYesYesYesSome
NavicatdesktopYesYesYesYesYesYesYesYesYesYesYes?
Navicat Data ModelerdesktopNoYesNoYesNoNoNoNoYesYesYes?
Oracle Enterprise ManagerBrowser-basedYesYesYesYesYesYesYesYesYesYes?Yes
Oracle SQL DeveloperdesktopYesYesYesYesYesYesYesYesYesYesYesNo
pgAdminBrowser-based, desktop (TDI)YesYesYesYesYesYesYesYesYesYesYesSome
phpLiteAdminBrowser-basedYesYesNoYesYesYesNoYesYesYes??
phpMyAdminBrowser-basedYesYesYesYesYesYesYesYesYesYesYesYes
SQL Database StudiodesktopYesYesYesYesYesYesYesYesYesYesYesNo
SQLyogdesktopYesYesYesYesYesYesYesYesYesYes??
SQuirreL SQLdesktop????YesYes??YesYesSome?
ToaddesktopYesYesYesYesYesYesYesYesYesYesYesYes
Toad Data ModelerdesktopYesYesYesYesSomeSomeSomeSomeNoYes??
TOradesktopNoYesYesNoYesYesYesYesYesYesYes?

Features (continued)

[edit]

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 managerPluginCompareImportExportDebuggerSource controlSpatial Visualization
AdminerYesYesYesSQL script, CSV,TSV or the above inzip (as a plugin); imports of server-site file in SQL or SQL in zip,gzip orbzip2SQL script, CSV,TSV or the above inzip,gzip,bzip2; XML (as a plugin)NoGit
Altova DatabaseSpyNoNoYesCSV, XMLXML, XML Structure, CSV, HTML, MS ExcelNo?
Database WorkbenchYesNoYesYesYesYesYes[14]
DataGripNoYesYesYesTXT,CSV,HTML,XML,DBF,SQL script,RTF,MS Word,MS Excel,MS Access,MS Windows Clipboard,Paradox file,WK1,WQ1,SLK,DIF,LDIFNoYes
GalaxyYesYesYesTXT,CSV,MS Excel
DBeaverYesYesYesYesYesNoWithEclipse plugins
DbVisualizerNoNoYesYesYesNoGit
DBEditNoNoNoNoMS Excel,PDF, Text, SQL scriptNo?
dbForgeYesNoYesYes -TXT,CSV,XML,XLS, XLSX,DBF,JSON,Google Sheets,MS Access, or from anyODBC sourceYes -TXT,CSV,XML,XLS, XLSX,DBF,JSON,Google Sheets,MS Access,PDF,HTML,RTF,SQL script, or from anyODBC sourceYesYes[note 2]No
NavicatYesNoYesYes -TXT,CSV,DBF,HTML,MS Excel,MS Access,Paradox file,WK1,WQ1,XML, or from any ODBC source (See link for limitations[15])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[15])YesNo
Navicat Data ModelerNoNoYesYes - Import Database from server/ODBCYes - Export SQLNoNo
MySQL WorkbenchYesYesYesYes -CSV,HTML,JSON,MS Excel, SQL INSERTS, Tab-separated,XMLYes -CSV,HTML,JSON,MS Excel, SQL INSERTS, Tab-separated,XMLYesNo
Oracle SQL DeveloperYesYesYesYesYesYesYesYes
pgAdminYesYesNoCSV,Text, or binaryCSV,text,HTML,XMLYesNo
phpMyAdminYesSomeYesYes -CSV,SQL,XML,Excel,ODSYes -CSV,LaTeX,Excel,Word,ODS,ODT,XML,SQL,YAML,Texy!,JSON,NHibernate,PHP,PDF,MediaWikiYesGit
SQL Database StudioYesYesNoCSV,XML,MS ExcelCSV,HTML,MS Excel, SQL INSERTS, Tab-separated,XMLNoNo
SQLyogYes?YesYesYes??
SQL Server Management StudioYesYes?YesYesYesYes[16]Yes
SQuirreL SQL?YesYesYes?No?
ToadSomeNoYesYesYesYesSVN,CVS,TFS,VSS
Toad Data ModelerNo?YesToad for Oracle ERD, ERWin 7.1(XML) via pluginSQL; meta data in XML; report in HTML/RTF/CSV; diagram as BMP, JPEG, PNGNo?
TOraSomeNoYesYesYesYesNo

Features - visual design and reverse engineering

[edit]

Legend:

  • Visual schema/E-R design: the ability to drawentity-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 builderVisual schema/model/E-R diagram designReverse engineeringForward engineeringER diagram groupboxes
AdminerYesYesYesNoNo
Altova DatabaseSpyYesYesYesYes?
Database WorkbenchYesYesYes?Yes
DBeaverNoYesYesNo?
DbVisualizerYesYes???
DBEditNoNoNoNoNo
dbForgeYesYesYesYesNo
NavicatYesYesYesYesYes
Navicat Data ModelerYesYesYesYesYes
MySQL WorkbenchYesYesYesYesYes
Oracle SQL DeveloperYesYesYesYes?
pgAdminYesNoNoNoNo
phpMyAdminYesYesYesNoNo
SQL Database StudioYesYesYesYesNo
SQL Server Management Studio?YesYes??
SQLyogYes[17]Yes[18]YesYes?
SQuirreL SQLYesYesYes[note 3]?No
ToadYesYesYesYes?
Toad Data ModelerNoYesYesYes[note 4]?

See also

[edit]

Notes

[edit]
  1. ^Only for Data Import/Export features.
  2. ^Only for SQL Server and MySQL/MariaDB.
  3. ^Only incremental, by manually going through each table and clicking "Add to graph".
  4. ^Generated SQL must be executed outside Toad Data Modeler.

References

[edit]
  1. ^K, Vijay."Top 10 Database Administration Tools in 2025: Features, Pros, Cons & Comparison".DevOpsSchool. RetrievedNovember 3, 2025.
  2. ^"What's New in DatabaseSpy". altova.com. Retrieved2026-02-11.
  3. ^"Release 25.3.4".GitHub. 2026-01-29. Retrieved2026-02-11.
  4. ^"Releases - HeidiSQL/HeidiSQL". github.com. Retrieved2026-02-11.
  5. ^"Release Notes for SQL Server Management Studio (SSMS)". 2026-02-10.
  6. ^"Releases - mysql/mysql-workbench". github.com. Retrieved2026-02-11.
  7. ^"Welcome to Navicat's Press Center - Navicat".www.navicat.com. Retrieved2026-02-11.
  8. ^"Release 9.11". 11 December 2025. Retrieved13 December 2025.
  9. ^"Phpliteadmin / Public / Downloads — Bitbucket".
  10. ^"phpMyAdmin 5.2.3". 8 October 2025. Retrieved10 October 2025.
  11. ^Team, Webyog (2024-07-23)."Announcing SQLyog 13.3.1".Webyog. Retrieved2026-02-11.
  12. ^"SQuirrel SQL Client - Browse/1-stable". sourceforge.net. Retrieved2026-02-11.
  13. ^"Toad Data Modeler 8.0 - Release Notes".support.quest.com. Retrieved2026-02-11.
  14. ^custom system via TeamServer in Enterprise Edition
  15. ^abtitle= Navicat feature matrix
  16. ^"Source Control in SQL Server Management Studio (SSMS)". 21 November 2016.
  17. ^"SQLYog query builder". Archived fromthe original on 2010-10-26. Retrieved2008-05-29.
  18. ^"SQLYog schema designer". Archived fromthe original on 2010-10-26. Retrieved2008-05-29.
Main
Languages
Security
Design
Programming
Management
Lists of
See also
Retrieved from "https://en.wikipedia.org/w/index.php?title=Comparison_of_database_administration_tools&oldid=1337875877"
Categories:
Hidden categories:
[8]ページ先頭
©2009-2026 Movatter.jp