Ask HN: What’s the best GUI you’ve ever used for managing/querying databases?

• beekeeper-studio

  59 15,274 9.8 TypeScript

  Modern and easy to use SQL client for MySQL, Postgres, SQLite, SQL Server, and more. Linux, MacOS, and Windows.

  

I mean, you're not wrong: there is absolutely a big place for API/CLI support with DB tools, but in this specific instance, the OP specifically asked for a GUI, not CLI or APIs to roll their own.

If you're a MacOS user and your DB of choice is supported, this is my choice: https://www.beekeeperstudio.io/

If you're a Postgres user, pgAdmin had previously been my go to: https://www.pgadmin.org/

• pgadmin4

  44 2,110 9.7 Python

  pgAdmin is the most popular and feature rich Open Source administration and development platform for PostgreSQL, the most advanced Open Source database in the world.

  

I mean, you're not wrong: there is absolutely a big place for API/CLI support with DB tools, but in this specific instance, the OP specifically asked for a GUI, not CLI or APIs to roll their own.

If you're a MacOS user and your DB of choice is supported, this is my choice: https://www.beekeeperstudio.io/

If you're a Postgres user, pgAdmin had previously been my go to: https://www.pgadmin.org/

• InfluxDB

  www.influxdata.com sponsored

  Power Real-Time Data Analytics at Scale. Get real-time insights from all types of time series data with InfluxDB. Ingest, query, and analyze billions of data points in real-time with unbounded cardinality.

  

• mathesar

  53 2,196 9.9 Python

  Web application providing an intuitive user experience to databases.

  

I’m not sure if it’s okay to plug my project, but I work on Mathesar (https://github.com/centerofci/mathesar) which can be used as a Postgres GUI. We’re putting a lot of product/design effort into making it nice to use for non technical users.

Otherwise, I just use the command line.

Suggest a related project