An editable grid
Double-click to edit, multi-select rows, sort by any column, and drag column edges to resize. Edits collect as pending changes you review as SQL before you commit.
Ambry is an open-source desktop client for PostgreSQL, MySQL, and SQLite. Browse tables in an editable grid, run SQL, and inspect schemas — in one fast, keyboard-friendly app.
| # | id | customer | total ↓ | status | |
|---|---|---|---|---|---|
| 1 | 4821 | acme-corp | [email protected] | 1284.00 | paid |
| 2 | 4820 | globex | [email protected] | 942.50 | shipped |
| 3 | 4817 | initech | NULL | 773.20 | paid |
| 4 | 4809 | soylent | [email protected] | 512.75 | refunded |
| 5 | 4802 | umbrella | [email protected] | 318.00 | paid |
| 6 | 4788 | hooli | [email protected] | 96.40 | pending |
The same editor, grid, and schema tools across every connection — with the differences that matter handled underneath.
Full introspection, foreign keys, SSL modes, and SSH tunnels. Column names resolve even for empty tables.
Binary-protocol queries, index and key discovery, and the same connection options as Postgres.
Open a file and go. Pragmatic introspection through PRAGMA, no server required.
Everything you reach for in a day with a database — read, edit, query, inspect — in a tool that stays out of the way.
Double-click to edit, multi-select rows, sort by any column, and drag column edges to resize. Edits collect as pending changes you review as SQL before you commit.
Syntax-highlighted SQL with multi-statement execution. Run with ⌘↵, read results in the same grid, and pull from query history.
Columns, indexes, and foreign keys for any table, read straight from the live schema — not a cached guess.
SSL/TLS and SSH tunnels, groups and tags, safe mode, startup commands, and a live health check — saved as plain JSON you can read.
Postgres, MySQL/MariaDB, and SQLite behind the same grid and editor. When a connection has more than one database, switch between them in place.
Connections, history, and settings live under ~/.ambry as files you can read. Nothing phones home. MIT-licensed, source in the open.
Change a cell, insert a row, delete a few — every edit collects as a pending change and stays right there in the grid, marked in amber. When you’re ready, review the whole batch as the exact SQL it will run, then commit. You never issue a write you didn’t read first.
macOS on Apple Silicon. Install with Homebrew, or download the disk image directly.
Recommended — Homebrew clears the quarantine flag, so it launches clean.
Grab the disk image, mount it, and drag Ambry into Applications.
Download Ambry.dmg ↓Seeing a “damaged” warning on a direct download? Clear the quarantine flag once — the steps are in the docs.