Changelog

Changed

• Editor: If the cursor is in a insert statement column, the corresponding value will be highlighted. #352
• SQLite/D1/LibSQL: Moved to new introspection model, added triggers support. #355
• Results: Open in editor icon only shows when editing a cell, option to open editor added to the context menu when right clicking on a cell. #357

Fixed

• Hover: Bug in JSON to MD library. #350
• DuckDB: Added struct and map types. #351
• MariaDB: If MySQL is selected but database is Maria, will switch to MariaDB silently. #354
• Inline completion: Fixed cross database not suggesting columns in select. #157

Changed

• Excel and CSV Support: Support for opening .xlsx and .csv files as databases to query (preview). #263

Fixed

• SQLite: Fixed SQL generation when only an offset was used, without a limit. #335
• Redis: Username defaults to default as the default.
• HTTP: Added support for the vscode proxy setting to network requests, as well as the https_proxy enviroment variable. #326

Changed

• Inline Completion: Will now suggest databases when appropriate, and supports dotted notation for databases, eg database.schema.table. #157
• When VSCode is restarted only connections for any open files will be re created. #328
• Explorer: Support multiple selections for truncating and dropping tables.. be careful! #344
• Explorer: Added refresh to the database context menu. #343
• Explorer: Added option to copy item name to the clipboard.
• StarRocks: Added support for StarRocks. #340
• Doris: Added support for Apache Doris. #199 #267
• Setting: Added setting for pagination size to control rows per page (auto or 10, 20, 50, 100, 200, 500). #342

Fixed

• SQL Server: Added system views to introspection. #336
• DuckDB: Fixed array fields reporting unknown type. #346

Changed

• Hover: Layout has changed, now includes a icon to open the item where applicable (eg, table, view, materialized view, procedure, function).

Fixed

• Hover: Now works with dotted and escaped identifiers. #333
• Hover: Now works with materialized views.
• Go to Definition: Works with dotted and escaped identifiers. #333

Changed

• Added a go to definition link on tables, views and materialized Views (ctrl/cmd + click or f12 when hovering a table, view or materialized view in a query). #333
• Connections: Added common default socket paths, and changed it to a text input since VS Code prevents selecting locked files.

Fixed

• Editing a value to the default did not correctly save the change. #331 #299
• Postgres: Adding vector datatype. #330
• Chart: Tooltips were not showing on the chart, right clicking caused the chart to disappear. #30

Changed

• Entity Relationship Diagrams will now only show the filtered tables if a filter is applied in the explorer. #322

Fixed

• SQL Server: Fix introspection issue on servers with case sensitive collation. #318
• Export: SQL Insert statements now include the schema if applicable. #321
• MySQL/MariaDB: Fixed issue with editing triggers.
• MySQL/MariaDB: Fixed issue with socket connections.
• Postgres: Fixed issue with current_schema returning a schema that does not exist.

Changed

• Redis: Preview support for Redis, browsing works, not much else at the moment. #39
• Added item to the header context menu of results to clear one or all column filters. #315

Fixed

• UUID icon rendering issue when it was a primary key in the ERD.
• A single column will start no wider than 1/3 rendering space for the results. #314
• Disconnecting a connection was not correctly showing it disconnected in the explorer. #222

Fixed

• MariaDB: Added support for 10.0 #306
• MongoDB: Sorted collections and views in the schema, fixed queries that return single values. #276

Fixed

• AI: Added comment to the context provided to the AI model.
• Query Parameters: No longer trigger for % unless followed by ( or { #309
• SQL Server: Fixed issue with default cschema returning null. #291

Fixed

• MySQL/MariaDB: Added binary data type. #305
• Added debug command to output additional debugging.
• MongoDB: Improved connection performance, filtering, data type detection. #276

Fixed

• Prevent saving a connection in a workspace, when one is not open. #301
• MongoDB: Fixed issue with refreshing the results.

Fixed

• Cassandra: Added tunnel option to the config.
• Changed to a filestore for introspection cache, and mapped formats to a version. #291
• SQL Server: Show if a database is offline. #296

Fixed

• DuckDB: Date filters in results not working correctly. #290
• Notebooks: Copied cells broke the notebook render. #293

Changed

• Added auto refresh option to results.
• Added option to script data changes, rather than applying them.

Fixed

• MSSQL: Fixed issue with introspection when user only had read only access. #280
• Notebook: Prevent keyboard events from propagating to the notebook. #281

Fixed

• MSSQL: Fixed issue with introspection when user only had read only access. #280
• DuckDB: Added support for enums.
• Notebook: Prevent keyboard events from propagating to the notebook. #281