Download Latest Version Dory-0.13.1-arm64.zip (228.1 MB)
Email in envelope

Get an email when there's a new version of dory

Home / v0.6.4-beta.0
Name Modified Size InfoDownloads / Week
Parent folder
README.md 2026-04-02 2.3 kB
v0.6.4-beta.0 source code.tar.gz 2026-04-02 13.9 MB
v0.6.4-beta.0 source code.zip 2026-04-02 14.8 MB
Totals: 3 Items   28.7 MB 0

What's Changed

Features

  • New Automation API: Introduced a programmatic interface (/api/automation/*) for external systems (CLI, agents, workflows) to interact with Dory without the UI. Includes endpoints to list connections, fetch database schema, execute SQL queries, and ask natural language questions — all supporting both session cookies and Bearer token auth with x-organization-id.
  • Anonymous Account Support: Users can now explore Dory as guests — chatbot access, SQL console, and connection browsing are available without signing in. Anonymous accounts are automatically cleaned up when users later sign up or abandon the session.
  • Enhanced AI Chat Experience:
  • Added a rich welcome page to the chatbot with contextual suggested prompts, table mentions (@table), and embedded input — no manual session creation required.
  • Improved cold-start UX: sessions sidebar is hidden until first message, input auto-focuses, and placeholder text guides new users.
  • Added “Ask AI to write SQL” button in the SQL Console empty state.

Fixes

  • Fixed chat session isolation: sessions are now correctly scoped to connectionId, preventing cross-connection leakage after the organization refactor.
  • Resolved chatbot welcome page bugs: table mentions now render properly, session creation is deferred until first message (not on "+" click), and initialPrompt is no longer cleared prematurely.
  • Fixed i18n errors in the connection switcher and other UI components across multiple locales.
  • Ensured saved queries require a full account — guest users can’t persist queries.

Improvements

  • Upgraded core dependencies: @xmldom/xmldom (0.8.11 → 0.8.12), lodash-es (4.17.23 → 4.18.1), and lodash (4.17.23 → 4.18.1).
  • Refined authentication flow: updated sign-in/sign-up UI styles, improved anonymous account lifecycle handling (bootstrap, linking, deletion), and added robust cleanup logic for abandoned anonymous resources.

Internal

  • Refactored anonymous account infrastructure: consolidated migration logic, ownership transfer, and deletion pathways across PostgreSQL and pglite.
  • Added comprehensive test coverage: 18 unit tests and 10 E2E tests for the Automation API; expanded E2E suite for AI experience and anonymous flows.
Source: README.md, updated 2026-04-02