A calmer way to work with SQL.
A fast, distraction-free desktop SQL client for Supabase, PostgreSQL, MySQL, MariaDB, SQL Server, ClickHouse, CockroachDB, TiDB, SQLite, and DuckDB. Runs completely locally with direct sockets, OS credential vault security, and zero cloud requirement.

Queries execute straight over local loopback sockets or standard TCP without middleman services.
Database passwords and SSH key passphrases are stored in Windows Credential Manager.
Multi-widget dashboards with Donut, Bar, Line, and KPI cards, live sorting, and 1-click PNG exports.
Built-in support for Supabase, PostgreSQL, MySQL, MariaDB, SQL Server, ClickHouse, CockroachDB, TiDB, SQLite files, and embedded DuckDB.
Your data stays on your machine.
Lopo Studio is a desktop SQL client built for focused, local work. It does not require an account, a cloud workspace, or a constant internet connection to use your databases.
- •No account required — connect directly to ClickHouse, CockroachDB, TiDB, PostgreSQL, MySQL, MariaDB, SQL Server, SQLite, and DuckDB.
- •Your credentials stay local — database passwords and SSH key passphrases are stored in Windows Credential Manager.
- •No telemetry by default — Lopo Studio does not send your queries or database contents to our servers.
ClickHouse, CockroachDB, TiDB, PostgreSQL, MySQL, MariaDB, SQL Server, SQLite, and DuckDB.
Connect to local servers, containerized instances, or embedded file databases without proprietary connectors or cloud middleware.
ClickHouse
Connect directly to ClickHouse over HTTP. Run fast analytical queries at scale, inspect EXPLAIN plans, and stream massive CSV datasets.
CockroachDB
First-class connection support with schema navigation, distributed table introspection, and safe data browsing.
TiDB
Connect to PingCAP TiDB over standard MySQL protocol. Query hybrid transactional and analytical workloads at scale with zero configuration.
Supabase
Direct connection with 1-click URI parser, Session (5432) and Transaction (6543) pooler presets, and native TLS pooler certificate support.
PostgreSQL
Introspection of schemas, types, JSONB fields, triggers, and indices with low-latency direct execution.
MySQL
Fast multi-query execution, session parameter inspection, and direct connection support.
MariaDB
Connect directly to MariaDB servers with schema browsing, safe table editing, and dialect-aware query tools.
SQL Server
Work with Microsoft SQL Server over TCP or connect to a local Windows LocalDB instance with integrated authentication.
SQLite
Instant database creation and query execution on local .db, .sqlite, or .sqlite3 files.
DuckDB
Embedded columnar SQL engine for analytical queries on local DuckDB database files and imported tables.
Everything needed for everyday SQL work.
From visual dashboards and interactive query charts to Monaco-powered editing, safe cell mutations, and atomic bulk CSV imports.
Visual Dashboard Canvas & Query Charts
Turn SQL queries into Donut, Bar, Line, and KPI cards, and pin them directly onto customizable dashboards.
Turn raw SQL queries into presentation-ready visuals in seconds.
Center aggregate totals, color-coded swatches, and automatic grouping of slices beyond top 7 into an Other (X) segment.
Live in-chart sorting (High ⇄ Low) without re-executing queries, plus Top 10, 25, 50, and All range filters.
Plot chronological trends, daily revenues, and metrics with auto-formatted dates and cursor-following tooltips.
Display large headline numerals, subtitle aggregates, and exact counts directly extracted from query results.
Transparent licensing. No surprises.
Lopo Studio comes with a 7-day full-featured preview with all productivity tools unlocked. Once the trial expires, the core SQL workspace remains free forever. The Founder License permanently unlocks all productivity features with zero subscriptions.
Lopo Studio Free
Perfect for learning SQL, running ad-hoc queries, and visual analytics without time limits or forced subscriptions.
- All 10 database engines (Supabase, PostgreSQL, MySQL, MariaDB, SQL Server, ClickHouse, CockroachDB, TiDB, SQLite, DuckDB)
- Monaco SQL editor with autocomplete, script execution, and multi-tab session restore
- CSV Query Result Exports (CSV export remains 100% free forever)
- Table Browser, schema navigation, and direct data inspection
- Private Local AI workspace (Ollama & LM Studio via local loopback)
- Schema explorer, table definitions, and Windows Credential Vault security
- In-App Signed Automatic Updates & Upgrades
- 1-Click Smart Mock Test Data Generator
- Interactive Dashboards & Custom Canvas
- JSON Query Result Exports (CSV stays free)
- Local Database Backups & Point-in-Time Restore
- Server Database SQL Backups & Restore
Founder License
Permanently unlocks all Productivity Features at the native Rust engine layer, plus lifetime software updates on your desktop and laptop.
- 1-Click Smart Mock Test Data Generator: Synthesizing realistic test data directly into tables with column heuristics and batch preview
- Interactive Dashboards & Custom Canvas: Creating, modifying, saving dashboards, and pinning query widgets (KPI, Donut, Bar, Line)
- JSON Query Result Exports: Structured JSON exports for pipelines and API workflows (CSV remains 100% free)
- Local Database Backups & Point-in-Time Restore: Manual snapshot creation and automated background safety engine for SQLite & DuckDB
- Server Database SQL Backups & Restore: Generating portable SQL dumps and restoring PostgreSQL, MySQL, MariaDB, and SQL Server
Features Locked Behind the License (Productivity & Advanced Tools)
Lopo Studio comes with a 7-day full-featured preview. Once the trial expires, the following productivity and advanced features are locked without an active Founder License:
| Locked Feature | Free (After Trial) | Founder License | Description |
|---|---|---|---|
| 1-Click Smart Mock Test Data Generator | Locked | Unlocked | Synthesizing realistic test data directly into tables. Column heuristics (names, emails, UUIDs, dates, sequential IDs, currencies) and real-time batch preview. |
| Interactive Dashboards & Custom Multi-Widget Canvas | Locked | Unlocked | Creating, modifying, and saving visual dashboards. Pinning and configuring query widgets (KPI metrics, Donut, Bar, Line). |
| JSON Query Result Exports | Locked | Unlocked | Exporting query results as structured JSON files. (Note: CSV result export remains 100% free!) |
| Local Database Backups & Point-in-Time Restore | Locked | Unlocked | Manual snapshot creation and safety restore for local SQLite and DuckDB databases. Automated background file snapshot engine. |
| Server Database SQL Backups & Restore | Locked | Unlocked | Generating portable SQL dumps and restoring server databases (PostgreSQL, MySQL, MariaDB, SQL Server). |
Founder License — $69 $49 USD
FOUNDERto save $20One payment. Lifetime access and product updates. Includes full Lopo Studio desktop client access, all future updates, and engine optimizations with zero recurring subscription fees.
Fair Licensing FAQ
Why is Lopo Studio closed source?
Lopo Studio is closed source so we can sustainably maintain the desktop app, fund ongoing development, and offer a straightforward one-time license instead of requiring a subscription. We still build it local-first: your database connections, queries, and workspace data remain on your machine. Lopo Studio does not require a cloud account to use your databases.
Can I get a refund?
Yes. If Lopo Studio is not right for you, contact support within 14 days of purchase for a refund. A refunded license is no longer eligible for future activations, updates, or support.
Does Lopo Studio require a subscription?
No. The Founder License is a one-time purchase. One payment gives you lifetime access and all future product updates with zero subscription or renewal fees.
Download Lopo Studio
Windows 10 & 11 (64-bit) • Direct installer or Microsoft Store (v1.2.2)