Covers the essentials for keeping tabs on database health, from connection counts and query duration to index usage and lock contention. The queries here are PostgreSQL-focused but the monitoring principles apply broadly. You'll want this when you're setting up observables for the first time, diagnosing slow queries, or building dashboards to catch problems before they wake you up. The reference guides break down connection monitoring, query performance, and table/index metrics into copy-paste examples. It's practical stuff, though you'll still need to wire these queries into whatever monitoring stack you're actually running.
npx skills add https://github.com/aj-geddes/useful-ai-prompts --skill database-monitoring