Changelog

Changed

• ClickHouse: Preview support released. #111

Fixed

• Zero Config: Handle drive paths on windows correctly. #408
• SQL Server: Detect unicode characters before N quoting. #409
• DB Explorer: Don’t fetch databases if we already have them on another connection. #405
• Timescale: Filtered out internal timescale schema. #378
• Postgres: Improved types discovered on introspection. #378

Fixed

• Postgres: Inherited tables now show in the table list. #406
• Postgres: Databases sizes are now fetched in the background. #405
• Postgres: Improved introspection speed on foreign keys. #378
• Trae: Fixed loading in TRAE VSCode fork. #404
• Results: Fixed theme color mapping in the inspector. #341
• Notebooks: Failed to save outputs when results still executing. #381

Changed

• Results: Added an Inspector to the right hand tools. #341
• Results: Removed Filters from the right hand tools.
• Results: Filter or exclude selected values via context menu. #401
• Setting: Result Location. Control where results are shown (panel, beside editor, below). #77

Fixed

• Azure: Insufficient permissions to system views/columns. #361

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.

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

Fixed

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

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

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

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

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

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

Fixed

• Cloudflare: Added support for using Account API Tokens.

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

Changed

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

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