ϟ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.
✧ ⌁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.