Skip to content
← Back to the familyEXPERIMENT / 05/v0.38.0

THE ONE WITH ALL THE CONNECTIONS

Lily DBv0.38.0

Your databases.
Their happy place.

A fast, native macOS database client for PostgreSQL, MySQL, SQLite, SQL Server, Redis, MongoDB, DynamoDB, Trino, and ClickHouse — nine engines under one beautiful roof.

Download for Mac

Free · macOS 14+ · 64 MB

Windows is on the guest list. Coming soon.

a very good relationship manager.
Lily DBSMALL APP. BIG IDEAS.

Good with tables. Great with your sanity.

looking for a meaningful relationship. foreign keys welcome.

Native macOSNine database enginesLocal-first100% CORTEX LABS ENERGY

01 / MORE THAN A PRETTY ICON

Big little
superpowers.

12 ways to make your day easier.
Yes, we got a little carried away.

SUPERPOWER / 01

Compare schemas with clear coverage

Compare PostgreSQL defaults, composite keys, UNIQUE constraints, foreign keys and indexes, with original definitions and explicit coverage. Preview a destination-specific DDL plan with additions ordered before dependent foreign keys; destructive changes stay manual. Executable plans require complete metadata and matching PostgreSQL major versions, starting at 14. Data diff compares up to 5,000 rows per side and does not synchronize records.

SUPERPOWER / 02

Trace — see what your database is doing

Arm the activity monitor and it gains a memory: record the last minutes of everything running, then scrub the timeline back to the moment things slowed down. Queries that finish in under a second slip past the live view, so a Top tab reads pg_stat_statements ranked by total time. See a live tree of who's blocking whom and kill any session from the graph — and Lily's local AI explains the root cause of a slow query in plain language, entirely offline.

SUPERPOWER / 03

Speed up a slow query in one click

Let Lily propose an index, review the SQL, and compare EXPLAIN estimates before and after. These are planner costs, not measured response times. Investigate only reports an index as reverted after confirmed removal; failed or uncertain reversals retain their history and manual SQL.

And a few more tricks.

Go on. Open one.

04

Your database has a tour guide

Lily explains the business behind your schema and checks rules against view, procedure, function and trigger definitions on PostgreSQL, MySQL and SQL Server. Open the quoted source or explore a column’s catalog references. Missing definitions stay visible, and Ask can reuse verified rules. Try a guided question on the sample store, with real SQL and results. Try the optional PostgreSQL legacy guide with fictional discounts, blocks and refunds, then reproduce a controlled lock in Trace. Requires Docker.

05

Recipes for every entity

For each business entity Lily writes the everyday queries you actually run — "recent orders for a customer", "find by email" — parameterized and ready to open in the editor. Read-only and EXPLAIN-validated before they're ever offered; generated on demand when you explore an entity.

06

Change your schema with AI

Describe a change in plain language — "add soft-delete", "make email unique" — and Lily generates the forward DDL plus its exact rollback, grounded in your real columns, keys and indexes. Nothing runs until you open it in the editor and confirm; destructive changes are flagged and pass the same write guardrails as any statement.

07

Semantic schema search

Ask "where do we store refunds?" and Lily ranks the real tables and columns that hold the concept — each with a one-line reason — searching your schema's meaning, not just its names. Click a result to jump straight to the table. It searches metadata only, never your rows.

08

See the blast radius before you write

Production writes share a review across the editor, table edits, notebooks, imports, AI fixes and data transfers. See the destination and planned changes, confirm a batch once, and type the destination name for destructive operations.

09

PII scan, redacted by default

Lily classifies column names and types before sampling rows, masks flagged high/medium-risk values and omits the sample when classification is incomplete. Review the exact prompt on the first send, or every time in Settings. Automatic classification can miss sensitive data.

10

Nine engines, one app

