Back to browse

SQL-tap now has a browser-based Web UI for real-time SQL monitoring

by mickamy·Feb 20, 2026·1 point·0 comments

AI Analysis

●●●BangerSolve My ProblemSlickDark Horse

SQL proxy with embedded Web UI—queries stream live, no deployment headaches.

Strengths
  • Transparent interception means zero code changes; drop in front of any database.
  • Dual UX (Web + TUI) with structured filtering, EXPLAIN, and analytics by query template.
  • Vanilla JS SPA baked into the binary eliminates deployment friction and external deps.
Weaknesses
  • Requires network position as proxy—doesn't help if you can't intercept traffic.
  • Comparison to Datadog, New Relic, or pg_stat_statements unclear—unclear what's net new.
Target Audience

Backend developers, database engineers, DevOps teams debugging SQL performance

Similar To

pgBadger · Datadog APM · New Relic

Post Description

Hi HN, I shared sql-tap here a few weeks ago — a transparent SQL proxy that captures every query and lets you inspect it in real-time. Thanks for the feedback last time.

The biggest addition: *a built-in Web UI*. Add `--http=:8080` and open your browser — queries stream in via SSE, you can click to inspect, run EXPLAIN, filter, and copy queries with args embedded. It's a vanilla JS SPA baked into the binary, so there's nothing extra to install or deploy.

Other updates since v0.0.1:

*TUI improvements* - Structured filter mode (`f`): `d>100ms`, `op:select`, `error`, combinable with AND logic - Analytics view (`a`): aggregate queries by template, sort by total/count/avg duration - Export to file (`w`): save captured queries as JSON or Markdown - Copy with bound args (`C`): substitutes `$1`/`?` placeholders with actual values - Sort by duration (`s`), half-page scrolling (`Ctrl+d`/`Ctrl+u`)

*Database support* - TiDB support (`--driver=tidb`) - MySQL 9 compatibility - Fixed PostgreSQL binary parameter decoding (UUIDs, etc.)

The proxy works the same way: point your app at sql-tapd instead of your database, no code changes needed. It parses the native wire protocol to capture queries, prepared statements, transactions, and errors transparently.

Written in Go, single binary, install via Homebrew (`brew install --cask mickamy/tap/sql-tap`) or `go install`. This is a solo side project — if you find it useful, a star on GitHub would mean a lot.

Similar Projects

Security●●Solid

Stateless, system-wide Transparent Tor Proxy for Linux (v0.1.0)

Atomic nftables rules prevent leaks, but TailsOS remains the gold standard for high-risk ops.

CozyShip It
onyks
201mo ago