Back to home

Feature set

Everything sqlclient can do.

From the encrypted connection to the ER diagram: the full feature set, sorted by topic. Native on the Mac, with no forced cloud.

Connecting & security

Securely connected, from the very first click.

Encrypted connection vault

All saved connections live in an AES-256-GCM vault, protected by a master password (210,000 PBKDF2 iterations). Unlock with Touch ID.

SSH tunnel & SSL certificates

Connect via a bastion host using SSH port forwarding and TLS with your own CA/client certificates (.p12) – real verification instead of “skip verify”.

Read-only & auto-lock

Switch connections to read-only so only read queries run. An auto-lock after inactivity guards against shoulder-surfing and slips.

Production safeguards

Mark production connections in red, confirm dangerous statements by typing the name, and a warning the moment an UPDATE or DELETE without WHERE would hit every row.

Real-time iCloud sync (end-to-end)

Saved connections move between your Macs in near real time. A file watcher pulls in changes automatically, only ciphertext syncs, and conflicts are merged cleanly.

Master password & vault reset

Change the master password, re-encrypting all records atomically and automatically re-setting up Touch ID. Forgotten password? A secure reset instead of a back door.

Connecting & security Securely connected, from the very first click.

Explore & edit data

Work with data like in a spreadsheet.

Editable data grid

Edit inline based on the primary/unique key, insert rows, delete them, set them to NULL – all changes run as one transaction. Full keyboard navigation.

Cell inspector: JSON, Hex, image

Every cell in a modal with character count and copy. JSON is pretty-printed, binary values shown as a hex dump and images (PNG/JPEG/GIF/WebP/BMP) displayed directly as a preview.

Foreign-key navigation

Right-click a cell to jump to the referenced row – or backwards to every row that points to the current record. Driven by the real FK relationships.

Live aggregation of selected cells

Select a cell range by dragging or shift-clicking; the status bar shows the count along with sum, average, minimum and maximum – just like Excel, in both the read-only and editable grid.

Sort, filter, columns, copy

Quick filter and sorting per column, column width and order freely adjustable and remembered per table. Copy the selection as CSV or JSON.

Huge results without stutter

Large result sets render incrementally in chunks and load more automatically as you scroll, instead of freezing the whole tab. Even tens of thousands of rows stay fluid.

Import & export

Export tables or any results as a real Excel workbook (.xlsx, type-preserving), CSV, JSON or SQL dump. CSV import with column mapping.

Explore & edit data Work with data like in a spreadsheet.

SQL console & transactions

A console that respects your production.

Editor with every comfort

Syntax highlighting, schema-based autocompletion, history, beautify and reusable snippets – built on CodeMirror.

EXPLAIN & multiple result tabs

View execution plans directly and keep multiple query results open side by side in their own tabs.

Multiple SQL documents

A dedicated tab strip for SQL documents: add, close, rename. Each document, along with its last result, is saved and restored per connection and database.

Statement under cursor & Auto-LIMIT

Run just the statement at the cursor with ⌘⇧⏎. Row-returning queries without their own LIMIT get a selectable Auto-LIMIT – protection against accidental million-row fetches.

Manual transaction mode

Test risky changes over a dedicated transaction connection, then commit or roll back on purpose. On exit, a clear dialog asks what should happen to open changes.

Cancel query & timeout

Cancel a running query with a click via a second connection (KILL QUERY). A selectable statement timeout kills overly long queries automatically.

SQL console & transactions A console that respects your production.

Schema & objects

The whole data model under control.

VS Code–style schema browser

Databases, tables, views, triggers, routines, events and status in a collapsible sidebar. Plus command palette (⌘K) and schema search across all databases.

Interactive ER diagram

An interactive entity-relationship diagram of the current database: tables with columns and PK/FK markers, FK edges, pan, zoom around the cursor and drag-to-move. Layout remembered per database, double-click opens the table.

DDL GUI entirely without SQL

Create and change tables, columns, indexes and foreign keys, with a live preview of the generated DDL. Maintenance and duplication included.

Object editor for views, routines, triggers

View the CREATE definition of views, procedures, functions, events and triggers, edit it inline and save via CREATE OR REPLACE. New objects from templates, toggle scheduled events on and off.

Table status & metadata

Engine, approximate row count, data and index size, auto-increment, collation, row format and timestamps at a glance – ideal for capacity planning.

