Added a Show Only Discovered Connections option to the DB Explorer.
Preliminary support for Oracle, including Instant Client.
Formatting provider for SQL files and notebook cells now added.
Added a Copy Name option to the context menu when clicking on a column header.
Added CURRENT_TIMESTAMP as a valid value for date columns when editing data.
Added support for organizations in Neon.
Fixed
Autocomplete correctly escapes identifiers, and does not suggest columns from other tables.
Tunnel creation and editing can now select files from the .ssh folder when it’s hidden by the OS.
1.2.8
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.
1.2.7
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.
1.2.6
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.
1.2.5
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.
1.2.4
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.
1.2.3
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.
1.2.2
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.
1.2.1
Changed
Published to the Open VSIX marketplace.
Fixed
Authentication was not working in the Cursor version of VS Code.
1.2.0
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.
1.1.6
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.
1.1.5
Changed
Added schema aware AI code completions for the SQL language, using GitHub Copilot if available or llama-3.1.
1.1.3
Fixed
MySQL and MariaDB no longer require root user privileges to connect.
