Changelog

Changed

• Added a Copy Connection option to the DB Explorer.
• Added Create, Rename and Drop database for supported databases to the DB Explorer context menu.

Fixed

• Added an option to allow self-signed certificates in chain to be accepted.
• Added Docs option to Help + Suggestions.
• Added more options to the context menu in the DB Explorer.

Changed

• Added a Help + Suggestions panel to the sidebar.

Fixed

• MySQL 5.7 introspection error when user does not have create permissions on the database.
• Redshift was not showing columns in late binding views.
• If introspection fails, the connection will still be allowed to be opened.

Changed

• Added a Help + Suggestions panel to the sidebar.

Fixed

• MySQL 5.7 introspection error when user does not have create permissions on the database.
• Redshift was not showing columns in late binding views.
• If introspection fails, the connection will still be allowed to be opened.

Changed

• Added support for DigitalOcean cloud provider.
• Added option to open a GitHub issue when connection and introspection errors occur.

Fixed

• Added a check to ensure duplicate connection IDs are not present in settings.json if edited manually.

Changed

• Charts now appear beside the results, not on top of them.

Fixed

• Inline code completions via Copilot now work correctly.
• Download chart button now works correctly.
• Redshift was not showing all columns in a view in the DB Explorer.

Changed

• Relationships now support multi key relationships, and the expanded relationship icon will be highlighted and stay visible when the relationship is selected.
• Added a connection option to disable public key retrieval for MySQL and MariaDB, which is enabled by default.
• If a connection has a color, it will be used for the highlight color (e.g., primary keys, active icons) instead of the default purple.

Changed

• Data relationships are now navigated using an icon in the cell when mousing over, instead of the expand icon in the first column.

Fixed

• Postgres (and derivatives like Redshift) would show duplicate tables in the DB Explorer if the table name was in multiple schemas.

Changed

• Published to the Open VSIX marketplace.

Fixed

• Authentication was not working in the Cursor version of VS Code.

Changed

• Redshift support added.
• Selecting a database when creating a connection is now optional for supported types.

Fixed

• Server versions are now shown in the DB Explorer when connected, an expanded version is shown in the tooltip.

Fixed

• Token counts for AI completions are now correctly calculated.
• Mongo driver does not show the new SQL file/notebook options in the DB Explorer.

Changed

• Added schema aware AI code completions for the SQL language, using GitHub Copilot if available or llama-3.1.

Fixed

• MySQL and MariaDB no longer require root user privileges to connect.
• MariaDB 11.2.5 bug with introspection fixed.

Changed

• Updated README.

Changed

• Added DDEV as a zero config source.

Changed

• Added Cloudflare as a cloud provider.
• Added support for Cloudflare D1.

Fixed

• Previous result tabs sometimes failed to display data when revisited.
• SQLite/libSQL would not display the primary key correctly if it was not a sequence.