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.
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.
| Level | Name | What it does |
|---|---|---|
| 0 | Read-only | Blocks every write and schema change. |
| 1 | Confirm everything | Asks before every statement — even SELECT. |
| 2 | Confirm writes | Asks before INSERT / UPDATE / DELETE and DDL. |
| 3 | Confirm deletes & DDL | Asks before DELETE and schema changes. |
| 4 | Touch ID for production | Level 3, plus Touch ID for any write on a production profile. |
| 5 | Unrestricted | No 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.
Recommended setup
- 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