1.10.4

Changed

  • Notebook: Cells can be now be locked to specific connections, different to the other cells in the noteboook. #308
  • DB Picker: Added path details, back button, made sticky while loading.

Fixed

  • Notebook: Failed to render in some cases.

1.10.3

Fixed

  • Relationships: Browsing across relationships now work correctly with binary foreign key fields.
  • SQL: Added more keywords to the escape list for identifiers. #385
  • Results: Insert file on binary field only shows when editing the cell.
  • Postgres: Performance regression with large number of schemas. #378

1.10.2

Fixed

  • Reduced bundle size, increased loading performance slightly.
  • Postgres: Regression on data type handling. #396 #397
  • package.json: Updated configuration schema. #395

1.10.0

Changed

  • Greenplum: Added support for Greenplum. #392
  • Postgres: Moved to new introspection model, improves performance, added support for table partitions and row level security. #278 #165 #378
  • Postgres: Support versions 9.2 and above.

Fixed

  • Inline completion: Fixed cross database not suggesting columns in select again. #157
  • MongoDB: Was not working with the advanced filter.
  • MongoDB: Fixed mixed datatype. #393

1.9.5

Changed

  • Added toolbar icon to open current SQL in the editor (including applied filters/sorting).
  • Added separators to the toolbar for better visual separation.

Fixed

  • Advanced Filter: Use equals and not equals symbols, rather than words.
  • Editor: Insert statement parameters are now highlighted if the cursor is in a value. #352
  • Autocomplete: Was not working with escaped identifiers in dot notation. #391
  • .vscode folder: Wont be created unless connections are stored in the workspace. #391

1.9.4

Changed

  • Advanced Filter: Tables now have an advanced filter icon in the toolbar, which exposes a SQL “like” interface for filtering.
  • Column Filters: now support multiple conditions.
  • Column Filters: now supports is blank/null. #388
  • Column Filters: now has specific apply/reset buttons.

Fixed

  • SQL: Escape all SQL identifiers to cover any keywords, rather than just non alpha strings. #385
  • Azure: Store the last successful tenant ID with the connection. #327
  • Azure: Fixed token expiry issues. #324
  • Supabase: Fixed cloud provider to use session pooler rather than direct connection. #386

1.9.3

Fixed

  • SQL Server: Table creation/editing was not picking up length on fields with max value support. #377
  • Zero Config: When a sqlite connection was configured in .env and in the root folder it errored. #380
  • Postgres: Prepend the schema to the search path, rather than replace it. #384

1.9.2

Changed

  • MCP: Added MCP Server. #374
  • Copilot: Added Copilot tools. #373

Fixed

  • Cloudflare: Added support for using Account API Tokens.
  • Copilot Chat: Removed disambiguation. #373
  • Copilot inline chat: Fixed copy prompting to provide schema, disabled it from asking multiple times. #373

1.9.1

Fixed

  • Cloudflare: Added support for using Account API Tokens.

1.9.0

Changed

  • Connections: Added more color options. #245
  • Connections: Added read only option to connections where supported by the driver. #183
  • Connections: Added role option to enable permissions for statement execution. #183
  • SingleStore: Added support for SingleStore. #369
  • Settings: New settings to configure connection role permissions.
  • Settings: Removed warn before pre apply on procedure editing (replaced with role support).
  • CSV: Now supports specifying the delimiter, quote, escape characters and header row. #367

1.8.4

Changed

  • Import: First release, functions, some rough UX/UI edges. #53

1.8.3

Changed

  • Setting: Result font size. #356
  • Keybindings: cmd+enter and windows+enter for pc are now the command bindings for executing a sql statement in the editor, or applying changes to objects like triggers, procs, etc. #304
  • Excel and CSV Support: Warning about DML statements (update, insert, delete) not being applied to the file system for now.

Fixed

  • Editor: Insert statement values were not being highlighted correctly when in parenthesis. #352
  • Keybindings: The keybindings for executing a sql statement in the editor, or applying changes to objects like triggers, procs, etc.
  • Keybindings: The ctrl+d keybinding was breaking the terminal ctrl+d keybinding.
  • Zero Config: Don’t discover file formats (Excel, CSV, etc) on the initial load. #359

1.8.2

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

1.8.1

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

1.8.0

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