Next-Gen Database IDE • Universal for Mac & Windows

Query once.
Engineer endlessly.

A high-performance, local-first database studio engineered for developers. Visual Table Designer, Live Excel Data Grid, DB Time Machine Snapshots, and JSONB Tree Editor in a breathtaking native interface.

Download for macOS (.dmg) Windows x64 (.zip)
🔒 100% Local-First & Private • ⚡ Apple Silicon & Intel • 🛡️ WebAuthn Touch ID & PIN Lock • 🚀 Zero Cloud Telemetry
0
Total Downloads
0
macOS Installs
0
Windows Installs
● 127.0.0.1:3306 (online)
▶ Execute (⌘ Enter) Format SQL Explain Query
✓ 2.1ms • 542 rows
SELECT u.id, u.username, u.email, u.role, COUNT(o.id) AS total_orders
FROM users u
LEFT JOIN orders o ON o.user_id = u.id
WHERE u.status = 'ACTIVE' AND u.created_at >= NOW() - INTERVAL 30 DAY
GROUP BY u.id
ORDER BY total_orders DESC LIMIT 10;
id username email role total_orders
1042 alex_dev alex@studio.io ADMIN 148
1043 sara_arch sara@fintech.net STAFF 94
📊 Smart Excel (.xlsx) / CSV Importer with Custom Type Mapping Row 1 Detected as Header
✓ Header (Row 1) Target Column SQL Type PK Sample Value
☑ user_id user_id BIGINT 🔑 PK 928104
☑ total_amount total_amount DECIMAL(10,2) - 150240.50
☑ created_at created_at DATETIME - 2026-09-22 14:30:00
Batch Insert Progress: 10,400 / 10,400 rows completed 100% Ingested
⏱️ Local DB Time Machine & Snapshots
Instant point-in-time checkpoints with protected biometric rollback
+ Capture Snapshot
● [Checkpoint] Pre-migration v2.4 Release
22 Sep 2026, 17:45:10 • 18 Tables • 42,100 Rows • Schema & Data
● [Checkpoint] Clean Initial Seed Data
21 Sep 2026, 09:12:00 • 18 Tables • 12,400 Rows
🌳 Rich JSON & JSONB Visual Tree Explorer
Filter: $.payload.auth Beautify 2 Spaces
▼ payload: {...} (3 items)
▼ user_profile: {...}
• display_name: "Kynan Lead Engineer"
• mfa_enabled: true
• biometrics: ["touch_id", "pin"]
• session_expires: 1792401820

Workspace Locked

Protected by PIN & Apple Touch ID / Windows Hello Biometrics. Zero cloud leak.

👆 Touch ID / Fingerprint Ready

Built for everything you engineer.

From lightning query execution and visual table design to local instant checkpoints and side-by-side data diffing. Everything runs native, offline, and secure.

Local DB Time Machine & Rollback

Capture 1-click schema and table data snapshots before running dangerous migrations, drop operations, or heavy updates. Protected with biometric Touch ID / PIN confirmation before rollback.

✓ Checkpoint "pre_migration_v2" saved (18 tables, 42.1k rows)
⚡ Rollback verified • Schema restored in 140ms

Biometric Lockscreen

Secure your active database connections and credentials with WebAuthn Touch ID, Windows Hello, or PIN lock with auto-idle timers.

⌘ + L to Lock Anywhere

Smart Excel & CSV Ingestion

Upload spreadsheets where row 1 is detected as column headers. Customize target SQL data types per column (`VARCHAR`, `INT`, `DECIMAL`, `DATETIME`, etc.), toggle Primary Keys, and stream in batches.

CREATE TABLE `customers` ( `id` INT AUTO_INCREMENT... );

JSON & JSONB Visual Tree Explorer

Explore nested documents with interactive collapsible trees, inline value mutation, JSONPath queries, and split-second formatting or minification in Code Studio.

$.orders[?(@.price > 100)].status

Row-Level Data Diff & Synchronizer

Compare tables between staging and production databases side-by-side. Highlights modified rows, missing inserts, and deletions, and generates ready-to-run sync SQL scripts.

+ INSERT INTO users ... (12 rows)
~ UPDATE users SET role = 'ADMIN' WHERE id = 1042;

Code Studio & REST Client

Multi-language scratchpad supporting SQL, Python, JavaScript, and PHP scripts, plus an integrated HTTP REST API client with zero context switching.

curl & SQL inside 1 IDE

Everything you need to know.

Straightforward answers about privacy, performance, and compatibility.

Yes! KynanSQL Studio is 100% free to download and use for both personal and enterprise commercial work. There are no subscriptions, paywalls, or feature limits.
100% locally on your machine. Passwords and SSH keys are encrypted using your operating system's native secure enclave and local storage. No connection info or queries are ever transmitted to any external server.
MySQL 5.7 & 8.x, PostgreSQL 10 through 17+, SQLite 3, MariaDB, and TiDB. All drivers are compiled into native Go binaries for high-throughput streaming.
Time Machine captures a high-speed atomic dump of table schemas and row contents into local encrypted checkpoint files. When executing a rollback, KynanSQL safely restores the exact table states and requests your PIN or Touch ID before execution.
Absolutely. When you select an Excel (.xlsx, .xls) or CSV file, KynanSQL detects row 1 as column headers and analyzes sample data to infer the best SQL data type. You can rename columns, change types to VARCHAR, INT, DECIMAL, etc., toggle Primary Keys, and preview the generated CREATE TABLE SQL before importing.
KynanSQL uses cryptographic Minisign digital signatures. When an update is deployed to your server endpoint, the client notifies you seamlessly with 1-click update support.