A Postgres Gateway (Web UI) with OIDC and ACL
A Postgres Gateway (Web UI) with OIDC and ACL
Hey HN, I’ve built a database gateway to provide controlled access to production databases with fine-grained permissions and secure query execution. Key Features: - Role-Based ACLs: Define access rules at the instance, table, and column levels. - OIDC Authentication: Users log in through OpenID Connect. - Multi-Instance Support: Query multiple PostgreSQL instances from a single interface. - Web Interface: Execute approved queries and view results securely. - Query Storage: Save query results for later access or export. How It Works: - Users authenticate via OIDC. - ACLs enforce access to specific instances, tables, and columns. - Approved queries are executed, and results are stored securely. Built For: - Developers who debug production data. - Team Leads and Product Owners who access production data for reporting. - DevOps who run queries on behalf of other roles. - Security Engineers who ensure sensitive production data remains protected. Question: How do your developers access production databases, especially when the data is sensitive and critical to the company?
Share cardActual performance
Launch Intel predictions
Analyze your own launch →Incorrect prediction on native model
Similar products
Supersonic – A New UI for Postgres
PgModeler – EER Diagramming for postgres
Merging RethinkDB and Postgres with GraphQL
First experiment wih Vertx,Vue,Postgres
Logchain – ClickHouse/Postgres gRPC hook for logrus
pglockanalyze - See the locks your Postgres migrations will acquire
Apache Iceberg FDW for Postgres
FaultWall – Which tenant is killing your Postgres? Now you can find out
Now supporting MySQL, Postgres, Redis, Mongo
GraphQL for Postgres