A5:SQL Mk-2 (x64)
Rating
5
Reviews
2
App details
About A5:SQL Mk-2 (x64)
A5:SQL Mk-2 is a free SQL development environment & ER diagram development tool developed to support database development that is complicated.
Key features
-
Connection to various databases (You can connect directly to Oracle, PostgreSQL, MySQL, SQLite)
-
SQL input completion function (also analyzes common table expressions and subqueries)
-
Create and edit SQL with GUI
-
Show SQL Execution plan
-
Format SQL
-
Continuous execution of SQL delimited by ";" (semicolon) or "/" (slash) or "GO" at the beginning of the line
-
Multiple result sets are output to Excel collectively
-
Execute SQL twice to output differences to Excel (also possible to compare multiple result sets)
-
Execution of SQL with parameters
-
Filtering of tables and query result sets (narrowing down)
-
Directive specifying a column name, a result set title, etc. in a query comment Function to embed decree
-
Table editor that can be output to Excel
-
Display property of table (additional RDBMS information)
-
Show table source
-
Export/Import of table contents
-
Insert a large amount of test dummy data into the table
-
Create ER diagram
-
Create ER diagram from database
-
Create DDL of database from ER diagram