Database GUIs (Dev Tools)
Apps for browsing, querying, and editing your database.
General-purpose desktop GUIs
- ★ TablePlus — Mac/Windows/Linux; gorgeous; free tier (limited tabs/connections); most-loved paid GUI.
- ★ Beekeeper Studio — open source, free Community Edition, paid Ultimate. The default free pick.
- DBeaver Community — free, supports every DB you've heard of. Java-based, less pretty than TablePlus / Beekeeper but more powerful.
- DataGrip (JetBrains) — paid; best query editor, deep refactoring; free for OSS / students.
- Postico 2 — Mac-only, Postgres-focused; paid; excellent for casual Postgres work.
- Sequel Ace — Mac-only, MySQL/MariaDB only; free.
- Outerbase — modern web-based DB studio; free tier.
ORM-bundled studios
- ★ Drizzle Studio —
drizzle-kit studio; web UI for any DB Drizzle supports. - ★ Prisma Studio —
prisma studio; web UI for Prisma schemas. - Supabase Studio — bundled with Supabase; usable standalone for any Postgres.
- Convex Dashboard — bundled with Convex.
CLI / TUI
- ★
psql— the gold standard for Postgres power users. mycli,pgcli,litecli— autocomplete-rich CLIs.- lazysql — TUI for Postgres / MySQL / SQLite.
Web-based / runs in your browser
- ★ Adminer — single PHP file; many DBs; old-school but tiny.
- phpMyAdmin — MySQL/MariaDB classic.
- pgAdmin — Postgres official; heavyweight web UI.
- Outerbase — modern; hosted + self-host.
- Beekeeper Studio Cloud / Workspaces — beta hosted version.
Schema / migration GUIs
- Atlas (Ariga) — visual schema diff; works with any DB.
- Flyway / Liquibase — older but mature migration tools.
SQLite-specific
- DB Browser for SQLite — free, classic.
- Beekeeper / TablePlus — also handle SQLite.
sqlite-web— Python web UI.
Pick this if…
- Default desktop, free: Beekeeper Studio.
- Default desktop, will pay for polish: TablePlus.
- You're on Drizzle/Prisma: their Studios first; reach for a real GUI when you outgrow them.
- Power user querying: DataGrip (paid) or
psql+pgcli. - Lightweight web UI you can drop on a server: Adminer.