Database management tools
Comparison of database management tools
Lists of database tools
64 bit OS architecture
DBeaver Community Edition v. 4.2.1 & Enterprise Edition v. 4.2.1 (32bit & 64bit) for Win , Mac & Linux
- Import format: Import file into table is not availabe.
- Export format: Export query result set as CSV, HTML, XML, JSON file [1]. More formats e.g. XLSX is available in the paid version [2].
- Specify Field and Row Terminators:
- Engine supported: "MySQL, PostgreSQL, SQLite, Oracle, DB2, SQL Server, MariaDB, Sybase, Teradata, Netezza, etc. Supports NoSQL databases: MongoDB, Cassandra, Redis, Apache Hive"
- Software licenses: Open source - Apache License Version 2.0[3]. Source code is available on github.
- Data type of cell value: Need to convert string to number/date time type!
- Comments: Quick to export large data (rows count exceed 10,000 rows)
DbVisualizer Free v. 10.0.1 & Pro v. 10.0.1 (64bit) for Win , Mac & Linux
- Import format: N/A. The feature is available in the paid version.
- Export format: Export query result set as CSV/HTML. More formats e.g. SQL, XML, XLS/XLSX, JSON is available in the paid version.[4]
- Specify Field and Row Terminators:
- SQL syntax checker: Available
- Engine supported: "DB2 for LUW, H2, JavaDB/Derby, Mimer SQL, MySQL, NuoDB, PostgreSQL, Oracle, Redshift, SQLite, SQL Server, Sybase SQL Anywhere, Sybase ASE, Vertica"
- Software licenses: Proprietary
- Data type of cell value:
- Comments: Quick to export large data (rows count exceed 10,000 rows)
$ SQLyog Ultimate v. 12.4.3 for Win
- Import format: Import Access, Excel, CSV, XML file & ODVC source into table[5]
- Export format: Export query result set as CSV, Json, HTML/XML, Excel XML file[6][7]
- Specify Field and Row Terminators: available
- Engine supported: MySQL & MariaDB[8]
- Software licenses: Proprietary
- Data type of cell value:
- Comments: Quick to export large data (rows count exceed 10,000 rows)
MySQL Workbench v. 6.3 for Win , Mac & Linux
- Import format: Import CSV, Json file into table[9]
- Export format: Export query result set as TXT, CSV, Excel Spreadsheet (XML), HTML/XML, SQL INSERT statement
- Specify Field and Row Terminators: n/a
- SQL syntax checker: Available
- Engine supported: MySQL
- Software licenses: Proprietary[10]
- Data type of cell value:
- Comments: Excel Spreadsheet (XML) generated by MySql Workbench may not be able to opened by Microsoft Excel 2016 or LibreOffice Calc v. 5.2.3.3 when the structure of file is complicated, I met the error message "XML parsing error".
Database .NET for Win 64 bit OS support is available in the paid version.
- Import format: "CSV (comma delimited) /TSV (tab delimited) /PSV (pipe delimited) /SSV (semicolon delimited) /TXT/XML"
- Export format: "CSV/TSV/PSV/SSV/SQL (INSERT statement) /XLSX/XLS/XML/JSON/HTM/MD"
- Specify Field and Row Terminators:
- Engine supported: "SQL Server, SQL Azure, LocalDB, MySQL, Oracle, IBM DB2, Informix, PostgreSQL, HP Vertica, NuoDB, Teradata, Sybase ASE, Firebird, SQLite, SQLCe, Access, Excel, VistaDB, dBase, FoxPro, OleDB, ODBC, OData, Text, NoSQL"
- Software licenses: Proprietary
- Data type of cell value: Need to convert string to number/date time type!
- Comments:
Orbada - Database manager download | SourceForge.net v. Sao Paulto, Brazil 1.2.5.395 (2016/12/6)
- Import format:
- Export format: CSV, SQL statement ...
- Specify Field and Row Terminators:
- Engine supported: MySQL ...
- Software licenses: GNU General Public License version 2.0 (GPLv2)
- Data type of cell value:
- Comments: When I tried to export the query result set as XLS file but no file was generated!
Sequel Pro for Mac
- Import format: CSV, SQL
- Export format: (1) Export query result set as CSV/XML file. (2) Export table as SQL/CSV/XML and DOT (ERD Database Structure) file.
- Specify Field and Row Terminators: Available
- SQL syntax checker:
- Engine supported: MySQL[11]
- Software licenses: Proprietary
- Data type of cell value:
- Comments:
$ DataGrip: Cross-Platform IDE for Databases & SQL by JetBrains v. 2017.2.3 for Win & Mac 30 days trial
- Import format: Import CSV file into table
- Export format: Export query result set in two ways (1) Export as file such as CSV, Json, HTML/XML (2) "Export as queries" update or insert queries[12]
- Specify Field and Row Terminators:
- Engine supported: MySQL, PostgreSQL, Microsoft SQL Server, Microsoft Azure, Oracle, Amazon Redshift, Sybase, DB2, SQLite, HyperSQL, Apache Derby and H2[13]
- Software licenses: Proprietary
- Data type of cell value:
- Comments:
$ Navicat Premium v. 12 for Win & Mac 14 days trial
- Import format: Import TXT, CSV, HTML/XML, EXCEL, JSON, Access & DBF file into table [14].
- Export format: Export query result set as TXT, CSV, HTML/XML, EXCEL, JSON, Access & DBF file
- Specify Field and Row Terminators: available
- Engine supported: MySQL, MariaDB, SQL Server, Oracle, PostgreSQL, SQLite, Amazon RDS, Amazon Aurora, Amazon Redshift, SQL Azure, Oracle Cloud & Google Cloud[15]
- Software licenses: Proprietary
- Data type of cell value: No need to convert string to number/date time type!
- Comments:
$ SQLPro Studio v. 1.0.127 for Mac
- Import format: Import CSV file into table
- Export format: Export query result set as CSV, Json, XML
- Specify Field and Row Terminators:
- Engine supported: MySQL, MSSQL, Oracle, PostgreSQL
- Software licenses: Proprietary
- Data type of cell value:
- Comments:
$ Toad Edge v. 1.1 for Win & Mac 30 days trial
- Import format: Import CSV file into table
- Export format: Export query result set as CSV, SQL insert/merge statement
- Specify Field and Row Terminators:
- Engine supported: MySQL
- Software licenses: Proprietary
- Data type of cell value:
- Comments:
32 bit OS architecture
Toad for MySQL v. 8.0.0.296 for Win
- Import format: Import CSV, XLS/XLSX/XLSM, FIL, TXT, XML file into table[16]
- Export format: Export query result set as CSV, Excel, HTML/XML, SQL script
- Specify Field and Row Terminators:
- Engine supported: MySQL
- Software licenses: Proprietary
- Data type of cell value:
- Comments:
HeidiSQL Portable v. 9.4.0.5125 for Win
- Import format: Import CSV/TEXT file into table[17]
- Export format: Export query result set as CSV, Json, HTML/XML, SQL query, LaTeX, Wiki markup, Markdown or PHP files."[18]
- Specify Field and Row Terminators:
- Engine supported:
- Software licenses: GPL[19]
- Data type of cell value:
- Comments:
FlySpeed SQL Query Free v. 3.5.6.3 (32bit) for Win
- Import format: N/A
- Export format: N/A. Export query result set as Text, CSV, Excel & XML file is available in the paid version.[20]
- Specify Field and Row Terminators:
- Engine supported: "Microsoft SQL Server, Oracle, MySQL, MS Access, MS Excel, PostgreSQL, InterBase, Firebird, IBM DB2, Informix, Sybase, Advantage DB, SQLite"
- Software licenses: Proprietary
- Data type of cell value:
- Comments:
MySQL-Front v. 6.0 (Build 2.20) (32bit) for Win
- Import format: Import CSV, Excel file (XLS), MS Access file & ODBC data source into table
- Export format: Export query result set as CSV, Excel file (XLS), XML, HTML, PDF file
- Specify Field and Row Terminators:
- Engine supported: MySQL
- Software licenses: Proprietary
- Data type of cell value:
- Comments: Excel file (XLS) has 65,536 rows limit!
$ SQLWave v. 6.12.2 (32 bit) for Win 15 days trial
- Import format: N/A
- Export format: Export query result set as SQL file
- Specify Field and Row Terminators:
- Engine supported: MySQL
- Software licenses: Proprietary
- Data type of cell value:
- Comments:
$ MyDB Studio v. 1.3 (32bit) for Win 30 days trial
- Import format: CSV
- Export format: Export query result set as SQL file
- Specify Field and Row Terminators:
- Engine supported: MySQL
- Software licenses: Proprietary
- Data type of cell value:
- Comments: I met the message "Error 1300: Invalid utf8 character string: '\xA5D\xA4\xC0' " after query.
Architecture independent
- Import format:
- Export format:
- Specify Field and Row Terminators:
- Engine supported: MySQL
- Software licenses: GNU General Public License, version 2
- Data type of cell value:
- Comments:
- Import format: Import SQL file into table
- Export format: Export query result set as SQL, CSV (,), CSV (;) & TSV
- Specify Field and Row Terminators:
- Engine supported: MySQL, SQLite, PostgreSQL, MS SQL, Oracle
- Software licenses: "Free for commercial and non-commercial use (Apache License or GPL 2)". Source code is available on GitHub
- Data type of cell value:
- Comments:
(left blank intentionally)
* Import format: Import ... file into table * Export format: Export query result set as ... * Specify Field and Row Terminators: * SQL syntax checker: * Engine supported: * Software licenses: * Data type of cell value: * Comments:
Further reading
- Wikipedia contributors (2017). Comparison of database tools - Wikipedia [Last visited: 2017-09-26]
- Category:Database administration tools - Wikipedia [Last visited: 2017-09-26]
- Rob Gravelle (2016). Top 10 MySQL GUI Tools — DatabaseJournal.com [Last visited: 2017-09-15]
- Andrew Tabona (2015). Top 10 free database tools for sys admins [Last visited: 2017-09-26]
- (4) What is the best MySQL client for Mac OS X or Windows? - Quora [Last visited: 2018-02-15]
- Export MySQL query to Excel file
- SQL syntax debug
References
- ↑ Features | DBeaver
- ↑ FAQ | DBeaver Enterprise Edition
- ↑ About | DBeaver
- ↑ Data Visualization & DB Management Features - DbVisualizer
- ↑ Import External Data - SQLyog Knowledge Base
- ↑ Export Data - SQLyog Knowledge Base
- ↑ Exporting Resultset - SQLyog Knowledge Base
- ↑ What is SQLyog - SQLyog Knowledge Base
- ↑ MySQL :: MySQL Workbench Manual :: 6.5 Data Export and Import
- ↑ MySQL :: MySQL Workbench Manual :: Preface and Legal Notices
- ↑ Getting Connected
- ↑ Import/Export Options From CSV To Database - Features | DataGrip
- ↑ Features - DataGrip
- ↑ Navicat Premium 功能列表 | Navicat
- ↑ Navicat Premium | 以單一的 GUI 同時連線到不同類型的資料庫
- ↑ Export and Import your database data - Toad Extension for Eclipse Blog - Toad Extension for Eclipse - Toad World
- ↑ Screenshot: Import Textfile
- ↑ Screenshot: Export Textfile
- ↑ License
- ↑ FlySpeed SQL Query - all essential tools to work with data