Released: Oct 24, 2023

Updates in 2024

Features

• AI Assistant - This release includes two ways to utilize new, built-in AI functionality:
  • AI Chat Dialog - The AI Chat Dialog allows you to send requests to ChatGPT to create sample SQL statements, create sample data for a given table structure, create relations between tables that have no keys yet, and so on. Once you send a request and receive the response, you can copy and paste the returned SQL into an existing file or create a new SQL file with the response.
  • AI Extensions - In addition to the AI Chat Dialog, DatabaseSpy now includes powerful AI-powered extensions in the SQL Editor menu that use ChatGPT:
    • AI-complete: Generate SQL statements, tables, etc.
    • AI-explain: Describe what a particular statement will accomplish when executed.
    • AI-explain-error: When a statement execution throws an error, a link is provided in the Messages window to request more information and troubleshooting steps.
    • Pretty-print: Format SQL code to make it easier to read and understand.
• Native support for MySQL and MariaDB - DatabaseSpy supports connecting to MySQL and MariaDB (as well as numerous other databases) via generic ADO/ODBC/JDBC connections. DiffDog now supports native connections to MySQL and MariaDB without the need for external drivers, which is much faster and more convenient.
• Horizontal mouse wheel scrolling - To make it easier to navigate, DatabaseSpy users can now scroll horizontally using the mouse wheel by pressing the shift key or tilting the mousewheel left or right.