---
title: "OrbitDB - Open-source database client for Postgres & MySQL"
description: "Free, open-source desktop client for PostgreSQL, MySQL, MariaDB and Cloudflare D1 on macOS, Windows and Linux. Spreadsheet-like grid, SQL editor, optional AI."
url: https://orbitdb.app/
---

# 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.

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.

## Key facts

- Website: https://orbitdb.app
- Latest version: 0.3.2, released 10 October 2026
- Price: free, with no account and nothing gated
- Licence: MIT
- Databases: PostgreSQL, MySQL, MariaDB, Cloudflare D1
- Platforms: macOS on Apple Silicon, Windows x64, and Linux as an AppImage or a .deb package.
- AI: optional, bring your own key (Anthropic, OpenAI, Google, Cloudflare AI Gateway)
- Built with: TypeScript and Electron
- Author: Nikhil Nigam

## 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 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.

Providers: Anthropic, OpenAI, Google, 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.

## 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.

## Hands on the keyboard.

Every action has a key. Press ? in the app for the full list. Cmd on a Mac, Ctrl on Windows and Linux.

- ⌘ K: Search tables, connections and actions
- ⌘ ⇧ F: Find a value in every table
- ⌘ I: Filter this table in plain words
- ⌘ ↵: Run the query
- ↑ ↓ ← →: Move the cell cursor
- ⇧ →: Extend the selection
- ↵: Edit the cell under the cursor
- ⇧ ↵: Open the record under the cursor
- ⌘ C: Copy the selection as text
- ⌘ Z: Undo the last cell edit

## Download

- macOS, Apple Silicon (.dmg): https://github.com/nikhilnigamnik/orbitdb/releases/download/v0.3.2/orbitdb-0.3.2.dmg (143 MB)
- macOS, Apple Silicon (.zip): https://github.com/nikhilnigamnik/orbitdb/releases/download/v0.3.2/OrbitDB-0.3.2-arm64-mac.zip (137 MB)
- Windows, Installer (.exe): https://github.com/nikhilnigamnik/orbitdb/releases/download/v0.3.2/orbitdb-0.3.2-setup.exe (118 MB)
- Linux, AppImage: https://github.com/nikhilnigamnik/orbitdb/releases/download/v0.3.2/orbitdb-0.3.2.AppImage (152 MB)
- Linux, Debian / Ubuntu (.deb): https://github.com/nikhilnigamnik/orbitdb/releases/download/v0.3.2/orbitdb_0.3.2_amd64.deb (111 MB)

## Frequently asked questions

### 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.

## Links

- [Download](https://orbitdb.app/download): installers for every platform
- [Download, as markdown](https://orbitdb.app/download.md): every installer with its size and SHA-256 checksum
- [Install skill](https://orbitdb.app/.well-known/agent-skills/install-orbitdb/SKILL.md): step-by-step instructions for an agent installing the app
- [Documentation](https://github.com/nikhilnigamnik/orbitdb#readme): setup, features and building from source
- [Release notes](https://github.com/nikhilnigamnik/orbitdb/releases): what changed in each version
- [Source code](https://github.com/nikhilnigamnik/orbitdb): the whole app, MIT licensed
- [Licence](https://github.com/nikhilnigamnik/orbitdb/blob/main/LICENSE): the full licence text
- [Security policy](https://github.com/nikhilnigamnik/orbitdb/blob/main/SECURITY.md): how to report a vulnerability privately
- [Contributing](https://github.com/nikhilnigamnik/orbitdb/blob/main/CONTRIBUTING.md): how to send a change
