I built a self-hostable web-based sql client interfaces for me and my team.

We were using the community version of - https://dbeaver.io, but we needed a few more features and an improved editor. PopSQL was a modern take on web based sql editor, but it didn't fit into the infra security setup we have.

We needed:

  - SSO
  - Audit logs
  - Modern editor (https://www.pgcli.com/ like hints)
  - Sharable queries
  - Explain queries (https://explain.dalibo.com/ embedded)
  - Query as API service
  - Schema exploration (https://dbdiagram.io/ embedded)
  - Fixed client IP

With the help of Copilot + GPT-5.5 + GPT-5.4, I was able to build this and have been using in-house since a couple of months now. Presently, it only supports PostgreSQL and ClickHouse.

The Roadmap:

  - Scheduled queries
  - Query pipeline and workflows
  - Embeddable Dashboard builder
  - Edge AI Assistant — Browser-local LLM for query explanation and generation
  - More database drivers — SQLite, Duckdb, Redis

Please fork it, extend it and make it fit for your own use-cases.