db-performance-watchlist
Monitors database performance with slow query detection, resource usage alerts, and automated alerting for optimal efficiency.
Install this skill
Security score
The db-performance-watchlist skill was audited on Feb 9, 2026 and we found 29 security issues across 1 threat category. Review the findings below before installing.
Categories Tested
Security Issues
Template literal with variable interpolation in command context
| 76 | await prisma.$executeRaw` |
Template literal with variable interpolation in command context
| 82 | const slowQueries = await prisma.$queryRaw<SlowQuery[]>` |
Template literal with variable interpolation in command context
| 99 | console.log(`${i + 1}. ${q.query.substring(0, 80)}...`); |
Template literal with variable interpolation in command context
| 100 | console.log(` Calls: ${q.calls}`); |
Template literal with variable interpolation in command context
| 101 | console.log(` Avg: ${q.avg_time_ms.toFixed(2)}ms`); |
Template literal with variable interpolation in command context
| 102 | console.log(` Max: ${q.max_time_ms.toFixed(2)}ms`); |
Template literal with variable interpolation in command context
| 103 | console.log(` % of total time: ${q.percent_of_total.toFixed(1)}%\n`); |
Template literal with variable interpolation in command context
| 131 | ` Total: ${total_connections}/${max_connections} (${utilization.toFixed( |
Template literal with variable interpolation in command context
| 135 | console.log(` Active: ${active}`); |
Template literal with variable interpolation in command context
| 136 | console.log(` Idle: ${idle}`); |
Template literal with variable interpolation in command context
| 143 | message: `${utilization.toFixed(1)}% of connections in use`, |
Template literal with variable interpolation in command context
| 178 | console.log(` CPU: ${cpuStats[0].cpu_percent.toFixed(1)}%`); |
Template literal with variable interpolation in command context
| 179 | console.log(` Database Size: ${memStats[0].db_size}`); |
Template literal with variable interpolation in command context
| 180 | console.log(` Cache Hit Rate: ${cacheStats[0].cache_hit_rate.toFixed(1)}%`); |
Template literal with variable interpolation in command context
| 187 | message: `Cache hit rate: ${cacheStats[0].cache_hit_rate.toFixed(1)}%`, |
Template literal with variable interpolation in command context
| 212 | console.log(` ${idx.tablename}.${idx.indexname} (0 scans)`); |
Template literal with variable interpolation in command context
| 233 | console.log(` ${table.tablename}:`); |
Template literal with variable interpolation in command context
| 234 | console.log(` Sequential scans: ${table.seq_scan}`); |
Template literal with variable interpolation in command context
| 235 | console.log(` Rows: ${table.n_live_tup}`); |
Template literal with variable interpolation in command context
| 236 | console.log(` Index scans: ${table.idx_scan}`); |
Template literal with variable interpolation in command context
| 280 | message: `${metrics.slowQueries.count} queries exceeding ${ALERT_THRESHOLDS.slowQuery.avgDuration}ms`, |
Template literal with variable interpolation in command context
| 292 | message: `${metrics.connections.utilizationPercent.toFixed( |
Template literal with variable interpolation in command context
| 303 | message: `${metrics.cache.hitRate.toFixed(1)}% hit rate`, |
Template literal with variable interpolation in command context
| 319 | console.log(`Slow Queries (>100ms): ${slowQueries.length}\n`); |
Template literal with variable interpolation in command context
| 346 | console.log(` Transactions: ${queryStats[0].transactions}`); |
Template literal with variable interpolation in command context
| 347 | console.log(` Rows read: ${queryStats[0].rows_read}`); |
Template literal with variable interpolation in command context
| 348 | console.log(` Rows inserted: ${queryStats[0].rows_inserted}`); |
Template literal with variable interpolation in command context
| 349 | console.log(` Rows updated: ${queryStats[0].rows_updated}`); |
Template literal with variable interpolation in command context
| 350 | console.log(` Rows deleted: ${queryStats[0].rows_deleted}`); |