Changelog

Changed

• MSSQL: Added Named Pipe and LocalDB connection support for Windows, allowing connections via named pipes or LocalDB instance. #497
• Neo4j/Memgraph: Added relationship visualization to entity diagrams, showing connections between Labels.

Fixed

• Hive: Fixed introspection failure due to integer overflow in HiveServer2. #904

Changed

• Neo4j/Memgraph: Added preview support. #572 #622 #617
• PostgreSQL: Added “Truncate Cascade” option for tables to handle foreign key constraints.
• Netezza: Added query cancellation support, removed from preview. #748
• MSSQL: Added Windows Integrated Authentication (SSPI) (Testing).

Fixed

• Connections: Fixed SSL/TLS settings not being preserved in “Copy Connection String” and “Import Connection String”. #905
• Hive: Not fetching all data during introspection. #904

Changed

• Editor: Added signature help for user-defined functions and procedures, showing parameter names, types, and active parameter position.

Fixed

• SingleStore: Fixed introspection error due to missing generation_expression column. #903
• Hive: Fixed introspection limited to 100 tables due to default fetch size. #904
• ClickHouse: Fixed connection failure on legacy versions (< 21.11) due to missing comment column in system tables. #902

Fixed

• PostgreSQL: Fixed introspection failing when user lacks access to system tables (pg_inherits, pg_trigger, pg_matviews, pg_policies, pg_foreign_server).
• Zero Config: Fixed discovered connections not updating when adding folders. #900
• MSSQL: Fixed DROP PROCEDURE and DROP FUNCTION commands to use correct syntax.
• Oracle: Fixed DROP PROCEDURE and DROP FUNCTION commands to use correct syntax.
• MySQL/MariaDB: Fixed DROP PROCEDURE and DROP FUNCTION commands to use correct syntax. #898
• MySQL: Fixed procedures/functions not using DROP statement for alter workflow. #898

Changed

• Hive: Added protocol version selection (V7 for Hive 1.2+, V10 for Hive 3+) to connection settings. #661

Fixed

• Hive: Fixed transactional table detection for Hive 2.x to enable grid editing on ACID tables. #661
• Access: Fixed download by hosting package in DBCode repository with manual file fallback for air-gapped environments. #546
• BigQuery: Fixed functions incorrectly showing as procedures and added proper return type display.
• BigQuery: Fixed DROP PROCEDURE and DROP FUNCTION commands to use correct syntax.

Changed

• MongoDB: Added authentication mechanism selection (SCRAM-SHA-1, SCRAM-SHA-256, X509, AWS, LDAP, Kerberos) to connection settings. #892

Fixed

• Results: Fixed first cell not receiving focus when opening tables via Quick Open. #840
• Results: Fixed ESC key not closing relationship sub-tables when focus was inside the nested grid.
• Hive: Fixed materialized view DDL generation to output CREATE MATERIALIZED VIEW instead of CREATE TABLE.
• MongoDB: Fixed connection string import not parsing query parameters (authSource, authMechanism, tls). #892

Changed

• DynamoDB: Added DynamoDB (Preview). Supports AWS credential chain, access keys, auth profiles, and DynamoDB Local. #495, #887
• Hive: Added Apache Hive (Preview). Supports HiveServer2 via Thrift protocol with TCP and HTTP transports. #661
• Impala: Added Apache Impala (Preview). #190
• RavenDB: Added RavenDB (Preview). #252

Fixed

• Results: Fixed copy/paste not preserving null and boolean values between grid cells.

Changed

• Language Server: Now enabled by default. Disable with dbcode.useLanguageServer setting if needed.
• QuestDB: Now generally available (out of preview). #527

Fixed

• BigQuery: Fixed stored procedure DDL script missing parameters.
• BigQuery: Improved introspection to gracefully handle permission-denied errors. Dataset browsing now shows accessible objects (like procedures) even when table access is restricted.
• Elasticsearch: Fixed connection errors with Elasticsearch 7.x and 8.x servers. #890
• MongoDB: Fixed introspection error on system.profile when user lacks listIndexes permission. #863
• PostgreSQL: Fixed connection failure when user lacks SELECT permission on pg_database view.

Changed

• Date/Time Display: Added “Raw” option to date style setting that preserves original database values without formatting or timezone conversion. Maintains full precision (microseconds) as stored in the database.

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

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.

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.

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.

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

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