PostgreSQL, MySQL/MariaDB, SQLite, SQL Server, Redis, MongoDB, DynamoDB, Trino, and ClickHouse — each with a UI tuned to its data model. SSH tunnels support agent, key-passphrase, and password auth for corporate bastions. SQL Server TLS now verifies the certificate and server name, including through SSH. Add a private CA when needed. Existing TLS connections ask you to choose a certificate policy before reconnecting. Redis TLS verifies the certificate and server name for the main connection, Pub/Sub and reconnects, including SSH. Private CA certificates and optional ACL users are supported.

11

Results you can work

Edit eligible PostgreSQL query results when Lily can identify the source table and complete primary key. Review staged changes before saving; conflicts stop the transaction. Other results stay read-only with an explanation. Sort any column (numbers, dates, and text handled right) and filter with real operators — no re-query. Freeze the first columns while the rest scroll, click a header for instant count/sum/avg/min/max, chart the result, or let local AI summarize the patterns.

12

One-click Health Check

Audit any database with ready-to-run fixes plus an AI architecture review — schema, index, and security rules (RLS, PUBLIC grants, unused indexes) for relational, TTLs and big keys for Redis, indexes and document size for MongoDB. Jump from a value to the row it references, kill stuck queries, and render any plan as a visual EXPLAIN cost-bar tree.

The whole story, for the curious.

A closer look at what makes Lily DB tick.

Lily DB brings PostgreSQL, MySQL, SQLite, SQL Server, Redis, MongoDB, DynamoDB, Trino, and ClickHouse together under one beautifully designed macOS interface — nothing to set up, no daemons to babysit. You get fast schema browsing, a responsive SQL editor with in-place sort and filter, inline data editing with staged changes, foreign-key navigation, schema diff & sync, and a one-click Health Check. Its local AI reads your schema to explain the business behind it, answers questions in plain language, and makes it searchable — "where do we store refunds?" jumps you to the table. And it's safe by default: a shared Production review shows the destination and planned writes, with impact estimates for supported statements, and a column classification masks flagged values before AI samples rows, with metadata-only fallback and a prompt preview.

A LITTLE PERSPECTIVE

Good company.
Different strengths.

Already using TablePlus, DBeaver or DataGrip? Here’s where Lily fits into your workflow.

Scroll sideways to compare all four tools.

Lily DB, TablePlus, DBeaver and DataGrip compared by license, platforms, databases, moving data between engines, diagnosing and fixing, write safeguards, what leaves your Mac, and AI.
What matters
Lily DB
FROM THE LAB
TablePlus
DBeaver
Community + PRO
DataGrip
Price & license Free

The app and its built-in features.

Free trial / paid license — TablePlus: Price & license. Official source.

Trial: 2 tabs, 2 windows. Perpetual license includes 1 year of updates.

Community is free — DBeaver: Price & license. Official source.

Open source. PRO editions are paid.

Paid for commercial use — DataGrip: Price & license. Official source.

Free for eligible non-commercial use.

Platforms macOS 14+

Native Mac app. Windows is coming.

macOS, Windows, Linux — TablePlus: Platforms. Official source.

Also available on iOS.

macOS, Windows, Linux — DBeaver: Platforms. Official source.

Cross-platform desktop app.

macOS, Windows, Linux — DataGrip: Platforms. Official source.

A dedicated database IDE.

Databases 9 engines, SQL + NoSQL

Includes PostgreSQL, Redis, MongoDB and DynamoDB.

SQL + NoSQL — TablePlus: Databases. Official source.

Includes Oracle and DuckDB; DynamoDB is in beta.

SQL in Community — DBeaver: Databases. Official source.

MongoDB and Redis support in paid editions.

50+ supported databases — DataGrip: Databases. Official source.

Database-aware completion, inspections and SQL refactoring.

Data between engines Any engine to any engine

Send a result or a table to another engine, copy a whole schema across engines, or convert SQL to MongoDB and back, with a preview before anything runs and rollback if it didn’t help.

