Database Observability

关于

This skill enables developers to implement comprehensive database monitoring by providing standardized patterns for query tracing and connection pool metrics. It helps automate the detection of common issues like N+1 query patterns and slow SQL statements while ensuring data privacy through parameterized query logging. By applying the USE (Utilization, Saturation, and Errors) methodology to database interactions, it provides deep visibility into backend performance across multiple languages including Go, Python, Node.js, and Java.

主要功能

• Automated N+1 query detection and remediation guidance
• Standardized OpenTelemetry query span attributes for consistent tracing
• Real-time connection pool monitoring using the USE methodology
• Slow query identification with p95 threshold alerting
• Secure query logging patterns to prevent PII leakage
• 0 GitHub stars

使用场景

• Debugging latent database performance issues in production environments
• Implementing comprehensive connection pool metrics for load testing and scaling
• Refactoring legacy codebases to eliminate inefficient N+1 query patterns