v0.14.0

What's Changed

Features

• Local file support: Added full integration for connecting to and querying local files (e.g., Excel, CSV) directly from the web app — including file upload, schema inspection, table preview, and SQL execution.
• Desktop file picker: Enabled native OS file selection in the Electron desktop app for seamless local file onboarding.

Improvements

• UI refinements: Tightened spacing and borders in connection dialogs and SQL result tables for improved visual consistency and clarity.
• Localization: Expanded i18n support with updated translations (English, Spanish, Japanese, Chinese) across MCP settings, API messages, and connection UI components.
• Open Files UX: Refined dataset isolation, sidebar labeling, and commit message generation logic for better discoverability and context awareness when working with local files.

Fixes

• Docker build reliability: Fixed an error in the Dockerfile that was preventing successful image builds.

Docs

• Updated README.md with self-hosting instructions and a dedicated section linking to full self-hosting documentation.

Internal

• Added a manual Docker release GitHub Actions workflow for controlled container publishing.
• Stabilized end-to-end CI tests, particularly the demo connection and SQL console flow.

v0.13.2-beta.2

What's Changed

UI Polish & Consistency

• Refined visual styling of connection dialogs and SQL result tables, tightening borders and improving alignment across desktop and web interfaces for a more cohesive user experience.

Local Files Support

• Expanded local file connection capabilities, including updates to the local files dialog, form schema, and driver configurations (SQLite, DuckDB) to improve reliability and usability when connecting to local data sources.

v0.13.2-beta.1

What's Changed

Features

• Desktop file picking for Open Files: Added native file selection support in the Open Files dialog on desktop (Electron) apps, enabling users to browse and pick local files directly from their filesystem.
• Enhanced Open Files dataset isolation: Improved separation of Open Files datasets in the SQL console sidebar, with clearer labeling and organization to avoid confusion between different local file sources.

Improvements

• Refined Local Files dialog: Updated UI and behavior of the Local Files dialog—including empty state, search, and connection cards—for better usability and consistency across workflows.
• Improved commit message generation: Enhanced logic for auto-generating meaningful commit messages in SQL editor and Explorer contexts, especially when working with local files and database objects (tables, views).
• Updated AGENTS instructions: Clarified setup guidance for using AGENTS in the Studio workspace, specifically within the Local Files flow.

Fixes

• Sidebar label accuracy: Fixed inconsistent or ambiguous labels in the SQL console and Explorer sidebars related to local files and connections.

Docs

• Self-hosting documentation: Added a dedicated section and link to self-hosting instructions in the root README.md.

Internal

• Dependency update: Upgraded better-auth from 1.5.6 to 1.6.2 to incorporate upstream security patches and stability improvements.

v0.13.2-beta.0

What's Changed

Features

• Added support for connecting to local files (e.g., CSV, Excel, JSON) as data sources — users can now upload, inspect, and query local files directly from the web interface.

Fixes

• Fixed a Docker build error in the Dockerfile, improving reliability of containerized deployments.

Improvements

• Updated documentation in README.md to reflect new capabilities and usage guidance.
• Added a manual Docker release workflow (docker-manual-release.yml) to streamline container image publishing.

Dependencies

• Upgraded @protobufjs/utf8 from 1.1.0 to 1.1.1.
• Upgraded protobufjs from 7.5.5 to 7.5.8.

v0.13.1

What's Changed

Improvements

• Simplified Docker image builds by removing the Yarn release dependency from the build process, reducing build time and complexity.

Fixes

• Ensured the Yarn release file is correctly included in the final Docker installer image, fixing potential runtime issues related to missing Yarn binaries.

Internal

• Updated .dockerignore to exclude unnecessary files during Docker builds, improving build efficiency and image hygiene.

v0.13.0

What's Changed

Features

• Added MCP (Model Context Protocol) server support: New API endpoints (/api/mcp/, /api/mcp/settings, /api/mcp/tokens) and UI controls in Settings enable secure agent access, token management, and MCP integration.
• Stable MCP port for desktop: Electron app now uses a consistent, predictable port for the local MCP proxy, improving reliability and user experience.

Improvements

• Enhanced AI analysis capabilities: Numeric fields are now accepted in AI analysis summary schemas, enabling richer charting and insights from query results.
• Refined SQL Console insights flow: Improved behavior and responsiveness of SQL Console features—including editor, sidebar, table browser stats, and schema introspection—across multiple database drivers and automation APIs.

