pgconsole: Minimal Web-based Postgres SQL Editor
Which SQL Editor do you use?
What is the PostgreSQL Playground?
The Postgres Playground is an online PostgreSQL database that runs directly in your browser. It’s a simple, no-setup solution for testing SQL queries and learning PostgreSQL.
How long does data persist in the PostgreSQL Playground?
Data in the Postgres Playground is temporary. It is stored only in your browser’s memory and will disappear when you close or refresh the browser. It is not saved to disk or stored in browser local storage.
Is my data and code secure when using the PostgreSQL Playground?
Yes, your data and SQL code remain secure. All operations are executed locally in your browser, and we do not store your queries or data on any external servers.
After shipping pgschema last year, I started tinkering with another side project, and I’ve been building it over the past few months. Today I’m finally sharing it: pgconsole, a web-based SQL editor for Postgres.
I’ve used TablePlus for a long time and still like it, but two things kept bothering me. First, it’s a desktop client, so for team use I still end up sharing DB credentials and dealing with firewall/bastion setup. Second, because it supports many databases, the Postgres experience isn’t always as polished as I want (for example, autocomplete).
Beyond addressing those two issues, I also intentionally kept pgconsole simple: no metadata DB, just a TOML config file. The goal is to make it easy to spin up a lightweight, just-in-time GUI for any Postgres database.
If this sounds useful, check it out: www.pgconsole.com
Is there any online query editor to run the psql queries?
I was wondering which SQL editors do you use to write SQL queries and manage tables. Or do you use any Local/Native apps to do the same?
For folks who use Native applications, would you consider switching to a web based editor?
What is your experience with what you are using right now and what would you like to have it improved to?
I'm currently building a web based SQL query editor for myself, it's sleek, fast and have tons of capabilities including AI based query generation. Would love to see if this is something people actually want or just open source it?