macOS · SwiftUI app
Lily DB
One beautiful client for every database.
Lily DB brings PostgreSQL, MySQL, SQLite, Redis, and MongoDB together under one beautifully designed macOS interface. Built entirely in Swift with no external daemons, it delivers fast schema browsing, a responsive SQL editor, inline data editing with staged changes, foreign-key navigation, schema diff & sync, a one-click Health Check that audits your database, and production guardrails that confirm dangerous writes before they run.
v0.2.3 · macOS 26+ · 30 MB · notarized
What it does
Five engines, one app
PostgreSQL, MySQL/MariaDB, SQLite, Redis, and MongoDB — each with a UI tuned to its data model, all over pure-Swift drivers.
One-click Health Check
Audit any database with ready-to-run fixes plus an AI architecture review — PK/FK/index checks for relational, TTLs and big keys for Redis, indexes and document size for MongoDB.
Production guardrails
Read-only connections hard-block writes, and any UPDATE or DELETE without a WHERE — or any write on a production connection — asks first.
Navigate by relationship
Right-click a value to jump to the row it references, or search the whole database (⇧⌘O) to find which table holds a value.
Schema diff & sync
Compare two connections, generate DDL for what's missing, and get destructive changes flagged as comments for review.
Answers, not just rows
Click a column header for instant count/sum/avg/min/max, turn results into charts, or let local AI summarize patterns, outliers, and plain-English SQL — via your claude CLI, no API keys.
Specs
- Version
- 0.2.3
- Platform
- macOS 26+ (Universal)
- Engine
- Pure-Swift NIO drivers
- Secrets
- macOS Keychain
- Signing
- Developer ID · notarized
- Download size
- ~30 MB
