See Everything at a Glance
Track your query performance in real-time. No guesswork, just clarity.
15010050
AprJulOct
Local-first SQL for power users
An open-source desktop client for MySQL, PostgreSQL and SQLite — run your queries straight on your own machine. No cloud, just fast, visual SQL.
Engineered strictly for power users
Every query is tracked in detail — from inputs to results to runtime errors. Perfect for debugging and transparency.
A SQL editor that
keeps up with you
Schema-aware autocomplete, instant formatting, and one-keystroke runs. Built on CodeMirror and tuned for speed.
- Schema-aware autocomplete
- One-keystroke run ⌘↵
- Format & lint as you type
- Multiple cursors & selections
-- Top customers by revenue this quarter
SELECT
c.name,
c.email,
COUNT(o.id) AS orders,
SUM(o.total) AS revenue
FROM customers c
JOIN orders o ON o.customer_id = c.id
WHERE o.created_at >= '2026-01-01'
GROUP BY c.id
ORDER BY revenue DESC
LIMIT 10;
| name | orders | revenue |
|---|---|---|
| Acme Corp | 142 | $48,200 |
| Globex Inc | 118 | $39,540 |
| Initech | 97 | $31,180 |
● 10 rows · 12 ms
Schema explorer
Your whole schema,
Your whole schema,
at a glance
Browse tables, columns and relationships visually. Click any table to inspect its rows, keys and foreign keys — no SQL required.
- Tables, views & columns in a live tree
- Foreign-key relationships drawn for you
- Indexes, types & constraints at a glance
Up and running in three steps
No setup wizard, no cloud account — connect and start querying in minutes.
-
01
Connect
Add a MySQL, PostgreSQL or SQLite connection. Credentials are stored locally and never sent anywhere.
-
02
Explore
Browse tables, views, columns and relationships in the schema sidebar — no SQL required.
-
03
Query
Write SQL with autocomplete, run it instantly, and export results to CSV or JSON.
A complete SQL workspace
Beyond the editor, MamaSQL bundles the tools you reach for every day — no plugins, no setup, no sign-in.
-
Command palette
Jump to any table, query or action with ⌘K — no mouse required.
-
Query history
Every query you run is saved automatically and fully searchable.
-
Saved snippets
Keep your go-to queries one keystroke away, per connection.
-
Tabs & split views
Open multiple connections at once and compare results side by side.
-
Export anywhere
Send any result set to CSV or JSON, or copy straight to your clipboard.
-
Light & dark themes
A polished dark UI with One Dark syntax highlighting — or flip to light.
Your whole database, laid out clearly — browse every table, trace each relationship, and run any query, all running privately on your own machine.
Local-first
Your data never
Your data never
leaves your machine
MamaSQL talks to your databases directly. No cloud relay, no telemetry, no account required — your queries and schemas stay on your device.
Read our security model-
Direct connections
Queries go straight from your machine to your database — never proxied through our servers.
-
Zero telemetry
We don't track your queries, schemas, or usage. What you run stays yours.
-
Encrypted by default
Native SSL/TLS support for secure connections to your remote databases.
-
Runs fully offline
No account, no sign-in. Download, connect, and query — even with no internet.
Query Like You Think
Write and connect queries to build logic that mirrors how your brain works.
Total queries
3,600 +10.4%
Last 7 days
Failed Query
249 +23%
Successful Query
3,812 +6%
Average query time
5.4s -51%
-
Performance Tracking
Track query performance, timing, and results without digging through logs.
-
Real-Time Syncing
Keep your schema, tables, and query history always in sync.
-
Intelligent AI Queries
Just describe what you need — MamaSQL generates the SQL instantly.
-
Schema Mapping
Design and organise your database like a visual blueprint - simple but powerful.
Built for speed
The shortest path to your data
No cloud relay, no proxy, no waiting. MamaSQL talks to your database directly with native drivers — your queries take the fastest route from keystroke to result.
SQL SELECT customer, SUM(total) … GROUP BY customer
One result set,
One result set,
every way to read it
Run any query and turn the result into a sortable, editable table, a bar/line/pie chart, or per-column stats — then export to CSV, JSON, Markdown or SQL. One workspace, no copy-paste.
What's under the hood:
- 0 Database engines
- 0 Tests passing
- 0% Local-first
Engineered
strictly
for power users
Every query is tracked in detail - from inputs to results to runtime errors. Perfect for debugging and transparency.
Explore reporting toolsConnect with MySQL, PostgreSQL and SQLite. MamaSQL plugs into your databases and tools without friction.
Explore integrationsTailor every query to your schema. Build, branch, and run logic exactly how you need it.
Explore the editorReal SQL
for control freaks
For developers who want their database tools fast, local, and entirely under their own control — no cloud, no account, no telemetry. Here's what they're saying.
Get started too
Maya Okonkwo
@mayabuilds
Postgres at work, MySQL for a side project, a SQLite file for tests — all in one @mamasql window now. Finally stopped juggling three different clients.
Daniel Reyes
@drey_dev
Opened a 200k-row table in @mamasql and it just streamed straight in. No spinner, no telemetry, no account. Like TablePlus that respects your CPU and your privacy.
Priya Nair
@priyawrites
debugging sqlite migrations with schema-aware autocomplete is way too smooth. everything runs locally — no cloud, just my data and me 🙌
Tom Becker
@tombeck
connected my local Postgres and the schema tree + ER diagram mapped every foreign key in seconds. onboarding to a new database has never been this fast.
Sofia Marchetti
@sofia_sql
two minutes from download to my first query. connect → write SQL → export to CSV. @mamasql quietly replaced pgAdmin in my workflow.
André Silva
@andre.builds
ran a query, flipped to the chart view, had a revenue breakdown in 10s — no exporting to a spreadsheet. and it's fully open source 🖤 @mamasql
Works with the databases you already use
- PostgreSQL
- MySQL
- SQLite
- MariaDB
- CockroachDB
- Amazon Redshift
On the roadmap
Open-source and shipping as it's ready — here's what's coming next. None of it is live yet.
-
Next
Scheduling
Run a saved query on a schedule — auto-export the results to a file or get alerted when something changes.
-
Next
Version history
A git-style timeline for every script — diff what changed and restore any previous version in a click.
-
Planned
Plugin marketplace
Extend MamaSQL with community plugins — extra exporters, custom cell renderers, themes and integrations.
-
Planned
Enterprise engines
Native connectors for Microsoft SQL Server and Oracle, alongside the databases MamaSQL already speaks.
-
Exploring
Cloud warehouses
Query Snowflake and BigQuery right next to your local databases — one client for everything.
-
Exploring
NoSQL
Browse MongoDB, Redis and more — documents rendered as a navigable JSON tree, not raw text.
Frequently asked questions
Everything you might want to know before you install.
Yes. MamaSQL is open-source and free to use for personal and commercial projects. Download it, connect, and start querying — no licence key and no account required.
MySQL, PostgreSQL and SQLite out of the box — plus wire-compatible engines like MariaDB, CockroachDB and Amazon Redshift.
No. MamaSQL is local-first: queries run directly from your machine to your database, credentials live in your OS keychain, and there's zero telemetry.
Absolutely. There's no sign-in and no cloud dependency. As long as you can reach your database, MamaSQL works — even with no internet at all.
macOS, Windows and Linux. Grab a build from the download page or install it with Homebrew, winget or the Linux script.