返回发布说明
v0.7.0同步自 GitHub release-notes

Release v0.7.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

在 GitHub 查看源文件

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, retrieve database schema, execute SQL queries, and ask natural language questions — all supporting both session cookies and Bearer tokens with x-organization-id for multi-tenancy.
  • Anonymous Account Support: Added full guest access: users can now explore connections, run SQL, and use the AI chatbot without signing in. Anonymous accounts are automatically created, linked to demo data (including SQLite), and cleanly deleted upon account creation or explicit opt-out.
  • Enhanced AI Chat Experience:
    • New welcome page in the chatbot with contextual heading, table-aware suggested prompts, and embedded input for instant interaction.
    • “Ask AI to write SQL” button added to the SQL Console empty state.
    • Schema-aware suggestions dynamically generated from actual table/column names.
    • Improved cold start: sidebar hides when empty, input auto-focuses, and placeholder text guides first-time users.

Fixes

  • Chat Session Isolation: Fixed broken connection-level scoping — chat sessions are now correctly filtered by connectionId, preventing cross-connection leakage within the same organization.
  • Chatbot Welcome Page Reliability: Resolved multiple bugs: table mentions now appear in the welcome textarea, sessions are only created on first message (not on "+" click), and initialPrompt is no longer prematurely cleared before component mount.
  • Duplicate Message Prevention: Eliminated race-condition duplicates when clicking suggested prompts in the chatbot.
  • SSH & UI Polish: Added file picker for SSH private keys (.pem, .key, .pub, .ppk), cursor pointers to interactive elements, skeleton loading for the explorer sidebar, and fixed i18n key mismatches across locales.
  • Desktop Runtime Stability: Fixed org slug resolution and ensured SQLite demo data loads correctly for guest users in the Electron app.

Improvements

  • Authentication Flow: Streamlined anonymous account lifecycle — including bootstrapping, linking, and cleanup — with robust migration handling and test coverage.
  • SQL Console UX: Enforced full-account requirement for saving queries, improving data ownership clarity.
  • Accessibility & Localization: Expanded i18n support across new UI elements (file picker, sidebar states, connection forms) for English, Spanish, Japanese, and Chinese.

Internal

  • Upgraded core dependencies: @xmldom/xmldom (0.8.11 → 0.8.12), lodash and lodash-es (4.17.23 → 4.18.1), and electron (38.7.2 → 39.8.4).
  • Refactored anonymous account provisioning, migration logic, and auth routing for maintainability and correctness.
  • Improved E2E test reliability with updated mocks, PostHog noise filtering, and dedicated automation API test suites.