Fixes

• Security hardening: Resolved security-related errors in Electron build and notarization scripts, and updated dependency configurations to address vulnerabilities.
• Vercel deployment fix: Corrected Yarn configuration (.yarnrc.yml, .yarn/releases/) to resolve installation failures during Vercel deployments.

Internal

• Monorepo refactoring: Moved significant portions of the web application logic into packages/* to improve maintainability and code reuse.
• Dependency updates: Upgraded Next.js (16.2.3 → 16.2.6), Kysely (0.28.15 → 0.28.17), and Mermaid (11.14.0 → 11.15.0) across apps and packages.

v0.12.3-beta.2

What's Changed

Improvements

• Stable MCP port for desktop: The Electron desktop app now uses a stable, consistent port for the MCP (Model Control Protocol) proxy, improving reliability and reducing connection issues during startup and agent communication.

Fixes

• Vercel deployment stability: Fixed an installation error that occurred when deploying to Vercel, ensuring smoother CI/CD workflows and successful builds.

Internal

• Updated Yarn lockfile and configuration to resolve dependency resolution conflicts introduced by recent tooling changes.

v0.12.3-beta.1

What's Changed

Features

• Added MCP server support: Introduced a new MCP (Model Control Protocol) server with API endpoints for managing MCP settings and tokens, including authentication and token lifecycle management.
• MCP token personalization: Refactored MCP token storage to be user-specific, improving security and isolation by moving tokens from shared to personal database tables.

Fixes

• Security hardening: Resolved critical security issues across the Electron app and core packages, including updates to notarization scripts and dependency configurations to address vulnerabilities.

Improvements

• Updated dependencies: Upgraded Next.js to v16.2.6 across all apps and packages, along with minor patches for kysely (v0.28.17) and mermaid (v11.15.0), improving stability and compatibility.

Internal

• Database migrations: Added new PostgreSQL and pglite migrations (0009_personal_mcp_tokens.sql) to support the personal MCP token schema change.

v0.12.3-beta.0

What's Changed

Features

• Added configurable initial user bootstrap login, enabling automated setup of a default admin or demo user during first launch (e.g., for local development or CI environments).

Improvements

• Refined SQL Console insights flow: improved rendering and behavior of AI-powered result analysis, chart suggestions, and summary cards — especially for numeric fields in analysis output.
• Split desktop and web authentication flows: introduced dedicated desktop-specific auth components and session handling logic, improving reliability and maintainability across platforms.
• Updated standalone app build script (build-app-standalone.sh) with fixes for runtime alias resolution and packaging consistency.

Fixes

• Fixed SQL Console result insights rendering issues caused by schema mismatches in AI analysis responses — now properly accepts numeric fields in summary payloads.
• Resolved inconsistencies in desktop auth login paths and session recovery synchronization.

Docs

• Updated README.md multiple times with clarifications on setup, authentication modes, and standalone app usage.

Internal

• Refactored codebase to move shared logic into packages/*, improving modularity and paving the way for better cross-app reuse and testing.
• Migrated numerous UI and domain modules (including chatbot, monitoring, table browser, and AI analysis utilities) out of apps/web into dedicated packages.

v0.12.2

What's Changed

Offline Desktop Authentication

• Added full offline support for desktop apps, including anonymous sign-in flow without network dependency
• Introduced desktop-specific auth session handling and recovery logic, decoupled from web session management
• Updated auth routes and UI components to support separate desktop login paths and runtime aliases

Copilot Stability Improvements

• Fixed a critical issue where DuckDB connections were incorrectly accessed during Copilot action execution, preventing crashes and improving reliability of SQL-related AI features (e.g., chart generation, query rewriting, optimization)

Initial User Setup

• Added configurable bootstrap login for the initial user via environment variables (e.g., INIT_USER_EMAIL, INIT_USER_PASSWORD), simplifying onboarding in self-hosted and local development environments

UI & UX Fixes

• Fixed rendering of result insights in the SQL console to ensure accurate display of AI-generated analysis and recommendations

Documentation & Tooling

• Updated README.md with new setup instructions and clarifications around offline mode and init user configuration
• Refined standalone desktop app build script (build-app-standalone.sh) for improved reliability and alias resolution

Internal

• Refactored authentication logic to cleanly separate desktop and web session lifecycles, including dedicated session proxies, recovery sync components, and locale-aware sign-in forms
• Standardized environment configuration and bootstrapping across Electron, web, and admin apps