Production-safe AI database tuning & SQL optimization.
Not another connection-first DB browser. Default read-only PROD bottleneck diagnostics, 1-click zero-PII local DEV+TEST twin clones, Zipf 100K data seeding, 6-rule AST SQL rewriting + ESR indexes, A/B EXPLAIN benchmarks, and HMAC dual-gate promotion.

Every new connection starts in read-only PROD: detects pg_stat_statements / performance_schema bottlenecks, Seq Scans, dead tuples & Root Blockers.
12 Database Engines × 18 AI Clients · Ready for Safe Tuning
Six tuning primitives you can verify live.
No generic connection-client fluff. Toggle PROD read-only bloat scans, HMAC DEV+TEST dual-stage gates, 6-rule AST A/B benchmarks, zero-PII local twin clones + 100K Zipf seeding, and Ed25519 trust right here.
Default PROD Read-Only Slow Scan & Score Caps
DEV + TEST Verified -> Manual PROD Gate
CREATE INDEX idx_hot ON orders(tenant_id, status); -- BlockedMissingStages: DEV ✓ verified, TEST pending -- Unverified DDL cannot touch PROD
AST SQL Optimizer & A/B EXPLAIN
A/B Speedup: 79.1x faster on 100K Zipf local TEST twin using Equality->Sort->Range + INCLUDE(total_cents).
Zero-PII Local Twins + Zipf Seeding + Dense 32-Tool DSL
TWIN pg-dev (linked_prod_id=pg-prod, target=127.0.0.1:5432, pii_rows=0)
MOCK seed_tuning_data(dist=HotspotZipf 80/20, rows=100_000) -> 0 orphans, ANALYZEd
DSL T orders #a9c2 [100,000 rows] pk(id) fk(customer_id->customers.id)
in_refs: payments.order_id | const_cols: [currency="USD"] (-55% tokens)Ed25519 SQLS1. Offline License Engine
Atomic O(1) 8-Locale Terminology Engine
From PROD bottleneck scan to verified dual-gate promotion in 60 seconds.
Click each stage to inspect the synchronized 32-tool MCP invocation, local twin telemetry & HMAC ledger audit.
$ sqlstudio --mcp # tool: diagnose_prod_bottlenecksStart free. Own Pro forever with Perpetual Fallback.
Launch a 7-day full Pro trial with zero credit card. USD-only Creem checkout ($69 USD one-time Pro Perpetual, $15 / seat / mo Team billed annually) includes 1-click desktop activation.
Community
Free ForeverFree forever for evaluation & local workflows
Default PROD read-only workbench, base diagnostics & EXPLAIN trees, real orphan checks & Slim 4-tool STDIO MCP.
- Up to 2 saved connections across all 12 database engines (default PROD read-only guard)
- SQL Lab, EXPLAIN hotspot tree & static SQL lint rules
- Real orphan row checks, index redundancy/cold-stats guard & honest score caps
- Slim 4-tool STDIO MCP (use_database / inspect_schema / describe_table / query_sql)
Pro Perpetual
7-Day Free Trial$69 USD one-time via Creem · 1 yr updates · Perpetual Fallback forever
7-day no-card Pro trial; $69 USD one-time via Creem unlocks full local DEV+TEST tuning loop, 32-tool MCP & 2 devices.
- 1-click local DEV+TEST twin clone (0 prod disk, 0 PII) & 100K-row Zipf skewed seeder
- 6-rule AST SQL rewriting, ESR+INCLUDE index advisor & Before/After A/B benchmarks
- Full 32-tool MCP server (incl. 6 tuning tools), Streamable HTTP & 4 MCP Apps
- All 7 FeatureGates, 20 BYOK AI models, SSH tunnels, Schema Diff & encrypted backups
Team
Governance$15 / seat / month billed annually ($180 / seat / year via Creem)
HMAC-SHA256 DEV+TEST promotion ledger, mandatory PII column masking, Git SQL rules & enterprise vouchers.
- Everything in Pro, plus up to 5 device activations per seat
- HMAC-SHA256 DEV+TEST dual-stage ledger & 15-min single-use human PROD grants
- Mandatory PII masking & column-level deny/mask policies
- Git-synced shared Team SQL rules & Business Glossary
Architecture, MCP Security & Licensing FAQ
Every new connection defaults to EnvMode::Prod with read_only = true, running non-intrusive slow diagnostics (pg_stat_statements / performance_schema, Seq Scans, dead tuples & Root Blockers). Next, clone_prod_to_local_twin strips PII rows and clones DDL, FKs & indexes to local SQLite/DuckDB or loopback PG/MySQL bound via linked_prod_id, where seed_tuning_data populates up to 100K Zipf/skewed rows + ANALYZE. After 6-rule AST rewriting, ESR+INCLUDE indexing & Before/After EXPLAIN benchmarks pass on BOTH DEV and TEST (recorded in HMAC-SHA256 promotion_verifications.json), request_prod_promotion still pauses for a 15-min single-use desktop manual approval with rollback DDL.
Tune slow SQL on local twins. Promote to PROD with proof.
Download SQLStudio v0.6.5 native desktop or run sqlstudio mcp doctor to deploy all 32 governed tuning tools across 18 AI IDEs & CLIs.