Description

• 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