GamaLabThe Postgres client your queries deserve.
Fast, elegant, AI-powered. Free, open source and local-first — a modern alternative to pgAdmin and DBeaver.
- MIT licensed
- No account
- No telemetry
- Local-first
- < 1 s cold start
- Bring your own AI key
- One-click Docker Postgres
- OS-keychain credentials
01Features
Everything a Postgres dev needs
Six reasons to open GamaLab instead of the tool you've tolerated for five years.
Query Editor
Monaco under the hood — multi-tab editing, PostgreSQL highlighting, autocomplete, one-shortcut formatting, saved queries.
1select p.id, p.text, u.name2from posts p3join users u on u.id = p.user_id4where p.created_at > now() - interval '7 days'5order by p.created_at desc6limit 100;Schema Explorer
Visual schema diagrams with foreign-key highlighting, plus a sortable, filterable result grid.
AI Assistant
Describe what you want in plain English — bring your own Claude or OpenAI key, with live cost display.
claude · openai · $0.0004
Docker in one click
Spin up a fresh Postgres container, experiment, tear it down. Databases as scratch pads.
postgres:16 · running
CSV Import & Export
Auto-mapped columns with a preview before import. Export any result set in a click.
users.csv → public.users · 12 cols mapped
Safe by default
Credentials encrypted with the OS keychain. Confirmation before DROP, TRUNCATE, or unscoped DELETE.
drop table orders — confirm?
02AI assistant
Describe. Execute.
GamaLab knows your schema. Describe what you want in English or French, and the SQL comes out with the right joins, the right types, the right indexes. No more SELECT * in an 11 pm Slack.
- 01
Bring your own key
Claude (Haiku, Sonnet, Opus) or OpenAI — you pick the model, you pay the provider.
- 02
No proxy, ever
Requests go straight to the provider. Keys are encrypted locally in your OS keychain.
- 03
Schema-aware, cost-aware
It reads your tables to write correct joins, and streams back with a live cost meter.
List users created this month with more than 3 sales.
$git clone github.com/garerim/gamalab.git
Cloning into 'gamalab'… done.
$cd gamalab && npm install
added 1 284 packages in 41s
$npm run dev
✔ GamaLab ready · electron 33 · vite 6
03Open source
Read the code. Own the tool.
GamaLab is fully open source. No account, no telemetry, no hidden backend — every line that touches your database is auditable on GitHub.
- MIT licensedUse it, fork it, ship it inside your company. No strings attached.
- Issues in the openBug reports and feature requests live on GitHub, where anyone can follow them.
- Contributions welcomeRead the contributing guide, open an issue to discuss, then send a PR.
04Comparison
Why GamaLab
Compared to the tools you already know.
| Criterion | pgAdmin | DBeaver |  GamaLab |
|---|---|---|---|
| Cold start | ~6 s | ~4 s | < 1 s |
| Modern design (Linear-like) | No | No | Yes |
| Integrated AI SQL Assistant | No | No | Yes |
| OS-encrypted credentials storage | partial | Yes | Yes |
| One-click Docker Postgres | No | No | Yes |
| Local-first (zero cloud) | Yes | Yes | Yes |
| Free & open source | Yes | Community ed. | MIT |
05FAQ
Frequently asked questions
Straight answers about price, privacy and what happens next.
Missing a question? contact@gamalab.dev
v1.0.0 · free forever
Open your database in a better lab.
85 MB, no account, no telemetry. Runs offline. Ready in under a second.