HN Showcase
Back to browse
GitHub Repository

Self-hosted collaborative SQL editor for teams

2 starsTypeScript

Self-hosted collaborative SQL editor for teams

by joddystreet·May 26, 2026·1 point·0 comments
Visit ProjectView on HN

AI Analysis

●●SolidShip ItSolve My Problem

Turns saved SQL queries into authenticated API endpoints instantly.

Strengths
  • •Query-as-API feature exposes SQL logic as HTTP endpoints with typed params.
  • •Built-in audit logs and GitHub SSO address strict enterprise security needs.
  • •AG Grid integration provides robust sorting and filtering for large datasets.
Weaknesses
  • •Only supports PostgreSQL and ClickHouse, missing MySQL and SQL Server.
  • •Self-hosted admin burden competes with polished SaaS like DataGrip.
Target Audience

Data teams requiring on-premise SQL collaboration tools

Similar To

PopSQL · DBeaver · Metabase

Post Description

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.

Similar Projects

Developer Tools●●Solid

DB Pro Studio – A self-hosted, collaborative database client

Runs in the browser, ships as a Docker image, and emphasizes shared connections, collaborative queries and dashboards — nice for teams that want DB access without handing out credentials. The UI in the screenshot looks thoughtful (mobile-ready panels, query editor, change diffs), but the product sits in a crowded niche; the site should call out concrete differentiators like RBAC, audit logging, connection pooling or performance to justify switching from existing tools.

SlickSolve My Problem
upmostly
104mo ago