Your database,without the noise.
An open-source desktop client for PostgreSQL, MySQL, MariaDB and Cloudflare D1. A grid that works like a spreadsheet, and nothing runs that you did not mean to.
v0.3.2 · Free and open source

| # | idbigint | customer_idbigint | statusorder_status | totalnumeric | currencytext | created_attimestamptz | is_giftboolean | |
|---|---|---|---|---|---|---|---|---|
| 1 | 48213 | 1042 | Paid | 249.00 | USD | 2026-10-08 18:42 | false | |
| 2 | 48212 | 877 | Shipped | 1,180.50 | EUR | 2026-10-08 17:05 | true | |
| 3 | 48211 | 1311 | Pending | 64.90 | USD | 2026-10-08 16:51 | NULL | |
| 4 | 48210 | 1042 | Paid | 18.00 | USD | 2026-10-08 15:12 | false | |
| 5 | 48209 | 352 | Refunded | 310.25 | GBP | 2026-10-08 13:37 | false | |
| 6 | 48208 | 990 | Paid | 92.40 | USD | 2026-10-08 11:20 | true | |
| 7 | 48207 | 615 | Failed | 540.00 | EUR | 2026-10-08 09:58 | false | |
| 8 | 48206 | 1203 | Shipped | 75.10 | USD | 2026-10-07 22:14 | NULL | |
| 9 | 48205 | 877 | Paid | 2,045.00 | EUR | 2026-10-07 20:03 | false | |
| 10 | 48204 | 431 | Pending | 39.99 | USD | 2026-10-07 18:46 | false | |
| 11 | 48203 | 1311 | Paid | 128.60 | USD | 2026-10-07 16:02 | false | |
| 12 | 48202 | 990 | Cancelled | 61.20 | EUR | 2026-10-07 13:55 | NULL | |
| 13 | 48201 | 352 | Shipped | 412.75 | GBP | 2026-10-07 11:31 | true |
The client
Everything a database client should do.
The grid, the editor and the structure tab, each with the one thing that was missing from the last tool you used.
A grid that behaves like a spreadsheet
A cell cursor, a range you extend with Shift, and Cmd+C that copies TSV while Cmd+Shift+C keeps the values typed as JSON. Freeze and hide columns; the view is remembered per table.
Edit in place
Typed editors for enums, booleans, dates and JSON, right in the cell. Enter to edit, Escape to cancel, and Cmd+Z undoes an edit that already saved.
Every foreign key, both ways
Jump arrows on referencing cells, a Referenced-by panel that counts each child table, and a cascade delete that shows an exact count per table before anything runs.
Find anything
Cmd+Shift+F searches a value across every table in a schema and opens the hit already filtered. A broken-references check finds rows pointing at parents that are gone.
A real SQL editor
Completion from your schema, history and saved queries, and a cancel that works. It runs on its own connection, so a transaction you leave open never leaks into the grid.
Structure in view
An auto-laid-out diagram of every relationship. Add, drop or rename columns and indexes with a live preview of the exact DDL, and seed a table with realistic rows.
AI, optional
AI that drafts. You decide what runs.
Ask for a query in plain words, fix one the database rejected, or have one explained. Every answer lands in the editor with an Undo - nothing executes by itself.
Ask AI
Write a query from a sentence, or describe a change - "only last week", "group by city" - and it edits the one already in the editor.
Fix with AI
One click sends the failed SQL and the database's own error, and puts a corrected query back with a sentence on what was wrong.
Explain query
A plain-English walk-through in the order the database runs it, flagging joins that multiply rows or filters that quietly drop them.
Bring your own key
- Anthropic
- OpenAI
- Cloudflare AI Gateway
The provider you pick sees your schema and the SQL you ask about - not the rows your queries return. Everything else in the app works without a key.
Local by design
Nothing leaves your machine.
There is no account and no relay. The app talks to your databases, to GitHub for the update check, and to an AI provider only if you add a key.
Credentials stay encrypted
Passwords and tokens are sealed with the OS keychain and never reach the interface, which only ever learns that a secret exists.
A sandboxed interface
The window runs sandboxed with no network of its own. Every query crosses one narrow bridge to the process that holds the connections.
TLS verified per connection
Certificate verification is a switch on each connection, on by default for new ones, with hostname checks on MySQL as well as Postgres.
Destructive SQL asks first
DROP, TRUNCATE, and a DELETE or UPDATE without a WHERE stop for a confirmation, including ones hidden behind a WITH clause or a subquery.
Keyboard first
Hands on the keyboard.
Every action has a key. Press ? in the app for the full list.
- Search tables, connections and actions⌘K
- Find a value in every table⌘⇧F
- Filter this table in plain words⌘I
- Run the query⌘↵
- Move the cell cursor↑↓←→
- Extend the selection⇧→
- Edit the cell under the cursor↵
- Open the record under the cursor⇧↵
- Copy the selection as text⌘C
- Undo the last cell edit⌘Z
Cmd on a Mac, Ctrl on Windows and Linux.
Open source
MIT licensed, built in the open.
The whole app is on GitHub: read it, file an issue, or send a change. Every release is built by a public workflow from a tag.
Questions
What people ask.
What is OrbitDB?
OrbitDB is a free, open-source desktop app for browsing, editing and querying PostgreSQL, MySQL, MariaDB and Cloudflare D1 databases on macOS, Windows and Linux. It pairs a data grid that works like a spreadsheet with a SQL editor, and optional AI that drafts queries but never runs them by itself.
Is it free?
Yes. OrbitDB is MIT licensed, there is no account, and nothing is gated. If you add an AI key you pay your provider at their own rates, and the app keeps an estimate of what each feature has cost.
Which databases does it support?
PostgreSQL, MySQL and MariaDB over a direct connection, and Cloudflare D1 over its REST API. There is no SSH tunnel yet.
Which platforms does it run on?
macOS on Apple Silicon, Windows x64, and Linux as an AppImage or a .deb package. Every installer is on the download page with its SHA-256 checksum.
Does my data leave my machine?
No. Credentials are encrypted locally and the interface has no network of its own. The only outside calls are the update check to GitHub and, if you add a key, your AI provider, which is sent your schema and the SQL in question, never query results.
Why does macOS warn on first launch?
The app is not code-signed yet. Right-click OrbitDB, choose Open, and confirm once. Windows SmartScreen asks the same with More info, then Run anyway.
How do updates work?
The app checks GitHub Releases and tells you in Settings. On Windows and the Linux AppImage it downloads and installs the new version from there. On macOS it links to the release page until the app is signed.
Do I need an AI key?
No. Every AI feature is optional and simply absent without a key. Add one for Anthropic, OpenAI, Google or a Cloudflare AI Gateway in Settings and it stays encrypted on your machine.
Is this the OrbitDB peer-to-peer database?
No. This OrbitDB is a desktop client for SQL databases. The peer-to-peer database built on IPFS that shares the name is a separate, unrelated project.
Open your database in OrbitDB
Free and open source. Ready in a minute on macOS, Windows and Linux.
- macOS 12+
- Windows 10+
- Linux x64
- MIT licence