Changelog

Fixed

• Autocomplete ignores case when matching tables and views. #51
• History filter now works correctly in flat view.
• History from cloud providers now shows the correct name of the connection and provider in the history.
• History is limited to 5 records per database in core edition.
• SQLite now works on code-server and other non electron based environments.

Changed

• Added a Create Table, Alter Table, Rename Table, Truncate Table and Drop Table commands to the DB Explorer (Create/Alter are just preview for now, changes wont be saved!).
• Notebooks now use the extension .dbcnb rather than .dbcode.
• Identity/Autoincrement columns now show that in the default value in the DB Explorer.
• Data editing now supports enum fields with a dropdown list of the values.
• Execute keyboard shortcut changed to Ctrl/Cmd+Enter.
• DB Explorer now has a filter to search for for strings on connected databases. #42

Fixed

• SQL Server and Azure now show comments for tables, views and columns
• Fixed Postgres tables with ” in the name not being recognized as editable in the table.
• Autocomplete now suggests views where appropriate.
• Autocomplete now suggests schemas where appropriate.

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

• 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

• 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

• 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

• 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.

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.

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

• 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

• 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.

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.

Fixed

• Updated Microsoft Authentication to use common tenant.