Lily DBOne beautiful client for every database.

A native macOS app for nine database engines. Written in Swift, free to use, with no account and nothing shared unless you turn it on.

Get started

Download for Mac

Release notes

The Lily DB icon, a smiling white Samoyed with a pink star, on a pink rounded square.

Connect to anything you run

Paste a connection URL and the form fills itself. SSH tunnels, TLS, environment tags and read-only connections, with passwords kept in the macOS Keychain.

Connections

Work the data, not the tool

Sort and filter on the server, edit cells with staged changes, follow foreign keys by clicking, and chart any result in one click.

Browsing tables

AI through the CLI you already have

Lily drives Claude Code, Codex or OpenCode on your Mac. No API key in the app. It explains the schema, answers questions and writes SQL you can read first.

Setting up AI

Guardrails that mean it

Before a write runs, Lily counts the rows it will touch and shows them. Production connections ask first, and read-only ones refuse writes.

Guardrails

See what the database is doing

Trace shows running queries, who is blocking whom and the heaviest statements. Health Check audits the design and security of the schema.

Trace

Move data between engines

Copy a result, a table or a whole schema into another engine, SQL or NoSQL. Big tables stream in batches instead of filling memory.

Move data

Nine engines, one app

Each engine gets a screen shaped for its data model: tables for SQL, keys and types for Redis, documents for MongoDB and DynamoDB.

Managed by Orbit