DBCode

# CHANGELOG ## 1.17.6 - 2025-09-30 ### Changed - Results: Added data lookup formatters (lookup a value from another table based on the current column value). - Clickhouse: Removed from preview. #111 ### Fixed - MySQL/MariaDB: Fixed DATETIME columns being incorrectly timezone-shifted when displayed in Locale format. #85 - MySQL/MariaDB: Added charset and collation connection settings to configure character encoding. #227 - Results: Fixed Locale date format displaying incorrect datetime values when timezone conversion was applied. - Inspector: Map view now renders PostGIS geometry columns delivered as EWKB hex. #738 ## 1.17.4 - 2025-09-28 ### Changed - Editor: Added Copy Query command and default shortcut to copy the active SQL statement without executing it. #732 - SQL Export: Multi-row INSERT statements now emit as a single batch when the target dialect supports it, while Oracle and other single-row engines still receive individual statements. - Clickhouse: Added connection option to set driver settings. - SQLite: Updated better-sqlite3-multiple-ciphers to 12.4.1 (SQLite - 3.50.4). #727 ### Fixed - Results Grid: Filter dropdown menus stay open when activated after keyboard shortcut updates. ## 1.17.3 - 2025-09-24 ### Changed - Connections: Post-connection SQL execution option added to connection config (requires Pro/Team). #729 ### Fixed - Redshift: Could not open additional connections while introspection was running. ## 1.17.2 - 2025-09-22 ### Changed - Connections: Added Copy Connection String to context menu of connections. #550 - Connections: Support variable substitution in SSL/TLS certificate paths. #728 - Redshift: Introspection now surfaces distribution/sort keys. ### Fixed - Results Grid: Ensure keyboard shortcuts work even when focus is on the toolbar or empty grid space. ## 1.17.0 - 2025-09-19 ### Changed - Athena: Added initial support for Athena. #279 - Trino: Added view support, as well as execution metadata. #279 - Execution Plans: Modified plan format to be more driver based, added support for all existing databases that can produce plans. #376 ### Fixed - Results Grid: Inline edits now close when you click empty grid space, including Monaco-backed editors. ## 1.16.15 - 2025-09-18 ### Changed - Editor: Go to definition (cmd/ctrl+click) on tables, views, procedures, functions, etc now opens the alter intent. - Editor: Right click on tables, views, etc to select open and open with limit options. - Firebase: Fixed date handling, removed from preview. ### Fixed - Scripting: restored explicit column expansion for the `SELECT` script option. #726 - Roles: classify CALL/EXEC statements as EXECUTE rather than unknown. #725 ## 1.16.14 - 2025-09-15 ### Changed - View Editing: View editing is now supported for databases that support it. - Inspector: the inspector panel now has a map icon, which will render geo data on a map. #566 ### Fixed - Results: Date filters were not loading with fully loaded data. #721 - History: Fixed issue where truncated SQL was being used when loading or copying queries from the tree view instead of full SQL. #720 - LibSQL: Not correctly detecting libc on linux systems causing failure to download the native bindings. #718 - Chat: Fixed issue where where VSCode was trying to infer the default connection, and it was not set. #656 ## 1.16.13 - 2025-09-12 ### Changed - Execution Plans: Added DuckDB and BigQuery support. - Execution Plans: Added config option to aggregate grouped column values. ### Fixed - History: Fixed crash with large history files (300MB+) by removing dedicated search index. #715 ## 1.16.12 - 2025-09-10 ### Changed - Script Generation: Added advanced DML script options - MERGE, INSERT ON CONFLICT (UPSERT), UPDATE FROM, and DELETE USING. #349 - Script Generation: Improved SQL formatting with clauses on separate lines for better readability - Execution Plans: Improved charts. #376 - Execution Plans: Added Clickhouse, libSQL, Snowflake support - Execution Plans: Added icons for explain, analyze to the editor title menu section when supported. - Keyboard Shortcut: Changed shortcut to shift+ctrl+cmd/windows+o to choose database (or connection) when in a SQL file. #690 ### Fixed - BigQuery: Fixed introspection error for dataset names containing hyphens. #701 - Script Generation: Fixed issue where identity/auto-increment columns were incorrectly included in INSERT statements. #349 - Script Generation: Fixed issue where default value functions like CURRENT_TIMESTAMP were being incorrectly quoted. #349 ## 1.16.11 - 2025-09-10 ### Changed - Connection Groups: Added custom sorting via drag & drop. Groups can now be reordered by dragging them to new positions. #707 - History: Added search, added table open. - History: Added [multi-device sync](https://dbcode.io/docs/query/history-sync). #709 - History: Converted storage format to binary crdt format. ### Fixed - Results Grid: Cell editor now closes when clicking outside of it, and can be closed with Ctrl/Cmd+Enter. #107 ## 1.16.8 - 2025-09-04 ### Changed - Execution Plans: Initial basic chart support added. #376 - Results Grid: Database selector now automatically syncs with the active editor's connection. #708 ### Fixed - Execution Plans: Added basic support for MySQL plans. #376. - Editor: Right click execute with DBCode was throwing an error. #705 ## 1.16.7 - 2025-09-03 ### Changed - Code Completion: Experimental LS is now complete for Postgres and MariaDB dialects. - Exports/Share: Web page format now supports a title, date and optional SQL inclusion, along with updated rendering style. - Execution Plans: Export and Share support added. #376 - Execution Plans: Preliminary support for Oracle added, more stats from SQL Server. #376 ### Fixed - Oracle: Fixed environment switching issue where service names were propagating between connections and environments were not properly isolated. #703 - Results Grid: Fixed text jumping issue when hovering over cells with relationship icons. #695 - SQL Server: Fixed inconsistent decimal formatting. #689 ## 1.16.6 - 2025-09-01 ### Changed - Execution Plans: Initial preview of execution plan support has been added. #376. - Connection Pinning: Added Oracle, DB2, ClickHouse, and Snowflake (with SSO token caching) support for connection pinning to maintain session state across query executions. #663 - BigQuery: Use table list api when opening a table (only possible when no sorting or filtering applied). #693 - BigQuery: Added support for dry run query execution. #693 - BigQuery: Always show bytes billed, even if 0. #693 - BigQuery: Added BI Engine information to the meta data display when present. #693 ## 1.16.5 - 2025-08-29 ### Changed - Keyboard Shortcut: shift+cmd/ctrl+d shift+cmd/ctrl+b will open up selector to choose database (or connection) when in a SQL file. #690 - Connection Pinning: Added MariaDB, and MySQL to pin a connection to the editor. #663 - Connection Settings: Added [variable substitution](https://dbcode.io/docs/connections/variables) support for file paths in connection configurations. Supports `${workspaceFolder}`, `${workspaceRoot}`, `${home}`, `${env:VARIABLE_NAME}`, and relative paths. #683 - USE Command: Will update displayed database when database supports USE command and connection pinning. - Bigquery: Added Bytes billed metadata. #693 ## 1.16.4 - 2025-08-25 ### Changed - Results: Added keyboard shortcuts to the tooltips. ### Fixed - SQLite: Fixed issue where primary keys were not detected when not present in PRAGMA_index_list. - Cassandra: Fixed SSL certificate validation errors. #640 - Oracle: Fixed crash when using Instant Client after initialization. #674 ## 1.16.3 - 2025-08-24 ### Changed - Firebase: Added support for editing sub collections. - Firebase: Added support for multiple Firestore databases. - Code Completion: Experimental LS now provides table/column context and CTE understanding. ### Fixed - Trino: Fixed map, array, and row types displaying as "[object Object]" in query results. #670 ## 1.16.2 - 2025-08-22 ### Changed - Firebase: Handles setting (undefined) for a value to make the key undefined. - MongoDB: Handles setting (undefined) for a value to make the key undefined. ### Fixed - Added groups to escaped identifier list. ## 1.16.1 - 2025-08-20 ### Changed - Result: Editor now auto formats and focuses when opened, as well as auto detecting language. - Firebase: Will destructure data into keys where possible allowing specific key editing. - Code Completion: Will use new experimental language server if enabled. ### Fixed - SQL Server: Fixed BIT columns incorrectly exported as 'true'/'false' instead of 1/0 in SQL Insert statements. #658 ## 1.16.0 - 2025-08-19 ### Changed - Firebase: Added initial preview support for Firestore and Realtime (editing not supported yet, might be some bugs.) #295 - Syntax validation: Fixed semantic validation not working, enhanced grammar support, added fallback ANSI grammar. ## 1.15.0 - 2025-08-17 ### Changed - Parquet: Added support for parquet files. #177 - Avro: Added support for Avro files. - Redis: Added editing support (update, delete, insert), as well as editor logic for hash/sets. #39 - CSV and Excel: Underlying files will be watched for changes, and re-load the data if the underlying file changes. ### Fixed - Tunnels: Will now better handle reconnecting, and if it fails, will close connections that were using them to avoid connections attempting to use closed tunnels. - Notebooks: Fixed issue with canceling and connection pinning. #663 ## 1.14.30 - 2025-08-14 ### Changed - Syntax validation: Experimental support for SQL syntax validation added (Postgres and Maria/MySQL initially). ### Fixed - Postgres: Would not format data types correctly on initial table load in some cases. #107 - Excel: Was not filtering reserved words in sheet names. #659 ## 1.14.29 - 2025-08-08 ### Changed - Results: VSCode editor now used in JSON/XML datatypes, and can be opened on any field using the open in editor icon (replaces old open in editor). #107 - Connection Pinning: Will now destroy a connection if keep alive statement fails. #578 #648 ### Fixed - Trino: Uses line numbers in errors to reduce highlighting when present. - Export: Fixed issue with SQL Insert statement export. #655 - Inspector: Show correct data types in the JSON view. - Inspector: Added proper editor to JSON and XML data types. #107 ## 1.14.28 - 2025-08-07 ### Changed - Results: Support for data [formatting](https://dbcode.io/docs/data/formatters) completed. - Inspector: Updated to use VSCode editor. ### Fixed - DB2: Fixed issue with SSL connections. #652 ## 1.14.26 - 2025-08-06 ### Changed - Results: Added support for data [formatting](https://dbcode.io/docs/data/formatters) (work in progress). - Results: Selecting a full row and pressing delete/backspace will now delete the row, rather than clear the contents (cmd/ctrl+delete/backspace will delete partially selected row). ### Fixed - Dragging a table to a new window did not load the data. - Greenplum: Fixed introspection issue. #651 - Doris: Fixed introspection issue. #645 - Results: Fixed issue with sorting other columns, when primary key sorting setting was enabled. ## 1.14.25 - 2025-08-02 ### Fixed - Autocomplete: Fixed issue where it was not working for some databases. #643 - Redshift: Removed JSON method from introspection. #644 ## 1.14.24 - 2025-08-01 ### Changed - Connection Pinning: Added support in notebooks, and for Postgres. #578 - Redshift: Added support for external tables (Spectrum). #613 ### Fixed - Postgres: Introspection does not get columns for partitioned tables (redundant). - Postgres: Don't change schemas for non user based SQL execution. #507 - Oracle: Fixed syntax error being displayed rather than driver error in certain cases. ## 1.14.23 - 2025-07-30 ### Changed - Export/Share: Added support for tab delimiters in CSV export. ### Fixed - Improved introspection performance for large schemas (1000+ schemas) ## 1.14.22 - 2025-07-28 ### Fixed - Explorer mapping columns to incorrect tables in some cases. #628 - IBM DB2: Added latest bindings. #636 - MySQL/MariaDB: Filtering for year was using date rather than number. #633 - Postgres: Updated to support AWS Aurora DSQL. #637 - Parameters: The data type dropdown was not always visible. ## 1.14.21 - 2025-07-24 ### Changed - Data: Transpose mode finalized. #554 ### Fixed - Oracle: executing of begin.. end; blocks fixed. #619 ## 1.14.20 - 2025-07-21 ### Fixed - Notebooks: Restore cell height and chart width saved with output. #623 - SQL Parsing: Better handling of begin.. end; blocks. #619 - Supabase: Fixed issue when projects did not use branches. #624 ## 1.14.19 - 2025-07-18 ### Changed - Data: Transpose mode improved, cmd/ctrl+t to toggle transpose mode, undo still needs work when switching modes. #554 ## 1.14.18 - 2025-07-17 ### Changed - Data: Transpose mode improved, some issues with switching modes with pending edits still to be resolved. #554 - Inspector: Added form view with editing support, search and copy feature, and support for transposed results. - Results: Simplified selection UX, allowing for duplicating partial rows. - SQLite: Added support for an idle timeout. #615 ### Fixed - Added index as an escaped identifier. #620 - Results: Reduced row heights when a smaller font size is used. ## 1.14.17 - 2025-07-14 ### Changed - Data: Transpose icon added to allow transposing the data in the results grid (in preview, still working on it). #554 - SQL Server/Azure: System tables are now grouped into their own System Tables section in the explorer if present. ### Fixed - Autocomplete: Aliased tables across databases which did not support schemas were not being handled correctly. - Connection Pinning: Added keep alive for SQL Server. #611 ## 1.14.16 - 2025-07-10 ### Changed - ERD: Now part of the core features. - Notebook Export: Now part of the core features. - Export/Share: Last used theme is now remembered. ### Fixed - MCP: Autostart was prompting to sign in/activate, even when already signed in. #610 - Results: Refreshing table data with schema changes was not reflecting updated schema (eg new columns not being shown). - Notebook Export: Fixed issue with formatting of tables. ## 1.14.15 - 2025-07-03 ### Changed - ERD: Added option to change the connecting line style, and remember the choice. - API: Updated connections will run change detection and re connect if details like port, password, etc change. #568 ### Fixed - Postgres: Fixed issue with introspection not getting default values. - Postgres: Fixed issue with introspection not getting foreign key columns. - Yugabyte: Fixed introspection issue. #591 - Editor: Fixed parsing create package statements. ## 1.14.14 - 2025-06-29 ### Changed - Export: Remember CSV settings for the next export. #599 - ERD: Will remember the position of tables if they are re arranged. ### Fixed - MCP: Autostart was not always working. - ERD: Improved cardinality display. ## 1.14.13 - 2025-06-24 ### Changed - Editor: Connections are now pinned to the editor for re use. Supporting temp tables, and other temporary objects/commands. (SQL Server only to start with). #578 - SQLite: Added memory option for creating a memory only database. #595 ### Fixed - Offline license display in the account section now, including ability to remove the license. - Using an offline license is only possible now when not being signed into an account. ## 1.14.12 - 2025-06-23 ### Changed - Setting: Added a setting (useExecuteCodeLens) to control if the execute code lens is shown in the editor. #358 #586 - DuckDB: Updated driver to 1.3.1. #592 - ERD: Any open diagrams will automatically update on changes to related schema/database. #383 - ERD: Hovering over a table will show its relationships. - ERD: Added option to filter the columns displayed in the diagram to only show key columns or just table names. ### Fixed - DBCode icon was not showing if the panel display was set to show icons only. - StarRocks: Fixed issue with introspection. #585 - SQLite: Fixed sqlean extension not being loaded correctly on windows. #593 - Results: Improved web page export, added maximize button. ## 1.14.11 - 2025-06-18 ### Changed - ERD: Supports keyword search, clicking a table to highlight relations, cardinality shown on connections, (sharing a work in progress). #329 - Connection Import: You can now import connections from Azure Data Studio, pgAdmin or CSV files. #494 - Autocomplete: Will now offer join syntax when adding joins. #204 - API: Added an API for other extensions to use. #568 - Export: Added option to suppress quotes in csv export. #589 ### Fixed - Bigquery: Not filtering columns in the explorer for external tables. #580 - Notebook: Fix export not rendering charts. #206 - Parser/Autocomplete: Improved more syntax understanding. - MCP: Added required to parameter descriptions where appropriate. #581 - Postgres: Fixed datatype issue.. #514 #491 ## 1.14.10 - 2025-06-13 ### Changed - Notebook: Export now supports file uploads for images, videos etc, as well as compressing document content. ## 1.14.9 - 2025-06-13 ### Changed - Notebook: Export completed. #206 - Sharing: Support for custom S3 compatible bucket/custom domain name. #207 - Export / Sharing: Web Page option added allowing to export functional results grid. ## 1.14.7 - 2025-06-11 ### Changed - Notebook: Export UI improved, preview of HTML export in palce, results and charts not hydrated yet. #206 - Results: Re worked the share panel to include export, and allow custom delimiter for CSV. #547 - DuckDB: Updated driver to 1.30. #573 - Oracle: Capturing dbms_output.put_line statements to output tab. #574 ### Fixed - Parameters: Incorrectly picking up parameters in some quoted strings. #575 ## 1.14.6 - 2025-06-09 ### Changed - Setting: Wrap Cell Text: Control if cell text should be wrapped by default. #565 - Results: Right click a column heading to select to wrap/unwrap text. #565 ### Fixed - Trino: Used jdbc schema where possible. #571 - MCP Server: Made query string auth more reliable in Cursor. #567 - SQLite: Fixed explain plan execution. #570 - Oracle: Introspection error. #543 - Notebook Export: Fixed PDF formatting for tables and code blocks, enabled PDF encryption. #206 ## 1.14.5 - 2025-06-06 ### Changed - Results: Added option to count all rows when red row count is shown. #509 - SQLite: Added sqlite-js and sqlean extensions. - Editor: If you use the keyboard shortcut, or execute icon without the cursor in an active statement, you will be prompted to confirm executing the whole document. ## 1.14.1 - 2025-06-05 ### Changed - Import: Auto match columns based on name. #555 ### Fixed - SQL Server: Windows Authentication was broken after version 1.13.17. #563 ## 1.14.0 - 2025-06-04 ### Changed - Azure Synapse: Added support for Synapse. #544 - Explorer: Added right click options to create, drop and rename schemas where applicable. - Colors: Added dbcode.activeStatementBackground and dbcode.activeStatementBackground. #542 ### Fixed - Postgres: Re worked detection of support for using internal PG functions in introspection. #548 - Clickhouse: Decode map data types #562 ## 1.13.18 - 2025-06-03 ### Changed - Query Parameters: Support reuse of parameters.. eg &actorId||1||number can be re used in the same query as just &actorId ### Fixed - Postgres: Introspection was failing on 9.3 #551 - SQL Server: Support Microsoft Fabric SQL Servers. #382 - Query Parameters: Fixed dates with time in them. - Results: Removed contains and other non support filter types on UUID columns. ## 1.13.17 - 2025-05-27 ### Fixed - Clickhouse: Re working this to pick up the standard ones as a fallback. #538 - SQL Server: Introspection performance improvements. #425 - SQL: Various engines need backslash \ escaped in string literals. #540 ## 1.13.16 - 2025-05-27 ### Fixed - Supabase: Was not correctly switching projects for db account creation. #536 - Clickhouse: Catch a few more non standard SQL statements that need to run through the command path. #538 - Redis: Show empty keyspace is none are found. #535 ## 1.13.14 - 2025-05-24 ### Fixed - Postgres: Was not handling search path's with escape characters "\$user". #537 - Notebooks: Export was incorrectly ordering code blocks. #206 - Notebooks: Not always restoring output in some cases when output was saved with the notebook. ## 1.13.13 - 2025-05-22 ### Changed - Accounts: Added support for offline/air gapped licenses [More](https://dbcode.io/docs/accounts/offline-license). #486 ### Fixed - BigQuery: Was not handling structs (the driver internally calls them record's as it turns out). #533 ## 1.13.12 - 2025-05-21 ### Fixed - Oracle: Introspection was hanging on some versions. #160 - Snowflake: Fixed issue with manual authentication. - Redshift: Fixed issue moving across schemas. #493 - Notebook: Export code blocks now style correctly. #206 ## 1.13.11 - 2025-05-20 ### Changed - Notebook: Export now supports PDF. #206 ### Fixed - SQL: Added from as a reserved word. #531 - Postgres: Fixed compatibility with 9.2 #530 ## 1.13.10 - 2025-05-19 ### Changed - Snowflake: Added support for security role in the connection. #271 ### Fixed - Stored Procedures: Were not editable. #525 - Clickhouse: Support for passing format null to ignore results, fixing more statements with non standard result returns. #526 - Definition Provider: Handle database.schema notation, also handle quoted identifiers. #528 - Redis: Fixed opening All Keys. #522 ## 1.13.9 - 2025-05-19 ### Fixed - Excel: Will now ignore type conversion errors, and make cell null #521 - Postgres: Don't use information_schema to get tables/views, it was filtering out tables the user did not have permissions for. #512 ## 1.13.8 - 2025-05-18 ### Changed - Notebook: Export feature has been added in preview, cannot save pdf/publish yet, chart rendering is still a work in progress. #206 - Favorites: Add items from the DB Explorer, files and text to save items as favorites in the current workspace. ### Fixed - Clickhouse: Delete and insert queries were failing. #518 - Cloud providers: Fixed issue with expanding some providers. #517 ## 1.13.5 - 2025-05-15 ### Changed - SQL Server: Included support for SQL Server 2012 and above. #487 ### Fixed - Oracle: 12.1 support fixed, also fixed an error with primary key mapping. #160, #505 #499 - Output tab: Was too big in notebook output. #513 ## 1.13.3 - 2025-05-15 ### Changed - DB Explorer: Is now decoupled from connections, should be faster, and be more explicit about when connections are connecting/refreshing. ### Fixed - SQLite: Better detection of when to use raw method. #511 - Results: Inserts cross schema were not reflecting the correct schema. #510 ## 1.13.2 - 2025-05-13 ### Changed - New schema storage model. - Clickhouse: Now has a request timeout setting in the configuration. #508 ### Fixed - Oracle: Changed compatibility to 12.1.0 - Explorer in some cases could miss map columns to a table. ## 1.13.1 - 2025-05-13 ### Changed - Cassandra: Moved to new introspection model. - Mongo: Moved to new introspection model. - Files associated to connections will be remembered per workspace. #412 - Removed the @dbcode Chat Participant in favor of copilot tools and providing context. - Setting: Workspace Connection: You can set a workspaces default connection, it will be stored in settings and used in quick open, and Copilot Tools. #237 - Copilot/MCP: Added a tool that will get the default connection that if configured for a workspace. ### Fixed - Oracle: Getting support for 12c sorted. #160 - Right click opening files in windows was incorrectly setting file path. ## 1.13.0 - 2025-05-11 ### Changed - Trino: Preview support added. #172 - DuckDB: Supports using a memory only database. #501 ### Fixed - Definition on hover will match schemas regardless of case. #488 - Clickhouse: Datatypes are better supported. #462 #463 - Create Database: Was not working in the context menu. ## 1.12.7 - 2025-05-09 ### Changed - Oracle: Moved to new introspection model. ### Fixed - Oracle: Fixed byte sequence error. #477 #456 - Oracle: Use version rather than version_full. #160 - Fixed: Sample database no longer includes extension version in the path. #498 ## 1.12.6 - 2025-05-09 ### Changed - Tab Reuse: Changed to follow VSCode enabled limit and limit value, will recycle only if limit editable and tab limit reached. - Output tab: Shows the execution history and output statements for Databases that support them (SQL Server, Postgres). - Allow air gapped computers to provide required packages manually. #486 ### Fixed - Clickhouse: Support describe statements ## 1.12.5 - 2025-05-07 ### Changed - Accounts: Added a refresh to the account section to refresh information and not require a logout/in. ### Fixed - Autocomplete: Fixed issue with alias not always being matched. #484 - CockroachDB: Error with cluster id caused by SSL configuration in #445 - Tab Reuse: if workbench.list.openMode is set to doubleClick tabs wont be re used, since no way to track the double click, and without it only one tab can be opened. ## 1.12.4 - 2025-05-05 ### Fixed - Postgres: Was not handling infinity/-infinity dates. #482 - Quick Script: Was not setting connection on the new file. #349 - Open new file: Was not working when executed from the command pallet instead of the tree. #483 ## 1.12.3 - 2025-05-02 ### Changed - SSL: Configurations that are discovered now use the OS ssh command. #445 - Drop items from the explorer onto the tree to script them. #348 ## 1.12.2 - 2025-04-30 ### Changed - Quick Script: Select, Insert, Update, Delete scripts can be generated from the context menu of items like tables, views. #349 - Item Filter: Now supports SQL like and not like like filter values eg: not like pg_temp%. #461 ### Fixed - Postgres: Introspection bug. #416 ## 1.12.1 - 2025-04-29 ### Changed - External Tables: Now listed in their own section. #472 - Tunnels: Added host and port connection test. - DB2: Out of preview #82 ### Fixed - Connection Add/Edit: Disabled connection test if a tunnel was used. - Azure: Better support for Synapse databases. #471 ## 1.12.0 - 2025-04-26 ### Changed - Microsoft Dataverse (Power platform): Added support. #458 - RisingWave: Added Support. #465 ### Fixed - Snowflake: Handle an empty error. #448 - Azure: Better support for SQL Server variants that don't support system_columns. #460 ## 1.11.12 - 2025-04-24 ### Changed - Reuse tabs when opening tables and views. Follows VSCode reuse based on single or double click. #211 - Connection Add/Edit: Added DNS and Port connection test. ## 1.11.11 - 2025-04-24 ### Changed - Tunnels: Added support for ProxyCommand in ssh.config. #445 - Tunnels: Fixed auth methods. #257 ### Fixed - Snowflake: Handle an empty error. #448 ## 1.11.10 - 2025-04-23 ### Fixed - Race condition on first time initialization. #457 ## 1.11.9 - 2025-04-22 ### Fixed - Connection Add/Edit: Fixed responsive issues on small screens. #447 - Turso: Removed user_version statement. #446 - Escaped more SQL Keywords. #444 - FileStore: Added logging to filestore operations. #440 #425 - Clickhouse: Enabled request/response compression. #111 - Postgres: Handle switching to schemas that need escaping. #439 ## 1.11.8 - 2025-04-14 ### Changed - Setting: Wrap Tabs. Controls if tabs are wrapped or scrolled (default) when there are more than can be displayed. ### Fixed - Large Schema Performance: Much improved. #425 #378 - Table Editing: Don't quote the default value. #437 ## 1.11.6 - 2025-04-12 ### Fixed - Improved filter icon showing toggled state, and key column data type icons when toggling filter. - SQL statements not being added to the tabs. #418 - Improved simplified Chinese translation. #427 - Better handling of databases with no access for configured authentication. #421 - Snowflake: Fixed introspection issue. #422 ## 1.11.5 - 2025-04-11 ### Changed - Passwords: Expose the config key values as environment variables to the password command. #428 ### Fixed - Results: Adding rows would not work with null values. #430 ## 1.11.4 - 2025-04-09 ### Changed - SSH Tunnel: Prevent auto close if no active connections. ### Fixed - Results: Allow tabs to wrap. #418 - Results: Reduced size of quick search to allow more tab space, added visual tab separators. - Quick Open: Remembers last used connection, shows path, shows all items once inside a connection level and user starts typing. #237 - SQL Server: Updated databases to show when the user account does not have access. #421 - Snowflake: Fixed introspection issue. #422 ## 1.11.2 - 2025-04-09 ### Changed - Welcome Panel: Re designed. - Connection: Re designed the add and edit screens. - Tunnel: Re designed the add and edit screens. ### Fixed - Editor: Looses focus when executing statements. #420 ## 1.11.1 - 2025-04-07 ### Changed - Quick Open: Open tables, views, stored procs and other entities that can be clicked on in the explorer via the keyboard shortcut ctrl+windows+o (Mac: cltr+cmd+o). #237 - New Connection: Revised layout, added search feature. - DB Explorer: Added column names to the index description. - Results: Esc key will now close relationship sub results in reverse order to how they were opened. ### Fixed - Passwords: When generated by a command, the output is now trimmed to remove whitespace characters. #415 - SQL: Don't treat numbers with leading 0's as strings. #409 - Results: Fixed horizontal scrolling with the wheel when not full rows. ## 1.11.0 - 2025-04-04 ### 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 ## 1.10.7 - 2025-04-03 ### 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 ## 1.10.6 - 2025-04-02 ### 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 ## 1.10.4 - 2025-03-30 ### 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 - 2025-03-28 ### 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 - 2025-03-28 ### 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 - 2025-03-27 ### 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 - 2025-03-26 ### 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 - 2025-03-25 ### 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 - 2025-03-24 ### 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 - 2025-03-16 ### 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.0 - 2025-03-13 ### 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 - 2025-03-13 ### Changed - Import: First release, functions, some rough UX/UI edges. #53 ## 1.8.3 - 2025-03-11 ### 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 - 2025-03-09 ### 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 - 2025-03-06 ### 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 - 2025-03-05 ### 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 ## 1.7.4 - 2025-03-03 ### 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 ## 1.7.3 - 2025-02-28 ### 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 ## 1.7.1 - 2025-02-27 ### 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. ## 1.7.0 - 2025-02-24 ### 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 ## 1.6.22 - 2025-02-20 ### Fixed - MariaDB: Added support for 10.0 #306 - MongoDB: Sorted collections and views in the schema, fixed queries that return single values. #276 ## 1.6.21 - 2025-02-20 ### 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 ## 1.6.20 - 2025-02-18 ### Fixed - MySQL/MariaDB: Added binary data type. #305 - Added debug command to output additional debugging. - MongoDB: Improved connection performance, filtering, data type detection. #276 ## 1.6.19 - 2025-02-17 ### Fixed - Prevent saving a connection in a workspace, when one is not open. #301 - MongoDB: Fixed issue with refreshing the results. ## 1.6.18 - 2025-02-16 ### 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 ## 1.6.17 - 2025-02-14 ### Fixed - DuckDB: Date filters in results not working correctly. #290 - Notebooks: Copied cells broke the notebook render. #293 ## 1.6.16 - 2025-02-12 ### 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 ## 1.6.15 - 2025-02-11 ### 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 ## 1.6.14 - 2025-02-11 ### Changed - Improved refresh feature and tab naming for SQL statements, including better handling of multiple result sets. #197 - Notebooks: Query parameters values are now shared across cells, and persisted on save. #262 - DuckDB: File search path set to the folder of the database file, to enable relative paths in load commands. - DuckDB: Changed to new DuckDB supported driver, upgraded to new introspection model. ### Fixed - Cassandra: Added support for multiple statements in a single string. - MongoDB: Don't require a port when connecting via mongodb+srv:// #276 - MongoDB: A new script file will contain example commands and link to the quick reference. #276 - Notebooks: Scrolling is now captured when scrolling the results grid, within in a scrollable notebook. ## 1.6.13 - 2025-02-06 ### Changed - Setting: Notebook max tabs now controls the number of tabs per output cell in a notebook. #270 - Changing the max tabs setting to 0 will remove the output tabs from the ui. #270 - Tabs now shrink properly when there are more than can be displayed on the tab bar. #270 - Tab icon changes to pin on hover indicating tabs can be pinned. #270 ### Fixed - Postgres: Fixed issue with query parameters picking up Postgres replacement values. #262 ## 1.6.12 - 2025-02-05 ### Changed - Added support for executing a command to get the password for a connection. #269 ### Fixed - MySQL/MariaDB: Changed introspection to not use information_schema for procs. #273 #265 - Added more checks for connections with configuration issues (invalid drivers). #231 - Added a configuration option to debug tunnels. #257 - Notebooks: Fixed a bug with saving outputs when output id's started with a number. #272 ## 1.6.11 - 2025-02-05 ### Changed - Notebook tabs have been restored. #270 - File based drivers (SQLite, DuckDB, etc) now store the path as a relative path when the config is saved in a work space. #268 - File based drivers (SQLite, DuckDB, etc) can use ${workspaceFolder} in the path. #268 ## 1.6.10 - 2025-02-04 ### Changed - Query Parameters are now supported. #262 - Keybinding on Mac for executing a statement has been changed to ctrl+enter (was cmd+enter), consistent in both notebooks and editor now. ### Fixed - Error highlighting was not working with the active range. - Tables starting with an underscore where not editable when opened. - Cassandra tables would not load as it did not support Order By or Offset. - When using a row limited table, could not remove a second column filter. - When adding a row to a row limited table, you could not scroll/page to get more records without saving the pending row change. ## 1.6.9 - 2025-01-31 ### Changed - Notebooks: Saved output can now be restored. #44 ### Fixed - Notebooks: Background color was not being applied. #260 - Cassandra: Was forcing a username. #261 ## 1.6.8 - 2025-01-30 ### Changed - Notebooks: Tabs have been removed from output. #247 - Notebooks: The option to save output in a notebook has been added (under active development). #44 ### Fixed - Range highlighting better handling new lines after semicolons - MySQL/MariaDB: Fixed issue with unicode enum values. - CockroachDB: Fixed issues with default database and introspection differences with Postgres. #258 - Tunnels: Fixed issue with private keys without passwords prompting for passwords. #257 ## 1.6.7 - 2025-01-28 ### Changed - DB Explorer context menu now has filtering for any set of items (tables, views, etc). This replaces the previous filtering of databases and schemas configured per connection. #115 ### Fixed - Exports no longer includes the row number column. - CockroachDB: Fixed error when trying to connect to local instance, and a typo. #253 ## 1.6.6 - 2025-01-28 ### Changed - If a table has more rows than rowsToLoad setting (default 100) filtering, paging and scrolling will fetch rows from the database as needed. #170 - Added warning if refreshing results with unsaved changes. - Setting: Removed maxRowsToFetch - Setting: Added rowsToLoad (default 100). Controls number of initial rows loaded when opening a table or view. #170 ### Fixed - Exporting insert statements will use the tables name (if present). #250 ## 1.6.5 - 2025-01-26 ### Changed - When results are returned that hit the max row limit, sorting will now re request the data from the server. #170 - SQLite: Added support for loading extensions, currently only sqlite-vec. #249 - Notebooks: Changed file format to YAML for better Git readability. ### Fixed - SQLite: Added real mapping (changed float to be the alias). #246 - Result column filters were not working for date columns correctly. ## 1.6.4 - 2025-01-25 ### Changed - Moved to perpetual license model. - Setting: Order By Primary Key: Will order by the primary key if present when opening a table. #220 - Notebook: The connection is now persisted in the notebook file, and the notebook will show an error if the connection cannot be found on re opening the file. #44 ## 1.6.3 - 2025-01-22 ### Changed - SQL files now show the statement boundaries in the editor. By default the execute icon/keybinding will execute the statement in the boundary. #143 ### Fixed - DBCode panel now aware of changes to pagination setting. ## 1.6.2 - 2025-01-22 ### Changed - Settings: Added a setting to enable pagination in the results, along with icon to turn it on per result set (bottom right of the result table). - BigQuery: Metadata from the executions (Cache hit, bytes processed) are now shown in the status bar. #159 - Removed Apply Changes button from the status bar, save icon is still in the toolbar, keyboard shortcut was added. - Fixed result editing of boolean fields to use the checkbox, and handle null values for boolean fields correctly. - Added cmd/ctrl+n to add a new row in the results. #228 - Added cmd+delete ctrl+backspace to delete rows in the results. #228 - Added cmd/ctrl+d to duplicate rows in the results. #228 - Added a filter option to tables, preview of the functionality to replace schema/database filter. #115 ### Fixed - Applying a value to a selection of cells was not appling to all the cells in the selection. ## 1.6.1 - 2025-01-17 ### Changed - Added support for materialized views (Postgres and BigQuery). #214 - Added cmd/ctrl+r to refresh the results (if enabled). #250 - BigQuery: Added support for editing functions, ADC authentication. #159 ### Fixed - Fixed a bug when the file system could not be read. #218 - Show correct icons when opening views and materialized views. ## 1.6.0 - 2025-01-17 ### Changed - Added BigQuery support (in Beta). #159 - Added cmd/ctrl+s to save all changes in the grid. #215 - Added the connection color to tab icons where applicable. #72 ### Fixed - Result saving was being incorrectly enabled if a single change was made, and then another change made which resulted in the original value. #210 - Undo/Redo keyboard shortcuts when multiple result tabs were visible in the DBCode panel where applying to all result tabs. ## 1.5.12 - 2025-01-13 ### Changed - Added support for storing connections in the workspace. #200 - Added right click context menu to folders to recursively discover connections. ### Fixed - Postgres: Version detection has been improved to handle cases like 12.6dbup. #201 ## 1.5.11 - 2025-01-11 ### Changed - Added a row number column to the results, which also now provides row selection interface like a spreadsheet (ctrl/cmd and shift support for ranges). #138 ### Fixed - Context menu on editable results was missing add and duplicate row option. ## 1.5.10 - 2025-01-09 ### Changed - Added right click open in DBCode option for .sqlite and .sqlite3 files. #171 - Added ability to resize the grid in the notebook. #191 ### Fixed - Changed Chinese translation for Save. #192 - Fixed connection form elements from not showing their translations. #192 - Postgres: Fixed array data types. #167 ## 1.5.9 - 2025-01-06 ### Changed - Added a new command to the database context menu to execute SQL files on a database. #162 - Reduced logo size in activity bar. ### Fixed - Fixed error with hovering a procedure name in the editor that does not have parameters. #184 - Postgres: Added the pseudo types to introspection. #163 - Postgres: Added support for composite types. #164 ## 1.5.8 - 2024-12-18 ### Changed - Added Entity Relationship Diagram option to the context menu of individual tables, filters the initial display to that table and it's related tables. #134 ### Fixed - Revised URL handling for file paths on auto discovery. #152 #156 - ERD was not loading when a column type was not matched to a type from the schema. #153 ## 1.5.7 - 2024-12-17 ### Fixed - Snowflake now supports Key Pair Auth #113 - CoPilot will now quote identifiers in case sensitive dialects #154 ## 1.5.6 - 2024-12-17 ### Changed - Snowflake supports full introspection, and procedures are now supported. ### Fixed - Handle urls that cannot be parsed in autodisovery and manual discovery. #152 ## 1.5.5 - 2024-12-14 ### Changed - Updated Snowflake connections to support SSO, Warehouse, and Secondary Roles. #113 - Updated Redshift to the new introspection model. #146 ## 1.5.4 - 2024-12-12 ### Changed - Updated MySQL/MariaDB to new introspection model. #145 #132 #122 ## 1.5.3 - 2024-12-12 ### Fixed - MySQL/Maria null dates (0000-00-00) were causing a results not to render. #137 - Notebook results windows were incorrectly sized. #144 ## 1.5.2 - 2024-12-10 - Added preview support for IBM DB2 - Added a completion item to include all fields in a table when typing table.* ### Fixed - Result columns are now resized sooner to avoid the flash of resizing on initial loading. - Result columns can now be dragged as wide as needed. ## 1.5.1 - 2024-12-07 ### Changed - Added support for MotherDuck. #136 ### Fixed - Fixed Snowflake schema to default to public. ## 1.4.17 - 2024-12-07 ### Changed - Preview of Snowflake support. #113 ## 1.4.15 - 2024-12-06 ### Changed - Added a setting to control the date/time format. #85 - Added a setting to control if dates should be shown in your computers local time, or UTC when timezone information is present. #85 - Changed Postgres supported version to 9.5 or higher. #129 ### Fixed - Maria text fields were showing as binary. - Postgres introspection error on version 9.5 through 10. #129 ## 1.4.14 - 2024-12-04 ### Changed - Datetime columns with timezone information now show in the local time. #85 - Datetime columns now display in the locale/region format of the computer. #85 - Editing a datetime column will highlight the cell in red if the value does not parse. - Datetime columns that are edited are converted to ISO format when sent to the database. ### Fixed - Tab did not set the cell value when editing data and the cell contained a drop down. ## 1.4.13 - 2024-12-02 - Keybinding to show DB Explorer does not break find next (cmd/ctrl+d). #121 - Executing tabs can be closed, will prompt to cancel execution. #125 - Potential fix for Postgres queries not returning. #125 - Bit fields handled correctly in the data editor. ## 1.4.12 - 2024-11-22 ### Fixed - SQL Server was not handling UTF strings correctly in data changes. - Checkbox removed from the table editor. ## 1.4.11 - 2024-11-21 ### Changed - Moved create database context menu item to the Connection in the DB Explorer. - Added context menu item to add a connection to a group. ### Fixed - Connection error with MariaDB 10.5 through 10.6.10. - Added OUTPUT clause to procedure parameters. ## 1.4.10 - 2024-11-19 ### Changed - Added a fallback autocomplete to use when parser cannot parse the SQL. ## 1.4.9 - 2024-11-17 ### Changed - Prevented autocomplete from suggesting a lot of syntax, single character tokens. ### Fixed - Tables with foreign keys across schemas would not open correctly in the grid detail feature. - Tables with foreign keys to tables in other schemas which the user did not have access to caused an error. #118 - Change MongoDB to use direct connection when not using SVR protocol. #119 ## 1.4.8 - 2024-11-14 ### Changed - Added cmd+d,cmd+b and ctrl+d,ctrl+b hotkeys to show the DB Explorer. #106 - Improved autocomplete suggestions, including support for update, and common table expressions. - Added autocomplete support for EXEC procedure statements. - Autocomplete will work if statements are not seperated by a semi-colon. #46 ## 1.4.7 - 2024-11-11 ### Changed - Added cmd+f and ctrl+f hotkeys to search the grid. #106 - Added support for JOIN, GROUP BY, HAVING, and ORDER BY to autocomplete. #59 ### Fixed - Azure Entra ID authentication was not refreshing the token. ## 1.4.6 - 2024-11-10 ### Changed - Diagrams now show the primary key icon as highlighted. - Diagrams can now be saved as PDFs or PNGs. #38 ## 1.4.4 - 2024-11-08 ### Fixed - Postgres better detection of users access to databases when connecting. #105 - Postgres errors not being raised when unable to connect to the server. ## 1.4.3 - 2024-11-08 ### Changed - Binary cells can now have files loaded directly into them when editable. #104 - More values are present in the Set Value menu for editable cells. #76 ## 1.4.1 - 2024-11-07 ### Fixed - SSH Config that failed parsing would cause the extension to crash. - Creating tables with single primary key column is now inlined in the DDL. - LibSQL was not showing the table structure for empty tables. - Creating tables in Cassandra with dual primary keys was producing invalid DDL. - Creating tables in Oracle with identity columns and single primary keys was producing invalid DDL. ## 1.4.0 - 2024-11-07 ### Changed - Added Cassandra as a NoSQL database. #83 - Added DuckDB as a SQL database. #106 ### Fixed - Fixed introspection query for MySQL 8 that was breaking the SQL parser in MySQL. #100 - Boolean field editing caused an error. #102 ## 1.3.18 - 2024-11-01 ### Fixed - SQL Server tables were not editable. #93 - MariaDB 10.4 and below connections did not work if the driver was set to MySQL. #86 ## 1.3.17 - 2024-10-31 ### Fixed - Parser error when loading tables from DB Explorer. #90 ## 1.3.16 - 2024-10-30 ### Fixed - Autocomplete now works with more complex Select statements (nested selects, alaised tables, etc). - Autocomplete now works with Delete statements. - Autocomplete now works with Insert statements, including nested selects. ## 1.3.15 - 2024-10-27 ### Changed - New Charts added to the chart menu. - Option to expand/shrink the chart. #37 ### Fixed - Selecting MySQL for a MariaDB could lead to incorrect introspection being used, this is now fixed. - Tables named after SQL Keywords (eg user) were not editable. - Grid lines now show when enabled in a chart. #34 - Autocomplete now suggests operators and multiple condition where clauses. ## 1.3.14 - 2024-10-27 ### Fixed - SQL Server 2016 now works with the DB Explorer. ## 1.3.13 - 2024-10-25 ### Changed - Data can now be changed without signing in/purchasing a subscription, however changes are not verified before applying them when not signed in/subscribed. - Updated the new connection UI. - Add the count of items in each "folder" in the DB Explorer. ### Fixed - Introspection is now supported on MariaDB 10.3 and above. ## 1.3.11 - 2024-10-22 ### Changed - Groups can now be renamed in the DBExplorer. #73 ### Fixed - D1 now shows views. - Introspection is now supported on MariaDB 10.0 and above. #74 and #71 ## 1.3.10 - 2024-10-21 ### Changed - Table DDL editing now uses transactions where appropriate. - Custom theme extensions are now supported for syntax highlighting in the table editor. ### Fixed - MongoDB connections can now be created without a username. #70 - MariaDB 10.5 or higher is required. ## 1.3.7 - 2024-10-19 ### Changed - Changes preview in the table editor now matches the VSCode theme for the built in themes. ### Fixed - Retrying a failed connection in the DB Explorer now works. - Applying table changes now works. ## 1.3.6 - 2024-10-18 ### Changed - Table creation and editing is now working, with change preview. ## 1.3.3 - 2024-10-15 ### Changed - Added (null) to the drop down menus when editing a field that allows null. - Added a Set Value menu item to the context menu for editable cells. #47 ### Fixed - Fixed Oracle introspection to use all_x and work with user level privileges. #58 - Added string and number to D1 data types. #64 ## 1.3.2 - 2024-10-14 ### Changed - MongoDB now supports user code in the editor. #55 ### Fixed - DB Explorer filtering now expands items correctly, and works with cloud providers. #42 - Autocomplete now works again in Notebooks. #56 - Trimmed long column comments in the Hover help. #50 ## 1.3.1 - 2024-10-14 ### 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. ## 1.3.0 - 2024-10-13 ### 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. ## 1.2.16 - 2024-10-07 ### 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. ## 1.2.14 - 2024-10-04 ### 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. ## 1.2.8 - 2024-09-28 ### 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. ## 1.2.7 - 2024-09-25 ### 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. ## 1.2.5 - 2024-09-19 ### 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. ## 1.2.4 - 2024-09-17 ### 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. ## 1.2.3 - 2024-09-15 ### 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. ## 1.2.2 - 2024-09-13 ### 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. ## 1.2.1 - 2024-09-11 ### Changed - Published to the Open VSIX marketplace. ### Fixed - Authentication was not working in the Cursor version of VS Code. ## 1.2.0 - 2024-09-10 ### 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. ## 1.1.6 - 2024-09-04 ### 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. ## 1.1.5 - 2024-09-02 ### Changed - Added schema aware AI code completions for the SQL language, using GitHub Copilot if available or llama-3.1. ## 1.1.3 - 2024-08-29 ### Fixed - MySQL and MariaDB no longer require root user privileges to connect. - MariaDB 11.2.5 bug with introspection fixed. ## 1.1.2 - 2024-08-15 ### Changed - Updated README. ## 1.1.1 - 2024-08-13 ### Changed - Added DDEV as a zero config source. ## 1.1.0 - 2024-08-07 ### Changed - Added Cloudflare as a cloud provider. - Added support for Cloudflare D1. ### Fixed - Previous result tabs sometimes failed to display data when revisited. - SQLite/libSQL would not display the primary key correctly if it was not a sequence. ## 1.0.0 - 2024-08-07 ### Changed - Subscription required for some features, 14 day trial created upon signing in. See our [Pricing](https://dbcode.io/pricing) page for details. ## 0.17.1 - 2024-08-01 ### Fixed - Icon added for Notebooks. - SQLite/libSQL now shows row counts for tables in the explorer. ## 0.17.0 - 2024-07-30 ### Changed - @dbcode has been added as a chat participant if you have the Github Copilot extension installed. - You can right-click on a supported database file (.db) and choose to open it in DBCode. - Autocomplete now works in notebook cells. ### Fixed - The data grid now uses the editor font for cell values. - Data grid column widths are now limited to prevent excessive length when the table has many columns. - Data grid charts now correctly display numeric values for series data. ## 0.16.2 - 2024-07-25 ### Changed - Added support for removing a group of connections from the explorer, as well as removing a single connection from a group in the explorer. - Switched to a universal build. Binary packages will be downloaded as needed instead of being included in the extension. - Added cloud providers to the connection picker. ### Fixed - Postgres databases in some cases were not displaying results. ## 0.16.1 - 2024-07-22 ### Changed - Updated SQLite driver. - Results can now render hundreds of megabytes of data. ### Fixed - MySQL/MariaDB connections were not using the connection timeout setting. - MySQL/MariaDB connections would not show the correct error message when the connection failed. - MySQL/MariaDB connections show better SQL errors. ## 0.16.0 - 2024-07-17 ### Changed - Added Azure cloud provider, supports Azure SQL, Azure Postgres and Azure MySQL via Microsoft Entra ID authentication. - Added support for Microsoft Entra authentication to Azure SQL connections. ## 0.15.1 - 2024-07-15 ### Changed - Added support for MySQL 5.7. - Added a filter option to connections to filter schemas and databases in the explorer. ## 0.15.0 - 2024-07-12 ### Changed - Relationships: Browse foreign key relationships in data to view related data in other tables. - Edit data and access relationships for your select queries. - Aiven cloud provider added. ### Fixed - PostgreSQL showed duplicate columns in the foreign key when a foreign key had multiple columns. - SQLite did not show columns in the explorer whose names matched the table name. ## 0.14.1 - 2024-07-05 ### Fixed - Codelens now indicates whether you are executing a selection or the entire document. - libSQL now supports encrypted local files. ## 0.14.0 - 2024-07-03 ### Changed - Cloud providers support added. ([more details](https://dbcode.io/docs/cloud-providers)) ## 0.13.0 - 2024-06-29 ### 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. ## 0.12.6 - 2024-06-27 ### 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. ## 0.12.5 - 2024-06-15 ### 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. ## 0.12.4 - 2024-06-11 ### 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. ## 0.12.3 - 2024-06-11 ### 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](https://dbcode.io/docs/connections/zero-config)) - 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. ## 0.12.2 - 2024-06-07 ### Fixed - Updated Microsoft Authentication to use common tenant. ## 0.12.1 - 2024-06-06 ### Changed - Added license information, customer portal and license purchasing to Account view. ## 0.12.0 - 2024-05-31 ### Changed - Added option to securely share reports. - Added an Account view to enable authentication via VSCode authentication providers, necessary for secure report sharing. - Added image preview when hovering over image in binary field. ### Fixed - Mongo protocol was not correctly saved when editing a connection. - Editing connections in groups would cause them to ungroup. ## 0.11.2 - 2024-05-28 ### Changed - Binary fields containing images now display thumbnails in the results. - String fields exceeding 500 characters are trimmed, displaying the total size at the end. - Tooltips added for all result columns with values longer than 200 characters/bytes. - Options to export all results, a selection, or selected rows. - Export results in various formats: CSV, Excel, SQL insert statements, JSON, XML, Markdown, or HTML. - Copy a selection or selected rows as text, CSV, SQL insert statements, SQL In Clause, JSON, XML, Markdown, or HTML. - Added the ability to duplicate rows when editing results. - Context menu includes options to add, duplicate, and delete rows if the results are editable. ## 0.11.1 - 2024-05-25 ### Fixed - Marketplace listing colors. - Number rounding on tab badges. ## 0.11.0 - 2024-05-24 ### Changed - SQLite support added. - Added option to explore with a sample database. ### Fixed - The results table now better aligns with the VS Code theme. - Fixed an issue where editing stored procedures incorrectly indicated an error had occurred. - MySQL did not correctly handle integers bigger than the javascript limit. ## 0.10.0 - 2024-05-16 ### Changed - MongoDB support added (table loading, data editing completed, work continues on executing arbitrary statements). - Added data type to column headers. - Trimmed large data in binary cells to show first 50 characters, and total size. - Added output channel and logging of connection and tunnel events. ## 0.9.3 - 2024-05-10 ### Changed - Added a key binding (Ctrl/Cmd+d Ctrl/Cmd+c) to select/change connection of the current file. ### Fixed - Improved the rendering performance for large result sets (1M+ rows). - MySQL/Maria was showing undefined in the statusbar for schema. - MySQL/Maria was not showing correct number of rows updated for insert, update and delete statements. - Geometry and Geography data types in results caused the results not to show. - Dates with timezones are now displayed with timezone indicators to reflect their true format in the database. ## 0.9.2 - 2024-05-08 ### Changed - Automatically generate entity relationship diagrams to visually map out your database structures. Simply right-click on the tables folder of a database and select the "Entity Relationship Diagram" option. ### Fixed - Light themes were not showing the correct database icons for MariaDB in the connection picker. ## 0.9.1 - 2024-05-02 ### Fixed - Tables now always open with the maximum row limit configured in settings (100,000). Right-clicking on a table provides an option to open it with a different limit. - SQL Server connections failed unless the user account had the sysadmin role assigned. ## 0.9.0 - 2024-05-01 ### Changed - Data within a table can now be edited, added, or deleted, with changes saved directly back to the database. ### Fixed - Opening a table sometimes did not render the data. - SQL Server displayed incorrect lengths for nvarchar and nchar datatype columns. ## 0.8.2 - 2024-04-25 ### Changed - Clicking on a table or view in the explorer now loads its data in a new tab. - Added setting _dbcode.maxRowsToFetch_ to control the maximum number of rows fetched when opening a table. ## 0.8.1 - 2024-04-09 ### Changed - Added SSH Tunnels. Tunnels are automatically detected from ssh.config and can also be manually created. - Introduced a table icon to the results tab; clicking on this icon will pin the tab for easy access. ### Fixed - Postgres: Ensure columns in indexes are displayed in the correct order, even when they differ from the table order. ## 0.8.0 - 2024-03-29 ### Changed - MariaDB support added. ### Fixed - MySQL connections required SSL and would not work without SSL. ## 0.7.0 - 2024-03-28 ### Changed - MySQL support added. - Timescale support added. - Yugabute support added. - Renamed Primary Keys to Primary Key in the explorer. - Hovering over tables and views in the editor reveals column and table/view comments. ### Fixed - When running multiple statements simultaneously, column names were missing from all results except the first. - Postgres failed to indicate when a primary column was utilized in a foreign key in the explorer. - Confirmation dialogs previously didn't respond properly to users not making a choice and exiting via escape. ## 0.6.0 - 2024-03-15 ### Changed - CockroachDB support added. ## 0.5.2 - 2024-03-01 ### Changed - Reduced memory usage and initial startup time. ### Fixed - Notebook incorrectly opening new editor tab when an SQL error occurred.