LiteMySQL is a fast, local-first MySQL client for macOS and iOS. Multi-tab SQL editor, SSH tunneling, CSV/JSON export, and Keychain-backed credentials — all in a tiny 8 MB binary.
| referrer_domain | hit_count | avg_duration |
|---|---|---|
| github.com/trending | 8240 | 148.5s |
| news.ycombinator.com | 5192 | 210.2s |
| google.com | 3480 | 85.1s |
LiteMySQL is a focused, native client — no Electron bloat, no half-supported engines. Just MySQL (and MariaDB) done well, on macOS and iOS.
Syntax highlighting, autocomplete, query history, and parallel execution across many tabs and connections.
Reach production MySQL behind a jump host without juggling separate terminal tunnels. Keys stay in Keychain.
Tree view across databases, tables, columns, indexes, and views — with filtering, sorting, and inline cell edits.
Ship any result set straight to CSV or JSON, ready for spreadsheets, scripts, or your next migration.
Define columns, types, defaults, and indexes through a clean visual editor — no DDL typos at 2 AM.
SwiftUI native on macOS and iOS — dark mode, light mode, and color accents that match your terminal setup.
LiteMySQL ships the daily tools real backend work actually needs — and skips the bloat. A focused editor, secure tunnels, fast exports, and frictionless connection management.
Open a tab per connection, write queries with MySQL-aware syntax highlighting and autocomplete, and run the highlighted region with one shortcut. Query history and favorites are saved locally.
SELECT
id,
email,
plan,
last_seen
FROM users
WHERE last_seen > NOW() - INTERVAL 7 DAY
ORDER BY last_seen DESC
LIMIT 50;Reach a MySQL instance behind a jump host without running a separate terminal. Password or key auth, with credentials encrypted in the system Keychain — never on disk in plaintext.
Ship any result set to CSV or JSON in one click — full result or just what you selected. UTF-8 safe, ready for spreadsheets, scripts, or your next migration step.
Paste a mysql:// URI and LiteMySQL parses host, port, user, password, and database for you. Save as many connections as you need — Pro removes the free cap entirely.
A focused MySQL workflow: connect once, live in the editor, export when you're done. No project setup, no telemetry, no account.
Paste a mysql:// URI or fill in host, port, user, and password. Turn on SSH tunneling with a single toggle. LiteMySQL stores credentials in the system Keychain — never on disk in plaintext.
What you getBrowse databases, tables, columns, indexes, and views in a single tree. Open a tab per workspace, write SQL with highlighting and autocomplete, and edit cells inline when you just need a quick fix.
What you getExport the whole result set or just your selection to CSV or JSON. Hand it off to a spreadsheet, a teammate, or your next migration script — without re-running the query elsewhere.
What you getYour queries, schemas, and connection details never leave your device. LiteMySQL doesn't ship analytics, crash uploads, or background reporting — there's nothing to opt out of.
Passwords and SSH keys are stored in the macOS / iOS Keychain, encrypted by the OS. They're never written to disk as plaintext in any config file.
Reach production MySQL behind a jump host without launching a separate terminal tunnel. Password or key auth, per-connection — no extra daemon required.
Shipped as a sandboxed Mac App Store app: signed, notarized, and confined to the resources it actually needs. No background processes, no kernel extensions.
Prices in USD via the App Store. Local pricing may vary by region. Mac and iOS each have their own subscriptions — or buy Lifetime once and use both.
Everything you need for personal projects and quick lookups.
For backend developers who live in MySQL every day.
One-time purchase — covers all future Pro updates.
Everything about LiteMySQL — pricing, platforms, SSH, and what's in Pro.
Yes — by design. LiteMySQL is a focused, native client for MySQL and MariaDB. We chose to ship one engine that works well rather than a generic GUI that half-supports five. If you also need Postgres, Redis, or MongoDB, this isn't the tool for you.