Hey HN,<p>I’ve built a database gateway to provide controlled access to production databases with fine-grained permissions and secure query execution.<p>Key Features:<p>- Role-Based ACLs: Define access rules at the instance, table, and column levels.<p>- OIDC Authentication: Users log in through OpenID Connect.<p>- Multi-Instance Support: Query multiple PostgreSQL instances from a single interface.<p>- Web Interface: Execute approved queries and view results securely.<p>- Query Storage: Save query results for later access or export.<p>How It Works:<p>- Users authenticate via OIDC.<p>- ACLs enforce access to specific instances, tables, and columns.<p>- Approved queries are executed, and results are stored securely.<p>Built For:<p>- Developers who debug production data.<p>- Team Leads and Product Owners who access production data for reporting.<p>- DevOps who run queries on behalf of other roles.<p>- Security Engineers who ensure sensitive production data remains protected.<p>Question: How do your developers access production databases, especially when the data is sensitive and critical to the company?