A calmer way to work with SQL.
A fast, distraction-free desktop SQL client for ClickHouse, CockroachDB, TiDB, PostgreSQL, MySQL, MariaDB, SQL Server, 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 ClickHouse, CockroachDB, TiDB, PostgreSQL, MySQL, MariaDB, SQL Server, 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.
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.
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.
Direct Local Connections
Connections run directly from your Windows desktop to your database. No cloud accounts, no remote relays, no tracking.
Focused SQL Workspace
Use multiple query tabs, SQL completion, syntax highlighting, full-script execution, and an explicit selected-SQL action when you need it.
Visual Dashboard Canvas
Build customizable visual dashboards alongside your query tabs. Combine Donut, Bar, Line, and KPI widgets with auto-refresh intervals and full-dashboard PNG export.
Interactive Charts & Rankings
Turn raw SQL query results into clean visuals in seconds. Horizontal bar rankings, live in-chart sorting (High ⇄ Low), Top-N limiters, 360° gap-free donut charts, and 1-click PNG exports.
Private Local AI Workspace
Optionally query local LLMs (Ollama, LM Studio) strictly over loopback. Zero cloud relay—credentials and database contents never leave your machine.
Data Browser & Safe Editing
Browse paginated tables, filter and sort rows, inspect structure, and make deliberate in-place edits backed by safe row identity checks.
Reliable Bulk CSV Import
Import local CSVs into PostgreSQL, MySQL, MariaDB, SQL Server (TCP & LocalDB), ClickHouse, DuckDB, or SQLite with type detection, table creation, and atomic batch transactions.
Data, Schema & SQL Exports
Export visible query results as CSV or JSON, generate table DDL, and save portable schema snapshots for review or version control.
Search Data & Map Relationships
Find a value across a schema, open matching rows, and view foreign-key relationships without having to memorize table names first.
Local Backups & Restore
Schedule SQLite and DuckDB snapshots, create portable PostgreSQL, MySQL, or MariaDB SQL backups, and save a safety copy before restoring.
Git-Aware SQL Workflow
Choose a repository, review changed files and diffs, stage selected work, and create local commits without leaving your database workspace.
Saved Queries & Query History
Keep reusable SQL close at hand and revisit past executions with timestamps and row counts—without storing connection passwords.
Read-Only Profiles & Local Security
Protect sensitive connections with read-only mode while database passwords and SSH passphrases stay in Windows Credential Manager.
SSH Tunnel Support (Experimental)
Connect to remote databases behind bastion hosts using local port forwarding with password or private key authentication.
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 9 database engines (ClickHouse, CockroachDB, TiDB, Postgres, MySQL, MariaDB, SQL Server, SQLite, DuckDB)
- Monaco SQL editor with autocomplete, script execution, and multi-tab session restore
- Visual Dashboard Canvas (Donut, Bar, Line, KPI cards with live auto-refresh)
- Private Local AI workspace (Ollama & LM Studio via local loopback)
- Schema explorer, table definitions, and Windows Credential Vault security
- Visual table row editing & staging
- CSV & JSON result exports
- Streaming bulk CSV import wizard
- GUI table creation & dropping
- Automated & manual database backups
Founder License
Permanently unlocks all Productivity Features at the native Rust engine layer, plus lifetime software updates on your desktop and laptop.
- Visual Table Editing: In-place cell edits, adding rows, staging, and deletions without manual SQL
- Data Exports: Export query results and tables to CSV and JSON files
- CSV Import Wizard: Stream large CSV files with auto-generated tables into 6+ engines
- Visual Table Designer & Deletion UI: CREATE and DROP table dialogs directly from the GUI
- Database Backups & Automated Snapshots: Background file snapshots and point-in-time restores
- In-App Updates & Lifetime Releases: Direct in-app updates with zero renewal fees
What Features Are Locked Without a License?
Lopo Studio comes with a 7-day full-featured preview. Once the trial expires, the application locks the Productivity Features at both the UI and native Rust command layer:
| Locked Feature | Free (After Trial) | Founder License | Description |
|---|---|---|---|
| Visual Table Editing | Locked | Unlocked | Editing table rows directly in the Table Browser (inline edits, adding new rows, staging changes, row deletion) without writing manual UPDATE/INSERT/DELETE SQL. |
| Data Exports | Locked | Unlocked | Exporting query results to CSV or JSON files. |
| CSV Import Wizard | Locked | Unlocked | The bulk CSV importer that creates tables and streams data into SQLite, DuckDB, Postgres, MySQL, SQL Server, and ClickHouse. |
| Visual Table Creation | Locked | Unlocked | The GUI Table Designer dialog (CREATE TABLE) for adding columns, types, defaults, and primary keys. |
| Table Deletion UI | Locked | Unlocked | The right-click context menu action to drop tables from the schema sidebar. |
| Database Backups & Restore | Locked | Unlocked | Manual backup and point-in-time restore for local databases (SQLite, DuckDB) and server databases (Postgres, MySQL, MariaDB, SQL Server). |
| Automated Background Backups | Locked | Unlocked | The periodic background snapshot engine that auto-saves database files while connected. |
| In-App Automatic Updates | Locked | Unlocked | Direct-download in-app desktop updates check the active license/device certificate before downloading new versions. |
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.1.0)