Introduction
MamaSQL is a local-first SQL client for MySQL, PostgreSQL and SQLite. It pairs a fast, schema-aware editor with a schema explorer so you can connect, query and inspect your data — all from a single desktop app that runs entirely on your machine.
Overview
At its core, MamaSQL does three things well: it connects to your databases, it helps you write SQL quickly, and it shows you results without getting in the way. There's no cloud relay, no account, and no telemetry — everything happens locally.
- Connect to MySQL, PostgreSQL and SQLite
- A CodeMirror-based editor with schema-aware autocomplete
- A schema explorer for tables, views, columns and relationships
- Read results as a table, chart or per-column stats — and export to CSV, JSON, Markdown or SQL
Why local-first
Most database GUIs route your queries — and sometimes your credentials — through their own infrastructure. MamaSQL doesn't. Your connections live in your operating system's keychain, queries run directly from your machine to your database, and the app works fully offline.
Nothing leaves your device. Read more in the Connecting databases guide.
Supported databases
Three engines, each with a bundled, zero-config driver behind one unified interface:
| Engine | How it connects | Notes |
|---|---|---|
| PostgreSQL | via the engine bridge | host / port connection |
| MySQL / MariaDB | via the engine bridge | host / port connection |
| SQLite | local, in the app | a real local database — no server |
Where to next
Ready to try it? Head to Installation, then run through the Quick start to connect and run your first query.