Native macOS database client

Talk to your
databases

Browse data, write SQL, visualize schemas, and generate queries with AI.

Recommended

$ brew install --cask --force amalshaji/taps/dbcooper
Download .dmg $ xattr -cr /Applications/DBcooper.app

Apple Silicon · Free & open source

Natural language
Show me customers who placed orders in the last 30 days
AI + schema → SQL
SELECT c.first_name, c.last_name,
       o.order_date, o.total_amount
FROM customers c
JOIN orders o ON o.customer_id = c.id
WHERE o.order_date >= CURRENT_DATE - 30 days
Schema context customers · orders · order_items
Result
Built for developers
PostgreSQL
SQLite
Redis
ClickHouse

The working surface

Your data stays
in your hands.

Connection credentials and query results stay on your Mac. No account, no cloud sync, no telemetry.

DBcooper browsing a PostgreSQL table
Local workspace PostgreSQL · Connected

01 / Describe

Start with the question.

Ask in plain English. DBcooper uses the schema already on your machine to generate SQL you can inspect and run.

  • Schema-aware generation
  • Streaming SQL output
  • Your own OpenAI key
AI-assisted SQL editor in DBcooper

02 / Understand

See the structure.

Turn foreign keys into an interactive relationship map. Filter the canvas, inspect columns, and move from schema to table in one click.

  • Interactive ER diagrams
  • Table and column filters
  • Exportable schema views
Schema visualizer in DBcooper

The route ahead

A roadmap you can
actually follow.

DBcooper grows along two tracks: a faster workbench and more native adapters. No premium tier, no feature tollbooths.

Released Building Next Exploring
Workbench Product line

released

Million-row paging

Benchmarked first-window load

released

Structured filters

Safe, visual conditions

released

Contextual AI

Preview before apply

next

Saved views

Filters, sort, layout

exploring

Schema diff

Review changes locally

Adapters Database line

released

PostgreSQL + SQLite

Native table and query tools

released

Redis + ClickHouse

Purpose-built workflows

next

MySQL + MariaDB

Relational adapter

next

DuckDB

Local analytical files

exploring

MongoDB

Document explorer

Capability index

Everything you need.
Nothing you don't.

A focused tool for developers who would rather query than configure.

01

Multi-database support

PostgreSQL, SQLite, Redis, and ClickHouse — every engine in one consistent interface. No context-switching between separate apps.

02

Docker database lifecycle

Create persistent PostgreSQL, Redis, and ClickHouse containers or link existing Docker Compose services. Copy credentials, control containers, and keep data by default.

03

Schema visualizer

Interactive ER diagrams render your table relationships automatically. See the shape of your data, not just the rows.

04

AI-powered SQL

Describe what you need in plain English and generate schema-aware SQL with OpenAI-compatible APIs or your local Claude Code, Codex, and opencode CLIs.

05

Command palette

Jump to any table, connection, or action with a keystroke. Keyboard-first, mouse-optional — built for speed.

06

SSH tunnel support

Reach databases behind a bastion securely. Password or private key — configured once, connected instantly.

07

Native & lightweight

Built with Tauri, not Electron. A few megabytes, instant startup, and your credentials never leave the machine.

System notes

Frequently
asked.

Short answers about support, privacy, and how DBcooper works.

01 Is DBcooper free?

Yes — completely free and open source. The full source lives on GitHub under the MIT license.

02 Which databases are supported?

PostgreSQL, SQLite, Redis, and ClickHouse today. More engines are planned for future releases.

03 Can DBcooper create a local database for me?

Yes. With Docker running, DBcooper can create PostgreSQL 17, Redis 7, or ClickHouse 25.8 with a persistent volume and a ready-to-use connection. Quitting the app stops containers it created without deleting their data. You can also link compatible containers from the current Docker context, including Docker Compose services.

04 Does it work on Windows or Linux?

DBcooper is macOS-only for now. Windows and Linux builds are being considered.

05 How do I connect via SSH tunnel?

When adding a connection, enable the SSH tunnel option and provide your SSH host, port, username, and authentication method (password or private key).

06 Is my data secure?

Absolutely. DBcooper runs entirely on your machine — connection credentials and query results never leave your computer, and there's no telemetry.

07 How do I report bugs or request features?

Open an issue on the GitHub repository. All feedback and contributions are welcome.

Ready when you are

Open the database.
Skip the ceremony.

Recommended

$ brew install --cask --force amalshaji/taps/dbcooper
Download .dmg $ xattr -cr /Applications/DBcooper.app

Apple Silicon · Free & open source