SQL-tap – Real-time SQL traffic viewer for PostgreSQL and MySQL
Wire-protocol parsing needs zero code changes; competes against established query inspectors.
SQL proxy with embedded Web UI—queries stream live, no deployment headaches.
Backend developers, database engineers, DevOps teams debugging SQL performance
pgBadger · Datadog APM · New Relic
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.
Wire-protocol parsing needs zero code changes; competes against established query inspectors.
Subdomain routing means zero /etc/hosts edits—just change base_url and capture everything.
Atomic nftables rules prevent leaks, but TailsOS remains the gold standard for high-risk ops.
Searchable encryption running queries over ciphertext faster than AWS KMS direct.
Skip the restore—query old database states from snapshots in seconds instead of hours.
Wireshark-in-terminal with TCP reassembly, GeoIP, and htop-style UX. 20-year pro's tool.