Changelog

Track our development progress with detailed updates, improvements, and bug fixes.

  • v1.22.2

    Changed

    • Parameters: Added support for positional parameters ($1, $2, etc.) outside of function bodies. #889
    • Authentication Profiles: Extended .pgpass and command auth profiles to CockroachDB, Greenplum, QuestDB, RisingWave, Timescale, and YugabyteDB.
    • Oracle: Added support for Oracle 11g when using Instant Client (Thick mode).

    Fixed

    • Language Server: Fixed false “Unknown column” warnings for stored procedure/function parameters and DECLARE variables.
    • Language Server: Fixed JOIN hints not using table aliases in ON clause conditions (e.g., ON a.id = b.user_id now uses both aliases correctly).
    • Redis: Fixed authentication failing on Redis versions before 6.0 which don’t support username in AUTH command. #888
  • v1.22.1

    Changed

    • Authentication Profiles: Added .pgpass file authentication profile for PostgreSQL.
    • BigQuery: Added support for cross-project browsing with separate billing project. Users can now browse datasets from external projects (e.g., bigquery-public-data) while using a different project for query billing.
    • Athena: Added workgroup support for organizations with IAM policies that restrict query execution to specific workgroups. #880

    Fixed

    • Connections: Fixed SSL checkbox being locked for known hosts (AWS RDS, etc.) when using SSH tunnels. #883
    • Oracle: Fixed connection error on Oracle Free Docker containers where PRODUCT_COMPONENT_VERSION view returns empty results. #885
    • DuckDB: Fixed database file remaining locked after disconnecting. #884
    • Cloud Providers: Fixed schema caching failing on Windows due to invalid path characters in connection IDs.
  • v1.22.0

    Changed

    • Microsoft Access: Added support for Microsoft Access databases (.mdb, .accdb). (Preview, Windows only). #546
    • Transactions: Added dbcode.transactions.defaultAutoCommit setting to control the default auto-commit mode for new pinned connections.
    • Schema Switching: Added automatic schema context detection for Oracle, PostgreSQL, DB2, Databricks, and Snowflake when executing schema switch commands.

    Fixed

    • SQLite: On large databases (1GB+) using approximate ANALYZE with analysis_limit and skipping table size calculations.
  • v1.21.3

    Changed

    • Microsoft Access: Added support for Microsoft Access databases (.mdb, .accdb). (Preview, Windows only). #546
    • Transactions: Added dbcode.transactions.defaultAutoCommit setting to control the default auto-commit mode for new pinned connections.
    • Schema Switching: Added automatic schema context detection for Oracle, PostgreSQL, DB2, Databricks, and Snowflake when executing schema switch commands.

    Fixed

    • SQLite: On large databases (1GB+) using approximate ANALYZE with analysis_limit and skipping table size calculations.
  • v1.21.2

    Changed

    • DuckDB: Added extensions support for loading core and community extensions on connect.
    • Formatting: Improved SQL formatter dialect mappings for ClickHouse, Databricks, Access, CQL, and Elasticsearch.
    • Results: Quick search now highlights matching cells in the grid.

    Fixed

    • SQLite: Fixed slow connection times on large databases (1GB+) by skipping expensive ANALYZE and table size calculations.
    • SQL Server: Fixed backup failing on Docker/local instances with SSL certificate errors by explicitly setting encryption mode.
    • Commands: Fixed Quick Open and other commands failing on first attempt when extension hadn’t activated yet. #876
  • v1.21.1

    Changed

    • TiDB: Added support for TiDB. #872
    • Trino: Username and password are now optional.

    Fixed

    • Zero Config: Fixed symlinked .env files not being detected during connection discovery. #855
    • MySQL/MariaDB: Added support for MaxScale proxy with dbfwfilter by auto-detecting and disabling multi-statement queries (or manual connection configuration). #870
  • v1.20.1

    Changed

    • Language Server: Added dbcode.enableLinting setting to disable SQL linting (syntax and semantic validation). #795

    Fixed

    • Language Server: Fixed false “Unknown column” errors appearing during initial connection when schema is still loading. #869
    • PostgreSQL: Updated bundled pg_dump from 17.6 to 18.1 to support PostgreSQL 18 servers. #871
    • Open Table: Now uses workspace default connection when invoked from command palette. #855
  • v1.20.0

    Changed

    • Elasticsearch: Added support for Elasticsearch (Preview). #323
    • QuestDB: Added support for QuestDB (Preview). #527
    • ScyllaDB: Added support for ScyllaDB (Preview). #680
    • SQLite: Added mod_spatialite extension for spatial SQL capabilities. #867 #576

    Fixed

    • Cassandra/ScyllaDB: Fixed USE command not updating codelens to reflect the current keyspace.
    • Requests: Fixed fetch failing with “Invalid URL protocol” error when proxy is misconfigured or undefined. #868
  • v1.19.10

    Changed

    • DB Explorer: Default connection (from setting or zero config) now indicated with a star (☆), connected icon change to (●).
    • Connections: Connection configured colors now display on the connection item in the tree.
    • Zero Config: Discovered connections will be used as default if a workspace does not have an explicit default connection configured, multiple discovered connections will show a prompt to select one on first request. #855
    • DuckDB: Added “File Search Path” setting to control where relative file paths resolve from (Database Directory, Document Directory, or Workspace Root). #865

    Fixed

    • MongoDB: Fixed introspection error when user lacks aggregate permission on system collections. #863
    • Notebooks: Fixed Python injection failing with “Invalid \escape” error when data contains backslashes. #864
    • AWS SSO: Improved login flow to display authorization code in a persistent notification with clickable link to open browser.
  • v1.19.9

    Changed

    • SQL Server/Azure: Added backup/restore support. #195
    • MongoDB: Added backup/restore support using mongodump/mongorestore. #195
    • MongoDB: Added create and drop database support.
    • Trino: Now generally available (out of preview).
    • Athena: Now generally available (out of preview).

    Fixed

    • MongoDB: Fixed introspection error when user does not have collStats permission. #863
    • Results: Fixed focus not being set on first cell when opening a table. #840
    • Zero Config: Fixed connection IDs to be deterministic, allowing workspace default connections to be shared across developers. #855
  • v1.19.8

    Changed

    • MongoDB: Added Command authentication provider for retrieving credentials from external secret managers (1Password CLI, Vault, AWS Secrets Manager, etc.) or custom scripts. #496
    • Performance: Added experimental background schema worker to build schemas off the main thread. Enable with dbcode.useSchemaWorker setting.

    Fixed

    • MySQL: Fixed connection timeout on large databases (1000+ tables) by loading database sizes asynchronously. #862
    • Authentication Profiles: AWS, auto runs SSO login if needed.
  • v1.19.7

    Changed

    • MongoDB: Added Command authentication provider for retrieving credentials from external secret managers (1Password CLI, Vault, AWS Secrets Manager, etc.) or custom scripts. #496
    • Performance: Added experimental background schema worker to build schemas off the main thread. Enable with dbcode.useSchemaWorker setting.

    Fixed

    • MySQL: Fixed connection timeout on large databases (1000+ tables) by loading database sizes asynchronously. #862
    • Authentication Profiles: AWS, auto runs SSO login if needed.
  • v1.19.6

    Changed

    • DuckDB: Updated to version 1.4.2. #736
    • Results: Added keyboard shortcut to focus WHERE filter (Ctrl+Shift+F / Cmd+Shift+F) and vim-style grid navigation (Ctrl+H/J/K/L). #858

    Fixed

    • Panel: Fixed results panel failing to load when visible during VS Code startup.
    • Parameters: Ignore parameters in PREPARE statements. #857
    • Language Server: Added ClickHouse support for SELECT * EXCEPT column exclusion syntax and SYSTEM REFRESH VIEW statement. #795
  • v1.19.5

    Changed

    • Authentication Profiles: Added a view to the explorer to manage authentication profiles. #279

    Fixed

    • Connection Colors: Fixed empty workbench.colorCustomizations object appearing in workspace configuration file. #836
    • File connections: Fixed CSV/Excel/Parquet/Avro file picker defaulting to folder mode on Windows/Linux. #845
    • MongoDB: Fixed editing disabled for queries run from the editor. #851
    • Results: Fixed parquet export failing when decimal columns are present. #852
  • v1.19.4

    Changed

    • Auth Profiles: First look at centralized authentication profiles (added to Trino for OAuth). #279
    • Results: Auto-focus first cell when switching to results panel for immediate keyboard navigation. #840
    • Trino: Added support for OAuth authentication via new authentication profiles.

    Fixed

    • Databricks: Fixed SSO authentication failing in dev containers and remote environments.
    • MongoDB: Fixed multi-line queries failing with “Unexpected end of input” error. #848

Ready to try DBCode?

Install DBCode today and transform your database workflow in Visual Studio Code.