Octapus DB
New in 1.1: import connections, compare schemas, back upSee what's new

All your databases.
In an app that's actually light.

Octapus DB is a desktop client for PostgreSQL, MongoDB, Redis and SQLite. It opens in under half a second, takes a few MB, and doesn't weigh you down like an IDE.

DownloadWatch the demo
  • Free
  • Open source
  • No account
  • macOS, Windows and Linux

Octapus DB

Octapus DB demo: connection tree, editing in the grid, the SQL editor, a MongoDB document as JSON and Redis keys

Connects to

Performance

Light isn't a slogan. It's a measurement.

Rust at the core and the system's own webview instead of a bundled Chromium. The result is an app that opens before you finish clicking.

until the window opens
0.43 s
Windows installer
8.4 MB
12 MB on macOS
of memory at idle
138 MB
WebKit included
per autocomplete suggestion
< 5 ms
on a database with 750,154 tables
Installed size
  • Octapus DB42 MB
  • DBeaver161 MB
  • TablePlus429 MB
  • pgAdmin 4710 MB
Time until the window opens
  • Octapus DB0.43 s
  • TablePlus0.58 s
  • DBeaver2.7 s

pgAdmin opens its window before starting its own server, so it is left out of this comparison.

How we measured

Apple M3 Pro with 18 GB, macOS 26.1, on October 24, 2026.

