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.
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:
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:
Please fork it, extend it and make it fit for your own use-cases.