v0.6 Release — 20 features delivered & manual test plan

[Blankll]

Overview

v0.5.4 → v0.6.1 delivered 20 PRs across 50+ database adapters, AI agent, SSH tunnels, data grid, ER diagrams, explain plans, and more. This issue tracks the full inventory and a 3-scenario manual test plan that covers all delivered features with minimal execution overhead.

Releases: v0.5.4 · v0.5.5 · v0.6.0 · v0.6.1

---

Feature Inventory — All PRs Merged to Master

PR	Feature	Delivered
#56	Transfer module scope-based redesign	Jun 12
#58	AI-powered Data Studio agent	Jun 12
#60	AI provider configuration UI	Jun 13
#61	30+ SQL databases via protocol aliasing, JDBC bridge, native drivers	Jun 13
#62	Data studio agent improvements + transfer enhancements	Jun 13
#63	AI assistant sidebar, task manager, agent config, provider alignment	Jun 14
#77	HTTP proxy for LLM provider connections	Jun 15
#78	Confirmation dialogs for destructive actions	Jun 15
#83	Inline row data search across all columns	Jun 15
#84	Extended schema browser (views, procedures, functions, sub-pages)	Jun 15
#85	ER diagram visualization with interactive canvas	Jun 15
#86	Agent module fixes + adapter improvements	Jun 15
#87	JDBC driver management (registry, fallback chains, JRE auto-detection)	Jun 15
#88	9 wire-protocol databases (Doris, StarRocks, Databend, QuestDB, ...)	Jun 15
#89	Virtual-scrolled data grid with sort, filter, editing, copy	Jun 15
#90	12 new JDBC bridge databases (Hive, Databricks, SAP HANA, BigQuery, ...)	Jun 15
#91	SSH Tunnel & Transport Layer Support	Jun 15
#92	SQL formatting with configurable dialect and style	Jun 15
#93	Firebird, RQLite, Turso, TDengine dedicated adapters	Jun 15
#94	Visual query execution plan as structured tree with cost highlighting	Jun 16

Related Issues (closed)

• Feature: Complete Explain Query UX with Result Display #50 Explain Query UX · Support 30+ SQL databases via protocol aliasing, ODBC/HTTP bridges, and native drivers #57 30+ SQL Databases (Epic) · feat(settings): add AI provider configuration UI #59 AI Provider Config
• feat: SQL formatting with configurable dialect and style #64 SQL Formatting · feat: virtual-scrolled data grid with sort, filter, action-based editing, and copy #65 Virtual-Scrolled Data Grid · feat: inline row data search across all columns in table view #66 Inline Row Search
• feat: extend schema browser with views, procedures, functions, and enhanced table view with sub-pages #67 Extended Schema Browser · feat: visual query execution plan as structured tree with cost highlighting #68 Visual Explain Plan · feat: ER diagram visualizing table relationships with interactive canvas #69 ER Diagram
• feat: JDBC driver management for databases without Rust SDK #70 JDBC Driver Management · feat: multiple Monaco editor themes with settings selector #71 Monaco Editor Themes · feat: color-coded connections for visual environment identification #72 Color-Coded Connections
• feat: confirmation dialogs for UI destructive actions (data grid, sidebar) #73 Confirmation Dialogs · feat: HTTP proxy configuration for LLM provider connections #74 HTTP Proxy Config · feat: enhanced query history with filters, search, and management #75 Query History Enhancement
• Task 1: Wire-protocol compatible databases — Doris, StarRocks, Databend, QuestDB, and more #80 Wire-Protocol Databases · Task 2: JDBC bridge additions — Hive, Databricks, SAP HANA, BigQuery, Cassandra, Access and more #81 JDBC Bridge Additions · Task 3: New dedicated adapters — Firebird, RQLite, Turso, TDengine #82 Dedicated Adapters
• Phase 3.3: SSH Tunnel & Transport Layer Support #11 SSH Tunnel (Epic)

Auto-Test Coverage (406 tests, 72.84% line coverage)

Covered: Notifications, SQL parser, SSL validation, data table helpers (CSV/pagination/formatting), explain plan parsers (PostgreSQL/MySQL/SQLite/SQL Server/DuckDB/ClickHouse), connection store CRUD, app store (theme/editor/query config), database store, history store, tab store, SQL formatter, Tauri API wrappers, ER diagram rendering.

NOT covered by auto tests (manual testing required): SSH tunnel UI, JDBC driver mgmt UI, 30+ DB adapter connection flow, data grid virtual scroll/sort/filter/edit UI, AI assistant sidebar/task manager, transfer scope-based flow, HTTP proxy UI, explain plan frontend components, schema browser extended views, inline row search, confirmation dialogs, SQL formatting integration, color-coded connections, Monaco themes selector.

---

Manual Test Plan — 3 Scenarios, 32 Steps, 100% Feature Coverage

Scenario A: Full Query Lifecycle — "Connect any DB, run, evaluate, and polish a query"

Setup: Access credentials for at least one JDBC DB (e.g. Hive/BigQuery) and one native DB (e.g. PostgreSQL/MySQL), plus an SSH server.

• A1 — Open Settings → JDBC Driver Management. Verify: driver registry shows known drivers with versions. (covers feat: JDBC driver management with registry, fallback chains, and JRE auto-detection #87)
• A2 — Create a new JDBC database connection (e.g. Hive, Databricks, SAP HANA, BigQuery, Cassandra, Access). Verify: dropdown includes all 12 new JDBC entries; icons display correctly. (covers feat: add 12 new JDBC bridge databases (Issue #81) #90 feat: 30+ SQL databases via protocol aliasing, JDBC bridge, and native drivers #61)
• A3 — Create a new wire-protocol database connection (e.g. Doris, StarRocks, QuestDB, Databend). Verify: dropdown includes 9 wire-protocol entries; icons display correctly. (covers feat: add 9 wire-protocol-compatible databases (Doris, StarRocks, Databend, QuestDB, and more) #88)
• A4 — Create a new dedicated adapter DB connection (e.g. Firebird, Turso, RQLite, TDengine). Verify: connection succeeds; listed in browser. (covers feat: add Firebird, RQLite, Turso, and TDengine database adapters #93)
• A5 — Enable SSH tunnel for any connection (configure host/port/auth). Verify: SSH tunnel form works; connection status reflects transport layer. (covers feat: SSH Tunnel & Transport Layer Support (#11) #91)
• A6 — Connect both a native DB and a JDBC DB simultaneously. Verify: both show "connected" with distinct color-coding on connection tabs. (covers feat: color-coded connections for visual environment identification #72)
• A7 — Run SELECT * FROM large_table on a connected database. Verify: data grid renders with virtual scrolling, thousands of rows, no jank. (covers feat: virtual-scrolled data grid with sort, filter, action-based editing, and copy (#65) #89)
• A8 — Sort a column → filter by value → edit a cell → copy a row. Verify: sort works; filter narrows; edit commits; copy to clipboard works. (covers feat: virtual-scrolled data grid with sort, filter, action-based editing, and copy (#65) #89)
• A9 — Use inline row search in table view toolbar. Verify: data filters to matching rows as you type. (covers feat: inline row data search across all columns in table view #83)
• A10 — Delete a row in the data grid. Verify: confirmation dialog appears; confirm deletes row; cancel leaves unchanged. (covers feat: add confirmation dialogs for UI destructive actions (data grid, sidebar) #78)
• A11 — Run EXPLAIN [query] → click "Explain Plan" tab in result panel. Verify: explain plan panel appears with color-coded cost dots (green/yellow/red). (covers feat: visual query execution plan as structured tree with cost highlighting #94)
• A12 — Toggle explain plan views: Tree → Summary → Raw. Verify: tree shows expandable nodes; Summary shows flat table; Raw shows formatted JSON/text. (covers feat: visual query execution plan as structured tree with cost highlighting #94)
• A13 — Use SQL formatter (toolbar button or shortcut). Verify: selected SQL reformats per chosen dialect and style. (covers feat: add SQL formatting with configurable dialect and style #92)

Scenario B: Schema Intelligence + Data Transfer — "Explore, visualize, and export"

Setup: Connected to a database with tables, views, procedures, functions, and foreign key relationships.

• B1 — Expand a connection in database browser. Verify: browser shows grouped nodes — Tables, Views, Procedures, Functions. (covers feat: extend schema browser with views, procedures, functions, and enhanced table view with sub-pages #84)
• B2 — Click a table → browse sub-pages (Columns, Indexes, Foreign Keys, Triggers, DDL). Verify: each sub-page renders correctly. (covers feat: extend schema browser with views, procedures, functions, and enhanced table view with sub-pages #84)
• B3 — Click a View → browse its definition. Verify: view detail shows columns and DDL. (covers feat: extend schema browser with views, procedures, functions, and enhanced table view with sub-pages #84)
• B4 — Click a Procedure/Function → browse its DDL. Verify: DDL shows procedure/function source code. (covers feat: extend schema browser with views, procedures, functions, and enhanced table view with sub-pages #84)
• B5 — Click "ER Diagram" button in toolbar. Verify: canvas renders entity-relationship diagram with draggable table nodes; relationship lines connect keys. (covers feat: ER diagram visualization with interactive canvas #85)
• B6 — Zoom and pan on ER diagram canvas. Verify: zoom works; pan works; text remains readable. (covers feat: ER diagram visualization with interactive canvas #85)
• B7 — Open Transfer module → select "Data" scope → pick a connection and table(s). Verify: table selector allows select/deselect; scope options (Data/Schema) clearly separated. (covers feat(transfer): implement scope-based architecture for Transfer module #56)
• B8 — Configure export format (CSV/JSON/Excel) and destination folder → run transfer. Verify: transfer task starts; progress shows; files written to destination. (covers feat(transfer): implement scope-based architecture for Transfer module #56 feat: data studio agent and transfer improvements #62)
• B9 — Open Query History panel. Verify: history displays in reverse chronological order. (covers feat: enhanced query history with filters, search, and management #75)
• B10 — Use history filters and search to locate a past query → click re-run. Verify: filter works; saved query loads into editor and executes. (covers feat: enhanced query history with filters, search, and management #75)

Scenario C: AI-Assisted Workflow — "Configure, chat, task, and customize"

Setup: An AI provider configured (e.g. OpenAI-compatible endpoint).

• C1 — Open Settings → AI Providers. Verify: provider list is configurable; multiple providers can be set. (covers feat(settings): add AI provider configuration UI #60)
• C2 — Open Settings → Agent → configure HTTP proxy for LLM. Verify: form accepts proxy URL; saves correctly. (covers feat: HTTP proxy configuration for LLM provider connections (#74) #77)
• C3 — Open AI Assistant sidebar (toggle in toolbar or sidebar switcher). Verify: sidebar slides in from right; conversation UI renders. (covers feat: AI assistant sidebar, task manager, agent config, provider alignment with Dockit #63)
• C4 — Ask AI: "List all tables containing 'user' in this database". Verify: AI agent generates and executes SQL; results show in conversation. (covers feat(data-studio): implement AI-powered Data Studio agent #58)
• C5 — Ask AI for a complex query involving JOIN and GROUP BY → click Run. Verify: SQL inserted into editor; executes; results display normally. (covers feat(data-studio): implement AI-powered Data Studio agent #58 feat: data studio agent and transfer improvements #62)
• C6 — Open Task Manager (sidebar or toolbar toggle). Verify: task panel shows current/past runs with status. (covers feat: AI assistant sidebar, task manager, agent config, provider alignment with Dockit #63)
• C7 — Open AI Assistant and Task Manager side-by-side. Verify: side panels coexist without overlap; layout correct. (covers feat: AI assistant sidebar, task manager, agent config, provider alignment with Dockit #63)
• C8 — Go to Settings → Appearance → change Monaco editor theme. Verify: editor updates to selected theme (e.g. monokai, github-dark). (covers feat: multiple Monaco editor themes with settings selector #71)
• C9 — Toggle UI language (English ↔ Chinese) and check AI sidebar, Settings, Transfer pages. Verify: all labels translate correctly; no untranslated placeholders. (covers global i18n)

---

Coverage Summary

Metric	Count
Manual test scenarios	3
Total test steps	32
PRs/features covered	20/20 (100%)
Releases covered	v0.5.4 → v0.6.1
NOT in manual scope (auto-tested)	Notifications, SQL parser, SSL validation, data table helpers, explain plan parsers logic, connection/app/database/history/tab store CRUD, ER diagram rendering, Tauri API wrappers, SQL formatter logic

Known Rust Build Warning (pre-existing)

cargo test in src-tauri/ has 4 compilation errors in test code (missing fields maven_classifier and verify_host_key in initializers). These are test-code issues only — the library and binary build clean. Fix tracked in related adapter PRs.