Question 1

How do I set up sql-tap with Docker Compose?

Accepted Answer

Run sql-tap as a sidecar container using the Docker example from the README, which proxies ports like :5433 for PostgreSQL. You'll need to adjust your app's database connection to point to the proxy port instead of the direct database.

Question 2

sql-tap vs pgBadger for PostgreSQL monitoring?

Accepted Answer

sql-tap provides real-time, interactive monitoring with a TUI/web UI and requires no log parsing, while pgBadger analyzes PostgreSQL log files for historical reports. sql-tap is better for live debugging, whereas pgBadger suits post-mortem analysis.

Question 3

Does sql-tap work with cloud databases like Amazon RDS?

Accepted Answer

Yes, as long as the database uses PostgreSQL, MySQL, or TiDB wire protocols. Point sql-tapd's upstream flag to the RDS endpoint, but note that network latency and security groups might require additional configuration.

Question 4

How to disable N+1 detection in sql-tap?

Accepted Answer

Set the '--nplus1-threshold' flag to 0 when starting sql-tapd, as mentioned in the configuration section. This disables server-side detection entirely for all connected clients.

Question 5

Can sql-tap handle encrypted connections (SSL/TLS)?

Accepted Answer

The README shows DSN examples with 'sslmode=disable' for PostgreSQL, but it doesn't specify native SSL/TLS support in the proxy. You may need to ensure the proxy handles encryption or run it in trusted networks only.

Question 6

What's the performance overhead of running sql-tap?

Accepted Answer

As a proxy, it adds minimal latency from parsing and streaming queries, but the impact depends on query volume and system resources. It's designed for development/CI, not production, where overhead could affect high-load applications.

Question 7

How to export queries from sql-tap for further analysis?

Accepted Answer

In the TUI, press 'w' to export queries to JSON or Markdown files, as listed in the keybindings. This allows offline review or integration with other tools, though the web UI doesn't mention export features.

sql-tap

What is sql-tap?

Overview

Use Cases

Best For

Related Projects

Found a gem we're missing?

Not Ideal For

Pros & Cons

Pros

Cons

Frequently Asked Questions