---

name: database-observability description: "Instrument database queries, connection pools, and detect N+1 queries" triggers:

• "instrument database"
• "trace queries"
• "database metrics"
• "connection pool monitoring"
• "slow query detection" priority: 2

---

Database Observability

Database is often the bottleneck. Track queries, pools, and patterns.

Query Span Attributes

Connection Pool Metrics (USE)

Issues to Detect

Query Wrapper Pattern

CopyBefore: Start span (db.system, db.operation, db.sql.table), start timer
After:  Record duration, set db.rows_affected, record errors, end span

Pool Monitor Pattern

CopyEvery 10s: Record active, idle, wait_count, wait_duration from pool stats

Anti-Patterns

• Full SQL with values → PII risk, use parameterized only
• No pool metrics → Can't detect saturation
• Missing slow query alerts → Problems go unnoticed

References

• references/methodology/use-methodology.md
• references/platforms/{platform}/database.md