SHORTLIST20
English
Englishالعربية中文日本語한국어EspañolFrançaisहिन्दी
Programming

Top 20 PostgreSQL GUI clients and admin tools

Open-source ways to browse, edit and chart a Postgres database

Updated · GitHub stars (stars)

Why these 20

Ranked by GitHub stars: how many developers bookmarked the project. Stars measure attention, not quality, so each row also shows forks, licence, the last push and the section of the community list it sits in. Closed-source tools in the same list (DataGrip, TablePlus, Postico, Navicat-style paid clients and others) have no public star count, so they can't be ranked here.

  1. 1

    dbeaver/dbeaver

    Free universal database tool and SQL client

    52,142 stars 4,422 forkslast push 2026-10-20JavaApache-2.0

    Also in: #1 DuckDB GUIs and SQL clients#7 open-source databases

  2. 2

    metabase/metabase

    The easy-to-use open source Business Intelligence and Embedded Analytics tool that lets everyone work with data :bar_chart:

    49,748 stars 6,913 forkslast push 2026-10-20ClojureNOASSERTION

    Also in: #9 open-source databases

  3. 3

    Redash

    Connect to any data source, easily visualize and share your data.

    28,840 stars 4,637 forkslast push 2026-10-16PythonBSD-2-Clause

  4. 4

    Beekeeper Studio

    Free and open source SQL client with a modern UI and great Postgres support. Cross platform.

    23,769 stars 1,651 forkslast push 2026-10-20TypeScriptNOASSERTION

    Also in: #2 DuckDB GUIs and SQL clients

  5. 5

    Teable

    A Super fast, Real-time, Professional, Developer friendly, No code database.

    21,906 stars 1,357 forkslast push 2026-10-20TypeScriptNOASSERTION

  6. 6

    Bytebase

    Database DevSecOps solution for Developer, Security, DBA, and Platform Engineering teams.

    14,614 stars 1,006 forkslast push 2026-10-20GoNOASSERTION

  7. 7

    pgweb

    Web-based PostgreSQL database browser written in Go.

    9,535 stars 869 forkslast push 2026-07-26GoMIT

  8. 8

    Adminer

    Full-featured database management tool written in PHP.

    7,917 stars 1,182 forkslast push 2026-10-16PHPNOASSERTION

  9. 9

    DbGate

    The Smartest (no)SQL Database Client

    7,339 stars 485 forkslast push 2026-10-19JavaScriptGPL-3.0

  10. 10

    Mathesar

    Web application providing an intuitive user experience to databases.

    5,157 stars 488 forkslast push 2026-10-19SvelteGPL-3.0

  11. 11

    Chartbrew

    Create live dashboards, charts, and client reports from PostgreSQL data. Features a query tool that works with SQL.

    4,061 stars 457 forkslast push 2026-10-20JavaScriptNOASSERTION

  12. 12

    pgAdmin

    PostgreSQL Administration and Management GUI.

    3,892 stars 910 forkslast push 2026-10-16PythonNOASSERTION

  13. 13

    Postbird

    PostgreSQL Client for macOS.

    1,635 stars 129 forkslast push 2026-10-19JavaScriptMIT

  14. 14

    SQL Tabs

    Cross Platform Desktop Client for PostgreSQL written in JS.

    800 stars 56 forkslast push 2023-01-09JavaScriptGPL-3.0

  15. 15

    temBoard

    Web-based PostgreSQL GUI and monitoring.

    770 stars 78 forkslast push 2026-10-19PythonNOASSERTION

  16. 16

    Dekart

    Open-source platform to turn PostGIS queries into shareable interactive maps.

    434 stars 62 forkslast push 2026-10-19JavaScriptAGPL-3.0

  17. 17

    OrcaQ

    A modern, open-source database editor for PostgreSQL, MySQL, Redis, and more. Features an AI assistant, ERD visualizer, schema diff, and visual role management.

    223 stars 15 forkslast push 2026-09-21TypeScriptMIT

How it is measured

Every tool in the GUI section(s) of the community list dhamaniasad/awesome-postgres on GitHub that has a public repository (linked directly, or its project's own repository when the list links the homepage), ranked by GitHub stars from the GitHub API; archived repositories are left out. Refreshed every 6 hours.

References

  1. dhamaniasad/awesome-postgres: GUI, GitHub community list (list text CC0/MIT per repository; star counts from the GitHub API). Checked 2026-10-20 04:30 UTC.
  2. dhamaniasad/awesome-postgres (GUI), GitHub community list, 21 tools with a public repository.