Time to window: from the open command until the first window of at least 600 × 400 pt is on screen (splash screens don't count). One warm-up launch discarded, then the median of the next 5.

Memory: the app open and idle for 15 s, with no connection; the sum of the physical footprint (Activity Monitor's Memory column) of every process of the app, including the WebKit ones it draws its interface with.

Size: the .app bundle on disk. Installers: the files of version 1.1.0-beta.2 on GitHub.

Autocomplete: the app's own benchmark suite, on a PostgreSQL with 5,002 schemas and 750,154 tables.

The script lives in the site's repository — run it and compare on your machine.

Coming soonAI assistant

Ask in plain English. Octapus writes the query.

We're building an assistant into Octapus. It will read the structure of the open database, write the query in its language, check it, run it and show the result in the grid — and if the database answers with an error, fix the query on its own.

The assistant isn't in the app yet. Below is a preview of how it will work.

  • Will speak each database's languageSQL on PostgreSQL and SQLite, filters and aggregations on MongoDB, commands on Redis.
  • The query, always in viewYou'll see what ran and every assumption it made. One click opens it in the editor.
  • Only reads run on their ownWrites, functions and indexes will come back as text for you to review. Auto-run can be turned off.
  • Your data stays on your machineThe model only gets names and types. Values in views and functions become ? and errors are scrubbed before leaving.
Follow along on GitHub

How you'll use it

When it lands, you pick the provider in settings. Credentials will live in Octapus's vault, encrypted on your machine.

Account

ChatGPT

Sign in with your Plus or Pro account and use your plan — no API key.

API key

OpenAI, Anthropic, OpenRouter

Paste your key and pay the provider directly.

Local model

Ollama, LM Studio

The model runs on your computer. Not a byte leaves your network.

Your endpoint

OpenAI-compatible

Any gateway or server that speaks the OpenAI API.

@table to point at what mattersRefine in follow-up turnsConversation historyFull-window agent mode (⌘⇧J)Cancel at any time
See what will be sent to the model

The structure goes as compact DDL, only for the tables that matter to the question. No row of your database is sent.

-- PostgreSQL. Schemas: "public" (of 3 in the database)
CREATE TABLE "public"."usuarios" (
  "id" integer NOT NULL PRIMARY KEY,
  "nome" text,
  "email" text
);
CREATE TABLE "public"."pedidos" ( -- «Pedidos da loja»
  "id" integer NOT NULL PRIMARY KEY,
  "usuario_id" integer NOT NULL REFERENCES "public"."usuarios" ("id"),
  "total" numeric(10,2),
  "status" text,
  "criado_em" timestamptz
);
-- Other tables (columns not shown): "produtos", "estoque", "cupons"

Why Octapus

Built for people who live inside their databases

Actually light

Rust and Tauri, no Electron and no JVM. A few-MB installer and a window open in under half a second.

One app, four databases

PostgreSQL, MongoDB, Redis and SQLite with the same tree, the same editor and the same shortcuts.

Safe by default

Passwords in an encrypted vault, nothing reaches the database without review, and the source is open to check.

Features

The essentials, done really well

No endless menus. Just what you use every day — fast and where you expect it.

An editor that knows your schema

Autocomplete for tables, columns and functions as you type. Select a fragment and run just that with ⌘↵.

  • Highlighting and formatting
  • Paging and cancellation
  • Results and messages side by side
An editor that knows your schema

Edit in the grid, review before saving

Double-click, new value. New, edited and deleted rows stay marked until you save with ⌘S.

  • Insert and delete rows
  • Value panel for JSON, XML and HTML
  • Safe edits keyed by primary key
  • Everything saved in a single transaction
Edit in the grid, review before saving

⌘K and you're there

Jump to any table in any connection without leaving the keyboard. The same table across schemas becomes one group.

  • Search across every connection
  • Tab pins a schema
  • The same table across schemas becomes one group
⌘K and you're there

Built for thousands of schemas

The structure syncs in layers and the tree is virtualized: smooth with 5,002 schemas and 750,154 tables.

  • Groups schemas with the same shape
  • Flags the tenant that drifts
  • Compares two schemas
Built for thousands of schemas
  • DBeaver
  • pgAdmin
  • TablePlus
  • DataGrip
  • Beekeeper Studio

Bring your connections

Import from DBeaver, pgAdmin, TablePlus, DataGrip or Beekeeper Studio, or paste a URL. You review before saving.

$ pg_dump -Fc loja > loja.dump

Backup and restore

pg_dump and pg_restore with a command preview, progress, log and cancellation.

ALTER TABLE pedidos
  ADD COLUMN cupom text;

Structure editor

Create, rename and drop tables and columns from the tree, always with a preview of the SQL that will run.

And more

  • Search inside the grid
  • Export to CSV, JSON and SQL
  • SSL/TLS and connection URIs
  • Server groups
  • Session restored on reopen
  • Light and dark themes
  • Automatic updates
  • Nix package
  • Server-side filters and sorting

Multi-database

One app, four databases

Octapus works out what each database can do and adapts the interface on its own — no modes, no plugins.

Schemas, views, full SQL with autocomplete and safe edits keyed by primary key.

  • Schemas and views in the tree
  • SQL autocomplete
  • Edits by primary key
SELECT nome, email FROM usuarios
WHERE ativo = true AND criado_em > '2025-01-01';
Octapus DB — PostgreSQLOctapus DB — MongoDBOctapus DB — RedisOctapus DB — SQLite

Security

Your data stays with you

No account, no telemetry, and the source is open for anyone who wants to check.

In the app

  • Passwords in an AES-256-GCM vault, with the key bound to your device
  • No account and no telemetry: Octapus doesn't know who you are
  • Open source under MIT and Apache-2.0
  • Updates are signed and verified before installing
  • Nothing reaches the database until you review it — and what you save goes in one transaction: all or nothing

In the assistant (coming soon)

  • You'll pick the provider — or run the model on your own machine
  • Only the structure will be sent; values become ? and errors are scrubbed
  • Reads through per-language guards, a READ ONLY transaction and a time limit
  • Names and comments from your database treated as data, never as instructions

Comparison

Side by side

Measured on the same machine, with the installed version of each.

Octapus DBTablePlusDBeaverpgAdmin 4
Installed size42 MB429 MB161 MB710 MB
Time until the window opens0.43 s0.58 s2.7 sn/m
PriceFreeUS$ 99 licenseFree (Community) · PRO paidFree
Open sourceYesNoYes (Community)Yes
PostgreSQL, MongoDB, Redis and SQLite at no costYesWith a paid licenseMongo and Redis in PRO onlyPostgreSQL only
TechnologyRust + TauriNativeJava (Eclipse)Electron + Python

Versions measured: Octapus DB 1.1.0-beta.14, TablePlus 27.1.0, DBeaver 24.3.3, pgAdmin 4 8.11. Prices and features as listed on the official sites in October 2026.

Questions

Frequently asked questions

Is Octapus really free?

Yes. It's free and open source (MIT or Apache-2.0), with no hidden paid tier and no connection limit.

Why does macOS need a command to install it?

The app isn't signed by Apple yet. With Homebrew, the last command removes the quarantine macOS puts on downloaded apps. The source is open for you to check.

Where are my passwords stored?

In Octapus's own vault, encrypted with AES-256-GCM and with the key bound to your device. They never leave your machine.

When is the assistant coming?

There's no date yet: it's in development and will arrive in an app update. When it does, you'll be able to use your ChatGPT plan, your own API key — paying the provider directly — or a local model, for free.

Will the AI see my data?

No. The model will only get the structure: table names, columns and types. No row of your database will be sent, and error messages will be scrubbed before leaving.

Does it work offline?

Yes: the app connects straight to your databases, through no server of ours. When the assistant arrives, it will need its provider — unless you use a local model.

Does Octapus collect usage data?

No. There's no account, telemetry or analytics inside the app.

Download

No account. No trial. Just the app.

Version 1.1.0-beta.2 — free, open source and ready for your system.

All platforms

All platforms