Schema & objects The whole data model under control.

Server administration

The server under control when things heat up.

Process list with kill

See all active connections and queries and stop the runaway query in seconds.

Running transactions & locks

View open transactions and locks via information_schema.INNODB_TRX, lock waits highlighted, kill the blocking connection on purpose – the fastest way out of a production stall.

Status, variables & dashboard

Server status, global variables and a compact dashboard for a quick health check.

Server administration The server under control when things heat up.

Users & privileges

Manage privileges without knowing GRANT by heart.

GRANT, REVOKE & SHOW GRANTS

View and grant or revoke privileges per user – visible and traceable, without typing SQL.

User management

Create and delete users and change passwords, straight from the interface.

Local audit log

Every change is logged locally with time, kind and action, and exportable as CSV or JSON when needed – for proof and traceability.

Users & privileges Manage privileges without knowing GRANT by heart.

App, workspace & license

An app that adapts to you.

Multiple connections & workspace

Keep multiple servers open at once as tabs and switch without disconnecting. A workspace per connection, group colors for quick orientation.

Connection survives every UI reload

The active connection lives in the Rust core and survives every interface reload – no waiting for a reconnect.

Language & theme

German or English, light, dark or following the system – switchable on the fly.

Signed & self-updating

Universal binary, Apple-notarized and signed. Updates are checked in the background and applied securely.

License with a click, tamper-proof

Activate your license straight from the self-checkout portal via deep link or by pasting a token. Trial and expiry checks are protected against turning back the system clock.

Security & data sovereignty

A closer look: your data, your keys.

Local-first isn’t a marketing word here. This is how it works in detail.

Placeholder: vault unlock dialog (Light Mode)

Encryption at rest

Encrypted before it touches the disk.

Saved connections live in a local vault encrypted with AES-256-GCM. The key is derived from your master password with PBKDF2-HMAC-SHA256 and 210,000 iterations – the password itself is never stored and never leaves the device.

  • AES-256-GCM with its own random Nonce per record
  • Each record is bound to its profile (AAD) – a Ciphertext can’t be re-homed onto a different profile
  • A Canary verifies the master password without storing it
  • Changing the master password re-encrypts all records atomically in one transaction
Placeholder: unlocking with Touch ID + auto-lock setting (Light Mode)

Touch ID & auto-lock

Open with a fingerprint, locked automatically after inactivity.

Unlock the vault with Touch ID instead of typing the master password. The derived key lives in your Mac’s login keychain, and the Touch ID prompt runs through Apple’s LocalAuthentication – with the device passcode as a fallback.

  • Touch ID can be turned on and off; the master password always remains as a fallback
  • Auto-lock after 5, 15, 30 or 60 minutes of inactivity – or off entirely
  • Lock instantly at any time with a command, in case you step away
  • Read-only mode allows only read queries – protection against slips
Placeholder: iCloud sync status view (Light Mode)

iCloud sync & secure sharing

Across all your Macs – end-to-end, in real time.

Saved connections travel between your Macs over iCloud Drive. Only Ciphertext, along with its Salt and Canary, is ever synced – the master password never leaves a device. A file watcher and a pull on window focus keep everything up to date in near real time.

  • End-to-end: iCloud holds only encrypted data, nobody sees plaintext
  • Zero-Knowledge status: in-sync · newer · older · conflict – computed without decrypting
  • Conflict-safe push: another device’s state is never overwritten by accident (overwriting can only be forced deliberately)
  • Merged per profile via Last-Write-Wins on the change timestamp
  • Different master passwords? Enter the other master once, and both devices converge (Re-Key onto the iCloud Salt)
Placeholder: update dialog with progress (Light Mode)

Signed auto-updates

Always current – and every update is signature-verified.

The app checks for new versions on a regular, throttled schedule and, on request, downloads and installs them directly. Before installing, the package’s signature is checked against a Public-Key embedded in the app – only then does it update.

  • Signature verification against the embedded key before every install
  • Download with a progress indicator, followed by an automatic restart
  • Universal Binary, Apple-notarized and signed
  • Regular, throttled update check in the background
sqlclient

Ready to see it for yourself?

Universal binary, Apple-notarized and signed. 30-day full version, then read for free permanently.

Download for macOS Pricing