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.

Explore 32 MCP Tuning Tools →
Default Safety
PROD RO + 2-Stage
MCP Surface
32 Tools · 18 IDEs
Local Twin + Seed
0 Prod Disk · 100K Zipf
SQL Tuning + Trust
6 AST · ESR · Ed25519
sqlstudio-workbench · v0.6.5 · PROD 🔒 Read-Only · pg_stat_statementsGPUI Native
Env Guard:PROD 🔒 ROBloat / Stats:n_dead_tup + Cold GuardScore Cap:74 / C
SQLStudio default PROD read-only workbench showing slow query diagnostics, bloat alerts & honest health caps

Every new connection starts in read-only PROD: detects pg_stat_statements / performance_schema bottlenecks, Seq Scans, dead tuples & Root Blockers.

EnvMode::Prod Locked
[ 01 // PERF DIAGNOSTICS & LOCAL TWIN MATRIX ]

12 Database Engines × 18 AI Clients · Ready for Safe Tuning

7 Native Drivers5 Dialect Probes18 MCP Clients
PostgreSQLPostgreSQLNative Driver—Read-only pg_stat_statements bottleneck scan, n_dead_tup bloat & cold-stats guard, ESR+INCLUDE advisor, loopback DEV+TEST twins & EXPLAIN (FORMAT JSON).
Click any engine to inspect
[ 02 // PRODUCTION-SAFE PERF TUNING CORE ]

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 RO · SLOW DIAGNOSTICS

Default PROD Read-Only Slow Scan & Score Caps

Total Score
74/ 100
Capped <= 74 (Critical)
Relationship Subscore58 (cap 68)
Index Subscore88 (cap 88)
pg_stat_statements: orders Seq Scan 142ms · n_dead_tup 21.4%EnvMode::Prod 🔒 RO
PG cold idx_scan = 0 -> insufficient stats (0 penalty · DROP suppressed)
HMAC DUAL-STAGE PROD GATE

DEV + TEST Verified -> Manual PROD Gate

BLOCKED (DEV ✓)
promotion_verifications.json · 15m single-usePENDING
CREATE INDEX idx_hot ON orders(tenant_id, status);
-- BlockedMissingStages: DEV ✓ verified, TEST pending
-- Unverified DDL cannot touch PROD
6-RULE AST REWRITE & ESR+INCLUDE

AST SQL Optimizer & A/B EXPLAIN

Actual Rows
142
Shared Hit
6 blks
Loops
1

A/B Speedup: 79.1x faster on 100K Zipf local TEST twin using Equality->Sort->Range + INCLUDE(total_cents).

LOCAL DEV+TEST TWINS · ZIPF 100K · DENSE DSL

Zero-PII Local Twins + Zipf Seeding + Dense 32-Tool DSL

Prod Disk / Tokens:0B Prod · 0 PII · -55% DSL
100K Zipf + ANALYZE in DEV/TEST
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)
Clones DDL/FKs/indexes to SQLite/DuckDB or strictly loopback PG/MySQLclone_prod_to_local_twin · seed_tuning_data
RFC 8032 ED25519 · SQLS1.

Ed25519 SQLS1. Offline License Engine

SQLS1.eyJ0aWVyIjoicHJvIiwibWFjaGluZSI6ImU0OWE3MWMyIn0.9aF2e...8c0ms Air-Gapped Verify
Tier
pro ($69 USD)
Machine FP
e49a...71c2
Updates Until
2027-11-16
Fallback
Perpetual
Compile-time trust root · 7-day no-card HMAC trial
ATOMIC O(1) 8-LOCALE ENGINE

Atomic O(1) 8-Locale Terminology Engine

+ zh-SG · en-SG (8/8)
local_twin
本地雙生庫
n_dead_tup
死元組膨脹
esr_advisor
ESR 覆蓋索引
env_mode
PROD 唯讀鎖
繁體中文 · 100% CP950/Big5-safe Traditional lexiconAtomicU8 · 0 Locks
[ 03 // PRODUCTION-SAFE TUNING LOOP ]

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.

step-01 · vault-connect
PROD Safe · Read-Only Scan
$ sqlstudio --mcp # tool: diagnose_prod_bottlenecks
[policy] EnvMode::Prod locked (read_only = true, 0 plaintext vault secrets)
[diag] pg_stat_statements: 3 top slow queries (> 140ms, 92% Seq Scan)
[bloat] orders: n_dead_tup=184,200 (21.4% bloat) | cold idx_legacy -> insufficient stats (0 penalty)
[locks] 0 blocking trees active | recommendation: clone_prod_to_local_twin
[ 04 // TRANSPARENT LICENSING ]

Start 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 Forever
$0USD forever

Free 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
$69USD one-time

$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 / mo

$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
Creem USD Checkout → Instant 1-Click Desktop Activation: Every Creem order displays your License Key right on /checkout/success with 1-Click "Activate in SQLStudio App" (sqlstudio://license/activate?key=...) and instant CLI copy.
[ 05 // TECHNICAL FAQ ]

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.

macOS (Apple Silicon & Intel) · Windows 10/11 (x64)

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.