Changelog

Fixed

• Icon added for Notebooks.
• SQLite/libSQL now shows row counts for tables in the explorer.

Changed

• @dbcode has been added as a chat participant if you have the Github Copilot extension installed.
• You can right-click on a supported database file (.db) and choose to open it in DBCode.
• Autocomplete now works in notebook cells.

Fixed

• The data grid now uses the editor font for cell values.
• Data grid column widths are now limited to prevent excessive length when the table has many columns.
• Data grid charts now correctly display numeric values for series data.

Changed

• Added support for removing a group of connections from the explorer, as well as removing a single connection from a group in the explorer.
• Switched to a universal build. Binary packages will be downloaded as needed instead of being included in the extension.
• Added cloud providers to the connection picker.

Fixed

• Postgres databases in some cases were not displaying results.

Changed

• Updated SQLite driver.
• Results can now render hundreds of megabytes of data.

Fixed

• MySQL/MariaDB connections were not using the connection timeout setting.
• MySQL/MariaDB connections would not show the correct error message when the connection failed.
• MySQL/MariaDB connections show better SQL errors.

Changed

• Added Azure cloud provider, supports Azure SQL, Azure Postgres and Azure MySQL via Microsoft Entra ID authentication.
• Added support for Microsoft Entra authentication to Azure SQL connections.

Changed

• Added support for MySQL 5.7.
• Added a filter option to connections to filter schemas and databases in the explorer.

Changed

• Relationships: Browse foreign key relationships in data to view related data in other tables.
• Edit data and access relationships for your select queries.
• Aiven cloud provider added.

Fixed

• PostgreSQL showed duplicate columns in the foreign key when a foreign key had multiple columns.
• SQLite did not show columns in the explorer whose names matched the table name.

Fixed

• Codelens now indicates whether you are executing a selection or the entire document.
• libSQL now supports encrypted local files.

Changed

• Cloud providers support added. (more details)

Changed

• Added libSQL support (local file and Turso URL).

Fixed

• Changes to an open connection that affect the connection (e.g., host, port, username, etc) will now prompt you to close and reopen the connection.
• Color changes will be removed when the window loses focus and reapplied when the window regains focus to prevent them from appearing in other VS Code windows.

Changed

• Assign a color to a connection and specify which sections: the editor tab, status bar, and command center should display that color when active.

Fixed

• Codelens does not get hidden above the visible area.
• A race condition restoring previously open connections caused multiple connections to the same database to open.

Changed

• Open a table cells content in the VS Code editor.
• Connection tree view items are now cached for faster initial loading and refreshed in the background.
• The connection tree view will reopen previously expanded items on VS Code restart.
• Files assigned to a connection are now restored to that connection upon reopening VS Code.

Fixed

• Consistency with delete confirmations between connections, tunnels, history.

Fixed

• Fixed domain authentication bug in SQL Server, new option to be specific about authentication type added to connection.
• Fixed PostgreSQL not using right port when first adding a connection.

Changed

• Added an option to import from a connection string when adding or editing connections.
• Added zero-config functionality to automatically detect connections in .env and web.config files. (more details)
• Added compass (discovered) icons to the tunnels and connections that are automatically discovered.

Fixed

• Fixed an issue where SQLite connections would not store the file path when edited in some cases.
• PostgreSQL is the default connection type when adding a new connection.

Fixed

• Updated Microsoft Authentication to use common tenant.