Database management tools

Lists of database tools

MySQL Workbench v. 6.3 for Win , macOS & Linux

Import format: Import CSV, Json file into table^[1]
Export format: Export query result set as TXT, CSV, Excel Spreadsheet (XML), HTML/XML, SQL INSERT statement
Engine supported: MySQL
Software licenses: Proprietary^[2]
Comments: Excel Spreadsheet (XML) 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"
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
Comments:

DbVisualizer Free v. 10.0.1 (64bit) for Win , macOS & 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.^[3]
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
Comments:

$ SQLyog Ultimate v. 12.4.3 for Win

Import format: Import Access, Excel, CSV, XML file & ODVC source into table^[4]
Export format: Export query result set as CSV, Json, HTML/XML, Excel XML file^[5]^[6]
Engine supported: MySQL & MariaDB^[7]
Software licenses: Proprietary
Comments: Quick to export

Import format: Import CSV file into table
Export format: Export query result set in two ways (1) Export as file/text such as CSV, Json, HTML/XML (2) "Export as queries" update or insert queries^[8]
Engine supported: MySQL, PostgreSQL, Microsoft SQL Server, Microsoft Azure, Oracle, Amazon Redshift, Sybase, DB2, SQLite, HyperSQL, Apache Derby and H2^[9]
Software licenses: Proprietary
Comments:

$ SQLPro Studio v. 1.0.127 for macOS

$ Toad Edge v. 1.1 for Win & macOS 30 days trial

Toad for MySQL v. 8.0.0.296 for Win

HeidiSQL Portable v. 9.4.0.5125 for Win

Import format: Import CSV/TEXT file into table^[11]
Export format: Export query result set as CSV, Json, HTML/XML, SQL query, LaTeX, Wiki markup, Markdown or PHP files."^[12]
Engine supported:
Software licenses: GPL^[13]
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.^[14]
Engine supported: "Microsoft SQL Server, Oracle, MySQL, MS Access, MS Excel, PostgreSQL, InterBase, Firebird, IBM DB2, Informix, Sybase, Advantage DB, SQLite"
Software licenses: Proprietary
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
Engine supported: MySQL
Software licenses: Proprietary
Comments: Excel file (XLS) has 65,536 rows limit!

$ SQLWave v. 6.12.2 (32 bit) for Win 15 days trial

$ MyDB Studio v. 1.3 (32bit) for Win 30 days trial

Import format: CSV
Export format: Export query result set as SQL file
Engine supported: MySQL
Software licenses: Proprietary
Comments: I met the message "Error 1300: Invalid utf8 character string: '\xA5D\xA4\xC0' " after query.

(left blank intentionally)

* Import format: Import ... file into table
* Export format: Export query result set as ...
* Engine supported:
* Software licenses:
* Comments: