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.

Fixed

• Numeric data types were not being correctly displayed in the grid, preventing charting and other features.
• Refresh and Edit features now work correctly in Notebooks.
• Tables and views in the DB Explorer now show in alphabetical order for MySQL/MariaDB.

Changed

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

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.