Export, import and dumps — TablePlus: Data between engines. Official source.

CSV, JSON, SQL and Excel files; dump and restore for PostgreSQL, MySQL and MariaDB. No engine-to-engine transfer.

Data transfer wizard — DBeaver: Data between engines. Official source.

Table to table between connections with column mapping, in Community too. Types may need adjusting by hand.

Copy table to another data source — DataGrip: Data between engines. Official source.

Column mapping before it runs; full dumps through pg_dump and mysqldump.

Diagnose and fix Investigate applies the fix and proves it

Describe a symptom in plain words. Lily names the likely cause, cited to your schema and traces, applies the fix, measures before and after, and undoes it if it didn’t help. Trace records what runs and rewinds to the slow moment.

Editor and AI assistant — TablePlus: Diagnose and fix. Official source.

Query history and an LLM plugin that writes and explains queries. No execution-plan view in the docs.

Visual execution plan — DBeaver: Diagnose and fix. Official source.

The plan as a graph, with the costliest path in red. Reading it and fixing it is on you.

Explain plan and inspections — DataGrip: Diagnose and fix. Official source.

Plan tree, diagram and flame graph; SQL inspections flag issues. Applying a fix is on you.

Write safeguards Impact preview

Estimates affected rows and related tables before a write.

Configurable Safe Mode — TablePlus: Write safeguards. Official source.

Confirmation or password prompts before sending queries.

Manual / Smart commit — DBeaver: Write safeguards. Official source.

Smart commit switches to a manual transaction before writes.

Preview pending changes — DataGrip: Write safeguards. Official source.

Review generated DML before submitting data edits; manual commit available.

What leaves your Mac Only the update check, unless you turn a switch on

A daily update check with the app version and no ID. Three switches in Settings, all off; each says exactly what it sends, and the install ID is deleted with the last one. No account, no automatic crash reports.

Crash reports, on by default — TablePlus: What leaves your Mac. Official source.

Anonymous crash reports, off only with a license; a hashed device ID for licensing. Queries and credentials never leave.

Usage statistics, asked at setup — DBeaver: What leaves your Mac. Official source.

Interface actions and database types, anonymized; your choice at first start, changeable in Preferences. Required in the Early Access Program.

Usage statistics, off by default — DataGrip: What leaves your Mac. Official source.

Off in release builds; the free non-commercial license requires it. Feature usage and performance, never your queries.

AI Your existing CLIs, or Ollama — Lily DB: AI. Official source.

Install Ollama and download models from Lily. With a downloaded model on this Mac, Understand, Ask and Investigate work offline without an account. CLIs use your provider account; a remote Ollama server receives the prompts you send it.

Via Ollama — TablePlus: AI. Official source.

Configure a local model, or choose a cloud provider.

Ollama in paid editions — DBeaver: AI. Official source.

Lite, Enterprise and Ultimate. Model setup required.

Via AI Assistant — DataGrip: AI. Official source.

Supports local models and external providers, with configuration.

Sources checked

Desktop features compared on macOS. Availability varies by edition, database and configuration. Linked entries open the official sources.

02 / LET’S MAKE THIS OFFICIAL

Are we
your type?

A few practical details.
No awkward first-date questions.

THE COMPATIBILITY CHECK

A little space.
A lot of potential.

For macOS.
Made to feel right at home.

SMALL LAB
BIG CARE
Runs on
macOS 14 or later
Price
Free
Download
63 MB
Databases
Postgres, MySQL, SQLite, SQL Server, Redis, MongoDB, DynamoDB, Trino, ClickHouse
Your data
Stays on your machine — nothing is sent unless you turn it on
Updates
Automatic, in the background

YOUR NEXT FAVORITE TOOL IS RIGHT HERE.

Meet your database’s new best friend.

Less wrestling with tools. More getting to the good stuff.

Download for Mac

Free · macOS 14+ · 64 MB