Web Dev Tools

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 Studiodrizzle-kit studio; web UI for any DB Drizzle supports.
  • Prisma Studioprisma 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.

On this page