|
|
|
Show HN: Self-hosted collaborative SQL editor for teams
(github.com)
|
|
1 points
by joddystreet
22 days ago
|
|
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. |
|