Local-first desktop SQL client for Windows

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.

Windows 10 & 11 (64-bit)•No account required•100% offline normal use
Lopo Studio desktop application interface showing interactive dashboards with Donut, Bar, Line charts, KPI metric cards, and multi-engine explorer
Direct Local Execution

Queries execute straight over local loopback sockets or standard TCP without middleman services.

Windows Credential Vault

Database passwords and SSH key passphrases are stored in Windows Credential Manager.

Dashboards & Charts

Multi-widget dashboards with Donut, Bar, Line, and KPI cards, live sorting, and 1-click PNG exports.

Ten Proven Engines

Built-in support for Supabase, PostgreSQL, MySQL, MariaDB, SQL Server, ClickHouse, CockroachDB, TiDB, SQLite files, and embedded DuckDB.

LOCAL-FIRST BY DESIGN

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.
You stay in control of your connections, saved queries, and workspace data.
Supported Engines

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.

Analytical Engine

ClickHouse

Connect directly to ClickHouse over HTTP. Run fast analytical queries at scale, inspect EXPLAIN plans, and stream massive CSV datasets.

Native HTTP querying & streaming CSV import
Distributed SQL

CockroachDB

First-class connection support with schema navigation, distributed table introspection, and safe data browsing.

Distributed SQL with native compatibility
Distributed HTAP

TiDB

Connect to PingCAP TiDB over standard MySQL protocol. Query hybrid transactional and analytical workloads at scale with zero configuration.

Distributed HTAP & MySQL protocol compatibility
Cloud Postgres

Supabase

Direct connection with 1-click URI parser, Session (5432) and Transaction (6543) pooler presets, and native TLS pooler certificate support.

Native Postgres & 1-click pooler connection
Database

PostgreSQL

Introspection of schemas, types, JSONB fields, triggers, and indices with low-latency direct execution.

Standard TCP & local sockets
Database

MySQL

Fast multi-query execution, session parameter inspection, and direct connection support.

Native MySQL protocol with SSL/TLS
Database

MariaDB

Connect directly to MariaDB servers with schema browsing, safe table editing, and dialect-aware query tools.

MySQL-compatible server with native support
Database

SQL Server

Work with Microsoft SQL Server over TCP or connect to a local Windows LocalDB instance with integrated authentication.

TCP and Windows LocalDB connections
Embedded File

SQLite

Instant database creation and query execution on local .db, .sqlite, or .sqlite3 files.

Direct file access, zero server setup
Embedded Engine

DuckDB

Embedded columnar SQL engine for analytical queries on local DuckDB database files and imported tables.

Fast queries on local analytical files
Features

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.

Live App Preview

Turn raw SQL queries into presentation-ready visuals in seconds.

1-Click PNG Export • Live Auto-Refresh
360° Donut Charts

Center aggregate totals, color-coded swatches, and automatic grouping of slices beyond top 7 into an Other (X) segment.

Bar Rankings & Top-N

Live in-chart sorting (High ⇄ Low) without re-executing queries, plus Top 10, 25, 50, and All range filters.

Time-Series Trends

Plot chronological trends, daily revenues, and metrics with auto-formatted dates and cursor-following tooltips.

KPI Metric Cards

Display large headline numerals, subtitle aggregates, and exact counts directly extracted from query results.

Free Trial vs. Founder License

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

Core SQL Client
$0
Free forever after 7-day full preview

Perfect for learning SQL, running ad-hoc queries, and visual analytics without time limits or forced subscriptions.

Included Free Forever:
  • 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
Locked After 7-Day Preview:
  • 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
Recommended

Founder License

Lifetime Unlock
$49$69with code FOUNDER
One-time payment • No subscription • 14-day refund window

Permanently unlocks all Productivity Features at the native Rust engine layer, plus lifetime software updates on your desktop and laptop.

Everything in Free, plus all 5 Productivity & Advanced Tools:
  • 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
14-day money-back guaranteeRefund terms
Detailed Reference

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 FeatureFree (After Trial)Founder LicenseDescription
1-Click Smart Mock Test Data Generator Locked UnlockedSynthesizing 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 UnlockedCreating, modifying, and saving visual dashboards. Pinning and configuring query widgets (KPI metrics, Donut, Bar, Line).
JSON Query Result Exports Locked UnlockedExporting query results as structured JSON files. (Note: CSV result export remains 100% free!)
Local Database Backups & Point-in-Time Restore Locked UnlockedManual snapshot creation and safety restore for local SQLite and DuckDB databases. Automated background file snapshot engine.
Server Database SQL Backups & Restore Locked UnlockedGenerating portable SQL dumps and restoring server databases (PostgreSQL, MySQL, MariaDB, SQL Server).
Founder License•One-time purchase

Founder License — $69 $49 USD

Founder launch priceUse codeFOUNDERto save $20

One payment. Lifetime access and product updates. Includes full Lopo Studio desktop client access, all future updates, and engine optimizations with zero recurring subscription fees.

No subscription Lifetime product updates No account required14-day refund policy
Pricing Details & FAQ

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)