AppsDatabase Client

Database Client

A TablePlus-class database client with a 6-level safe mode — production without fear.

One window for PostgreSQL, CockroachDB, MySQL, MariaDB, SQLite, Redis, MongoDB, and DynamoDB. Browse schemas, run SQL, edit rows — with a safety system standing between you and a 6 PM DELETE without a WHERE.

Decorative animation of Database Client. Step-by-step instructions follow in the text below.

The pieces

  • Connections sidebar — your saved connection profiles. Passwords live in the macOS Keychain. → Connecting
  • Schema browser — databases, tables, columns, indexes at a glance. Click a table to open it.
  • Query tabs — a SQL editor with syntax highlighting, schema-aware autocomplete, and a formatter. ⌘⏎ runs the query.
  • Data grid — results in a fast native table: filter, sort, follow foreign keys, edit inline. → Editing data
  • Query history — every query you've run, full-text searchable.
  • Import/Export — CSV in; CSV, JSON, SQL, or Excel out. → Import & Export

Safe mode — the 6 levels

Every connection profile has a safe mode level. It decides what the app will run silently, what it asks about first, and what needs Touch ID. Pick it per profile — paranoid for production, relaxed for local.

LevelNameWhat it does
0Read-onlyBlocks every write and schema change.
1Confirm everythingAsks before every statement — even SELECT.
2Confirm writesAsks before INSERT / UPDATE / DELETE and DDL.
3Confirm deletes & DDLAsks before DELETE and schema changes.
4Touch ID for productionLevel 3, plus Touch ID for any write on a production profile.
5UnrestrictedNo guardrails — every statement runs immediately.

How it decides what's 'a write'

The app classifies each statement before running it. If it can't tell what a statement is, it plays safe and treats it as a write — unknown SQL is gated, never silently allowed.

  • Local Docker database → Unrestricted or Confirm deletes & DDL
  • Shared staging → Confirm writes
  • Production → Touch ID for production (level 4) — writes need your fingerprint, and you'll be glad they do