Release Timeline · Latest v0.6.5 (2026-11-16)

SQLStudio Release Changelog

Grounded directly in CHANGELOG.md—from the v0.1.0 Honest Signals foundation through v0.6.5’s production-safe AI perf-tuning platform (local DEV+TEST twins, Zipf 100K seeding, 6 AST rules, ESR indexes, HMAC dual-gate & 32-tool MCP).

GitHub Releases
v0.6.5Latest
MCP & AISecurityDBA AuditUI & i18n

Production-Safe AI Database Performance Optimization & SQL Statement Tuning Platform

Current Release

Transforms SQLStudio into a production-safe database performance & SQL tuning platform: default PROD EnvMode read-only guard with slow bottleneck diagnostics, 1-click zero-PII local DEV+TEST twin cloning, 100K-row Zipf/skewed seeding + auto ANALYZE, 6-rule AST SQL rewriting + ESR+INCLUDE index advisor + Before/After EXPLAIN A/B benchmarks, HMAC-SHA256 dual-stage promotion ledger with 15-min single-use manual PROD approval, and 32-tool MCP expansion.

  • EnvMode & Slow Diagnostics

    Added `EnvMode::{Prod, Test, Dev}` defaulting to `Prod` (`read_only = true` enforced) with `linked_prod_id` lineage plus read-only `slow_diag` engine inspecting `pg_stat_statements` / `pg_stat_activity` / `performance_schema`, full-table `Seq Scan` offenders, dead-tuple bloat (`n_dead_tup`), stale stats, and Root Blocker lock trees.

  • Local DEV+TEST Twins & Zipf Seed

    Shipped `local_twin` (zero production disk usage, strips PII rows, clones DDL/FKs/indexes to embedded SQLite/DuckDB or loopback-only PG/MySQL) alongside `mock` batch seeder supporting `Uniform`, `HotspotZipf` (80/20), and `SkewedStatusTime` up to 100,000 rows/table with Kahn topological FK ordering and auto `ANALYZE`.

  • AST Rewriter, ESR & A/B Bench

    Implemented 6 deterministic AST SQL rewrite rules (`SARGABLE_DATE_RANGE`, `ARITHMETIC_PREDICATE_ISOLATION`, `NOT_IN_TO_NOT_EXISTS`, `OR_CONSOLIDATION_OR_UNION`, `KEYSET_PAGINATION_DEEP_OFFSET`, `IMPLICIT_CAST_AND_WILDCARD_OR_STAR`), `index_advisor` ESR+`INCLUDE` recommendations with absorbed redundant index detection & rollback DDL, and real `run_ab_sql_benchmark` Before/After EXPLAIN timing & disk-spill hotspot profiling.

  • 32-Tool MCP & Dual-Gate Ledger

    Expanded Full MCP from 26 to 32 tools (`diagnose_prod_bottlenecks`, `clone_prod_to_local_twin`, `seed_tuning_data`, `optimize_sql_statement`, `verify_sql_in_stage`, `request_prod_promotion`), persisted HMAC-SHA256 `promotion_verifications.json` proofs enforcing DEV + TEST passes plus a 15-minute single-use desktop manual grant, and synchronized USD-only Creem website & 5-locale rebrand.

v0.6.4v0.6.x
CommercialMCP & AISecurityDBA Audit

26-Tool MCP Governance, Apps, CLI Doctor, Schema Architect & Ed25519 Licensing + Deep Links

