v0.30.0

What's Changed

Documentation

• Added comprehensive documentation for the Dory CLI and MCP (Model Control Protocol) usage.
• Documented the new Dory agent skill, including setup instructions, example workflows (e.g., schema comparison, production query debugging, exploring unknown schemas), and MCP integration guidance.
• Updated skill installation documentation to point to the canonical skills repository.

Database Support

• Added Oracle Database to the list of supported databases, including a dedicated logo and updated UI icons.
• Added Cloudflare D1 to the list of supported databases.

Web App Improvements

• Fixed result table caching behavior and corrected site metadata rendering across pages.
• Improved SQL result table column width auto-fitting logic for better readability of query output.

Internal

• Consolidated and merged skill-related documentation updates via PR #326 and PR #327.

v0.28.0

What's Changed

Features

• Added native Supabase connection support, including dedicated connection form, validation, and TLS configuration handling.
• Extended SQL console capabilities to work with Supabase databases, including dialect-aware SQL execution and tooling integration for AI-assisted queries.

Improvements

• Updated connection UI components to display Supabase as a first-class database option, with custom icon and type handling.
• Enhanced AI prompt tooling to include Supabase-specific SQL operations in the sql.tools context.

Internal

• Added comprehensive test coverage for Supabase connection TLS behavior.

v0.27.0

What's Changed

Features

• Added full Snowflake connection support, including dedicated driver, form fields, database type icon with beta badge, and backend payload validation.

Improvements

• Enhanced workspace navigation and connection handling across the web app for smoother user flow.
• Improved SQL panel resizing behavior for better usability in the SQL console.

Fixes

• Fixed SQL panel resizing inconsistencies and added end-to-end test coverage to prevent regressions.

Internal

• Stricter connection payload validation and sanitization logic to improve security and data integrity.
• Updated build configuration (next.config.ts) to conditionally include Snowflake-related packages.

v0.25.1

What's Changed

SQL Console & Table Browser Improvements

• Replaced pagination page picker with a direct page input field for faster navigation in table previews and query results.
• Improved SQL result table rendering: better column width fitting, reduced horizontal overflow, and enhanced readability across database drivers (including ClickHouse and Cloudflare D1).

MCP Authentication & Desktop Grants

• Fixed desktop grant resolution to correctly use the route’s organization slug—ensuring proper authorization scope when recovering sessions or accessing MCP resources.

Documentation Updates

• Refreshed READMEs across English, Chinese, Spanish, and Japanese locales to clarify positioning and value of the agentic SQL workspace.
• Added documentation for Claude Code MCP setup options in both CLI and MCP package READMEs.

v0.25.0

What's Changed

Features

• Introduced Codex Agent, a new local AI bridge with MCP support, replacing the previous local AI bridge setup. Includes CLI-driven installation, service management, and deep-link integration for workspaces.
• Added credentialless MCP authentication, enabling secure agent access without requiring database credentials for certain connection types.
• Implemented MCP dory_action facade for connection-related operations (create, test, update, delete), with tools split into read/write categories for improved safety and clarity.
• Enabled workspace deep links across Electron, web, and MCP contexts to streamline navigation and context switching.

Improvements

• Improved table preview pagination—now resets automatically when data source changes.
• Enhanced workspace connection handling and UI state consistency across settings, SQL console, and agent workflows.
• Grouped AI provider cards in organization settings for better visual organization and discoverability.
• Updated local AI provider icons and usage hints, including new Codex Agent branding and documentation.
• Added CLI version flag (--version) and improved runtime command structure for better usability and debugging.

Fixes

• Fixed MCP stdio shutdown behavior and pglite reset handling, improving stability during agent lifecycle events.
• Resolved Electron userData path resolution, ensuring correct configuration and data persistence across platforms.
• Repaired missing file connection paths during PGlite workspace migrations.
• Fixed CLI package metadata and binary paths, ensuring proper installation and execution.
• Corrected authentication config by removing experimental join logic that caused instability.

Internal

• Refactored agent run workspaces and SQL console integration for cleaner architecture and maintainability.
• Added comprehensive test coverage for Codex Agent, MCP facades, credentialless auth, and local runtime coordination.
• Bumped CLI to v0.1.7 and MCP package versions; updated Docker and CI workflows for headless releases.

v0.24.2

What's Changed

Improvements

• Enabled improved authentication flow for user joins, enhancing login and session management in the web application.

Fixes

• Fixed Docker workspace manifests to ensure correct image builds and consistent runtime behavior across environments.

v0.24.1

What's Changed

Improvements

• Enabled logging of proxy authentication attempts in the web app, aiding administrators in monitoring and troubleshooting auth flows.

Internal

• Updated authentication logic to support configurable logging for proxy-based auth requests.

v0.24.0

What's Changed

Agent Workspace & Runs

• Introduced a persistent agent workspace drawer with improved layout, desktop bridge detection, and prevention of accidental dismissal
• Added unsaved workspace close confirmation and support for saving agent workspace state and SQL tab persistence
• Enhanced agent run summaries to appear consistently across continuation runs, with improved titles, archive actions, and status indicators in SQL results
• Refined agent run list UX with better spacing, activity timelines, and summary sections; added a guided workspace tour
• Moved agent run context into the workspace panel and embedded the workspace drawer directly into the organization layout

SQL Console & Connections

• Persisted SQL editor layout and fixed SQL append boundaries for more reliable query editing
• Improved connection handling and UI state flows, including refined sidebar navigation for connection states and data source placeholders
• Updated sidebar to show data source count and localized workspace labels and query audit text
• Switched the organization sidebar to icon-based collapse and constrained the connection switcher menu height
• Fixed SQL console overflow issues and aligned background colors between the console and sidebar

MCP Integration

• Exposed Dory actions and facade MCP tools to external tools, hardening saved query actions and improving tool registry coverage
• Routed all MCP requests through server-core and fixed import paths for better maintainability
• Added comprehensive test coverage for MCP facade tools and action registries

Table Browser & Schema

• Improved table browser pagination controls with localization support and switched to nuqs for state management
• Tightened column typing in table queries and relaxed schema stats requirements to handle missing metadata gracefully
• Refreshed schema metadata automatically after SQL DDL operations and relaxed organization slug validation

Internal

• Refactored connection handling, work flow, and SQL console state management across multiple hooks and stores
• Updated dependencies and configuration (e.g., nuqs, tsconfig, package.json) to support new workspace and MCP features

v0.23.4

What's Changed

Features

• Added table actions (e.g., rename, drop) directly in the SQL console sidebar and tab interface, enabling quick schema modifications without writing raw SQL.

Improvements

• Introduced a download progress dialog during manual application updates in the Electron desktop app, improving transparency and user feedback during update checks.

Internal

• Consolidated and refined table action logic across the SQL console frontend and backend, including updated driver capabilities for ClickHouse and Cloudflare D1 to support table metadata operations.

v0.23.3

What's Changed

Features

• Added support for Cloudflare D1 as a new database connection type, including dedicated form fields, UI icons, and SQL console integration.
• Introduced a “Duplicate Connection” action, accessible via context menu and connection cards, to quickly create copies of existing connections.

Improvements

• Enhanced i18n support with translations for the new duplication action and Cloudflare D1 connection labels across English, Spanish, Japanese, and Chinese locales.

Internal

• Extended backend connection handling logic to support duplication and Cloudflare D1-specific configuration and validation.