An open-source desktop client for MySQL, PostgreSQL and SQLite — run your queries straight on your own machine. No cloud, just fast, visual SQL.
ONE WORKSPACE. YOUR DATABASES.
STAY IN YOUR FLOW
That query in your head. That table you need to find. That answer hiding in your data. A thoughtful workspace puts it all within reach.
From a question to an answer.
Write with schema-aware suggestions, run with one shortcut, and keep your best queries close. No extra tools required.
Find the story in your data.
Go from rows to charts without leaving your results. Sort the details, see the pattern, and take the answer with you.
The bigger picture, right in front of you.
Browse your tables and follow the connections between them. Get to know a new database without getting lost.
01 / WRITE & RUN
Write SQL at the speed you think. Schema-aware suggestions, a real CodeMirror editor, and results one shortcut away.
Meet your new editor
-- A good question deserves a quick answer.SELECT name, email, created_atFROM customersORDER BY created_at DESCLIMIT 3;| name text | email text | created_at date |
|---|---|---|
| Alex Morgan | alex@example.com | 2026-10-14 |
| Sam Rivera | sam@example.com | 2026-10-13 |
| Jordan Lee | jordan@example.com | 2026-10-12 |
02 / FIND THE STORY
A table for the details. A chart for the bigger picture. Column stats for everything in between. Your results, however you need them.
| # | month text | orders integer | revenue numeric | trend |
|---|---|---|---|---|
| 01 | May | 142 | $24,800.00 | |
| 02 | June | 186 | $32,400.00 | |
| 03 | July | 204 | $38,200.00 | |
| 04 | August | 268 | $47,600.00 | |
| 05 | September | 310 | $56,100.00 | |
| 06 | October | 372 | $68,400.00 |
REVENUE
$267,500.00ROW COUNT
6Every month accounted forTOTAL REVENUE
$267.5kAcross the result setAVERAGE
$44.6kRevenue per monthMIN / MAX
$24.8k / $68.4kThe range at a glanceLess exporting to another app. More getting on with your work.
03 / CONNECT THE DOTS
A new database shouldn’t feel like a maze. Explore tables, inspect columns, and follow foreign keys in a visual map of your schema.
LOCAL IS A FEATURE
Your machine talks directly to your database. Your credentials live in the OS keychain. Your queries belong to you.
Read the security model
MamaSQLYOUR DEVICENative drivers. No cloud relay between you and your database.
No tracking of your queries, schemas, or how you work.
No sign-in screen standing between you and your data.
Reach your local database. Keep working without the internet.
THE SMALL THINGS ADD UP
Fewer detours. Fewer open apps. The everyday essentials are already part of your workspace.
A command palette that gets you to tables, queries, and actions without breaking stride.
Search your query history and keep your go-to SQL close with saved snippets.
Multiple connections, tabs, and split views. Compare without the window juggling.
Export results to CSV, JSON, Markdown, or SQL. Ready for whatever comes next.
Edit cells inline. Create and alter tables visually. Stay close to the data you’re working on.
SELECT what_you_need
FROM your_database;A considered dark theme or a fresh light one. With syntax that makes your SQL easy to read.
NO ONBOARDING ODYSSEY
Download the Windows app, or run the browser build with Docker.
Get MamaSQL ↗Connect to PostgreSQL or MySQL, or open a local SQLite database.
Connect a database ↗Browse your schema, write your SQL, and let the results do the talking.
Find your flow ↗BUILT IN THE OPEN
MamaSQL is an independent, open-source project. Here’s where it’s headed. These features are on the roadmap, not in the app yet.
Run saved queries on a schedule, with automatic exports and alerts when your results change.
See what changed, compare your scripts, and restore a previous version when you need it.
Extend your workspace with extra exporters, custom cell renderers, themes, and integrations.
Native connectors for Microsoft SQL Server and Oracle alongside the engines you already use.
Query Snowflake and BigQuery from the same workspace as your local databases.
Explore MongoDB, Redis, and more with a navigable view of documents and keys.
Yes. MamaSQL is open-source under the MIT licence and free for personal and commercial use. No licence key, subscription, or account required.
PostgreSQL, MySQL, and SQLite are supported. Wire-compatible engines include MariaDB, CockroachDB, and Amazon Redshift.
The native app connects directly to your database with no MamaSQL cloud relay and no telemetry. Remote databases receive the queries you send them. The Docker browser build uses its own local bridge for PostgreSQL and MySQL.
Yes. There’s no cloud account or sign-in dependency. As long as your database is reachable, you can keep working, including with a local SQLite file.
The native app is available for Windows. On macOS and Linux, run the browser build with Docker. See the download page for the available options.
Absolutely. Explore the source on GitHub, report an issue, suggest an improvement, or send a pull request. A star or sponsorship helps support the project, too.
YOUR NEXT GOOD QUERY STARTS HERE
Your data. Your machine. A workspace that gets out of the way.