Expands Full MCP to 26 tools alongside Slim 4-tool mode, adds ui://sqlstudio/* MCP Apps, Governed Schema Architect same-grain conflict blocking, CLI Doctor/MCPB packaging, RFC 8032 Ed25519 offline licensing with a 7-day tamper-proof trial, USD-only Creem /checkout/success & /activate, and the sqlstudio:// license deep-link protocol.

  • sqlstudio:// Deep Links

    Added sqlstudio://license/activate?key=..., sqlstudio://license/import?token=..., and sqlstudio://license/start-trial deep-link routes with CLI handlers (`sqlstudio license open-url <url>`, `sqlstudio license register-protocol`), GPUI `app.on_open_urls(...)`, macOS Info.plist (`CFBundleURLSchemes=["sqlstudio"]`) & Windows HKCU registry support—strictly ignoring untrusted gateway params while preserving literal `+` characters.

  • Ed25519 Licensing & Creem USD

    Shipped pure-Rust RFC 8032 Ed25519 (SQLS1.) offline verification with Perpetual Fallback, HMAC-SHA256 7-day Pro trial, 7 FeatureGates, `sqlstudio license` CLI, Creem USD-only Cloudflare Worker gateway, and 1-Click "Activate in SQLStudio App" on /checkout/success & /activate.

  • Schema Architect

    architect_schema_blueprint inspects live schema first, enforces grain, unique_key, source, writer & refresh_cadence metadata, and blocks same-grain duplicates with merge/split guidance.

  • 26-Tool Surface

    Expanded Full MCP to 26 tools alongside Slim 4-tool mode, adding review_new_table (Merge / Add Column / Allow), saved queries, async jobs, lineage, index advisor, and sandboxed export.

  • MCP Apps & 2025-11-25

    Added 2025-03-26 / 2025-11-25 Resources (sqlstudio://...), Guided Prompts, and 4 interactive ui://sqlstudio/* MCP Apps (result-table, er-diagram, explain-plan, approval-card) with structured content fidelity.

  • CLI & MCPB

    Added sqlstudio mcp doctor [--strict], pure-Rust .mcpb bundle builder (pack-mcpb), secretless install-project, and 1-click Cursor/VS Code deeplinks.

  • Strict DDL & Diff Gate

    Enforced UNIQUE -> FK ON DELETE -> CHECK -> INDEX DDL ordering; preview_migration emits net diffs + apr-* tickets while query_sql blocks unpreviewed CREATE TABLE.

  • Enterprise Policy

    Added environment-aware prod_write_policy / staging_write_policy, per-connection mcp_visible filtering, column deny/mask policies, multi-client leases & OS Keychain Bearer auth.

v0.6.30.6.x
MCP & AISecurityDBA Audit

MCP Workflow Upgrade, PII Precision & PostgreSQL Tuning

Upgraded use_database with GUI target sync, exempted numeric aggregates like sum(gmv_fen) from false-positive PII masking, protected cold PostgreSQL indexes via insufficient stats, and fixed parallel EXPLAIN totals.

  • use_database

    Upgraded switch_database to use_database across Full & Slim profiles (keeping legacy alias), validating DB existence and syncing GUI state.

  • Zero-Popup apr-*

    Replaced confirm_token with single-use approval_id (apr-*) + inline Approve/Cancel controls and unified EXPLAIN ANALYZE routing.

  • PII Precision

    Exempted numeric aggregates such as sum(gmv_fen) from false-positive phone masking while strictly protecting phones, emails, national IDs, and bank cards.

  • Cold-Stats Guard

    Cold zero-scan PG indexes report insufficient stats with zero penalty; fixed parallel worker row totals and added persistent PostgreSQL search_path.

v0.6.2Security
SecurityMCP & AIUI & i18n

MCP RW Connection Policy & Zero-Trust Destructive SQL Gate

Upgraded default policy to Follow Connection RW/RO: strictly locks RO connections while gating DROP, TRUNCATE, unqualified writes, GRANT/REVOKE & Redis FLUSH* with fingerprinted apr-* tickets.

  • Follow RW/RO

    Defaulted MCP execution to Follow Connection RW/RO with config.toml hot-reload, allowing routine writes on RW while strictly locking RO connections.

  • Destructive Gate

    Intercepts DROP, TRUNCATE, unqualified DELETE/UPDATE, GRANT/REVOKE, and Redis FLUSHALL/FLUSHDB with single-use SQL-fingerprinted apr-* tickets.

  • Live Approval Bar

    Added global workspace MCP approval banner, 3-mode security selector, approval audit trail, and real-time sidebar schema sync across 8 locales.

v0.6.1Polish
UI & i18nDBA Audit

Dual-Sidebar Layout Polish & Honest 7-Engine Copy

Rebalanced Overview matrix column floors, telemetry bar spacing, and AI skill strip flex-wrapping under dual sidebars while calibrating 8-locale empty-state copy to the exact 7 native drivers.

  • Matrix Layout

    Raised audit/actions min-width to 236px with 772px horizontal scroll floor and locked WARN/HEALTHY badges outside truncating summaries.

  • Skill Strip Wrap

    Replaced horizontal clipping in #agent-skill-strip with flex_wrap() so all 7 AI skills fit cleanly without overflow clipping.

  • Honest 7-Engine Copy

    Aligned empty-source copy and 8-locale catalogs to accurately reflect the 7 built-in native drivers.

v0.6.00.6.x
UI & i18nMCP & AI

Commercial UX Polish & 8-Locale Precision

Added zero-friction AI onboarding banners clarifying offline static audits work without an API key, calibrated WCAG AA (>=4.5:1) contrast across both themes, and backfilled 8-locale precision.

  • AI Onboarding

    Added inline API Key / Pi sync setup banner plus explicit SELECT (Read-Only), DDL, and DML Write risk badges on SQL proposal cards.

  • Theme Contrast

    Calibrated Mineral Day and Obsidian Night palette tokens in theme.rs for >= 4.5:1 WCAG AA secondary-text contrast.

  • 8-Locale Catalogs

    Backfilled ja-JP and ko-KR trf! templates, verified 100% Big5 compatibility for zh-TW, and modularized 6 AI modules cleanly under 450 lines.

v0.5.3Engine
MCP & AI

Lossless High-Density MCP Semantic Engine (~55% Token Savings)

Eliminated mid-payload clipping: exports 100% of columns, constraints, indexes & incoming child FKs at ~55% fewer tokens than Markdown, with 1-hop FK matching and null_cols/const_cols factoring.

  • Zero-Truncation DSL

    inspect_schema and describe_table encode 100% of columns, defaults, FKs, indexes & incoming blast radius in dense notation (~55% fewer tokens).

  • Factoring & 1-Hop

    Automatic null_cols:/const_cols: factoring and lossless JSON minification in query_sql, plus automatic 1-hop FK neighbor matching.

v0.5.2i18n
UI & i18nMCP & AI

Atomic O(1) 8-Locale i18n Engine & Windows Config Fix

Upgraded to an O(1) atomic 8-locale engine with cross-platform CJK typography and resolved Windows os error 5 permission failures during IDE MCP config installation.

  • 8-Locale Engine

    Live switching across 8 regional locales with authentic database terminology, regionalizers, and PingFang/Hiragino/Malgun/Microsoft YaHei font stacks.

  • Windows os error 5

    Resilient Windows config writer clearing READONLY/SYSTEM attributes, fixing USERPROFILE home precedence, and stripping \\?\ verbatim prefixes.

v0.5.1Engine
MCP & AISecurity

MCP Token Economy & Bearer Auth Upgrade

Introduced Slim profile, KV-cache deterministic tool schemas, #hash schema deduplication, Token Budget Guard (1.5k..12k), live token telemetry, and 1-click sk-mcp-... Bearer token injection.

  • Token Economy

    Added --slim-tools context reduction, #hash if_none_match deduplication, live token telemetry & configurable 1.5k..12k token budgets.

  • Bearer Auth UX

    1-click Generate/Copy/Clear sk-mcp-... Bearer token controls with automatic Authorization header injection across JSON, TOML & YAML.

v0.5.0Milestone
MCP & AIUI & i18n

Dual-Transport MCP Server, 18 AI Clients & UI/UX Overhaul

Launched native STDIO and Streamable HTTP MCP server, backup-preserving 1-click installation across 18 AI clients, ⌘P Command Palette, and 7-module GPUI workbench UI overhaul.

  • STDIO + HTTP

    Built-in STDIO & Streamable HTTP MCP server with surgical .sqlstudio.bak installer across 18 AI clients plus Universal mcpServers export.

  • UI/UX Overhaul

    Unified >=10px typography floor, UTF-8 safe multiline editing, 2-click destructive confirmation, ⌘P Command Palette & adaptive modals.

v0.4.0Ecosystem
MCP & AI

20-Provider AI Registry & Pi Auth Sync

Added 20 cloud & local AI providers with models.dev metadata and 1-click local endpoint & API key sync from ~/.pi and ~/.opencode.

  • 20 BYOK Providers

    Integrated OpenAI, Anthropic, Gemini, DeepSeek, OpenRouter, OpenCode Go/Zen, Moonshot, Z.ai, MiniMax, xAI, Groq, Mistral, Ollama & llama.cpp.

  • Pi / OpenCode Sync

    One-click import of endpoints and keys from ~/.pi and ~/.opencode into the encrypted vault.

v0.3.0Architect
MCP & AIDBA AuditUI & i18n

Greenfield AI Schema Architect & Instant Seed Database

Introduced zero-to-one AI Schema Architect generating normalized DDL, blueprint audits, starter analytics SQL & mock seeds, plus 1-click e-commerce demo launchpad.

  • Schema Architect

    Zero-to-one modeling studio generating normalized DDL, blueprint health audits, starter analytics queries & realistic seed SQL.

  • Demo Launchpad

    Quick-launch presets and 1-click sample e-commerce SQLite database on empty workspaces.

v0.2.0Workbench
DBA AuditUI & i18n

Table Designer, Programmable Objects & SQL Lab Closed Loop

Added Visual Table Designer with Dry-Run rebuild preview, programmable objects introspection, and SQL Lab inline bar charts, snapshot diffs & manual transaction sandbox.

  • Table Designer

    Interactive column, constraint, index & FK builder with safe SQLite table rebuild and Dry-Run preview.

  • SQL Lab Analytics

    Inline result bar charts, pinned snapshot comparison diffs, multi-result tabs, parameter binding & transaction sandbox.

v0.1.0Foundation
DBA AuditSecurity

Multi-Engine Workbench, ER Map & Zero-Trust AI Foundation

Established native drivers across 7 engines, layered ER schema canvas, real FK orphan row checks, index health grading (A–E) & outbound AI PII redaction.

  • Honest Signals Core

    Native support for 7 engines + SSH/TLS, interactive ER topology, FK orphan checks, duplicate/unused index detection & A–E grading.

  • Zero-Trust Foundation

    Default read-only connections, encrypted .credentials.vault.json, AST validation & automatic PII redaction before LLM calls.