skills.rest
allthingslinux
allthingslinuxOFFICIAL
Explore all skills by this author →
GitHub

database-monitoring

Monitor PostgreSQL and MySQL health with structured queries and alerting rules.

1|Updated Feb 5, 2026
Search Tags:#monitoring#database#metrics#PostgreSQL#MySQL#alerts#health-checks
One-click install
npx skills add https://github.com/allthingslinux/atl.services --skill database-monitoring
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: database-monitoring
Source: https://github.com/allthingslinux/atl.services/tree/main/.agents/skills/database-monitoring
Command: npx skills add https://github.com/allthingslinux/atl.services --skill database-monitoring

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

This Skill helps teams implement robust database monitoring to detect performance issues, track health, and automate alerting for PostgreSQL and MySQL environments.

Core Features & Use Cases

  • Query performance monitoring: Identify slow queries, optimize execution, and monitor critical workloads.
  • Connection and health checks: Track active connections, idle transactions, and replication health to maintain service levels.
  • Table & index health analysis: Assess table sizes, dead tuples, and index usage to prevent bloat and degradation.
  • Alerts & baseline planning: Design starter alerting rules and health checks aligned with SLAs.
  • Use Case: Imagine you run a PostgreSQL cluster with rising latency; this skill guides you to instrument metrics, inspect top queries, and configure alerts to catch regressions early.

Quick Start

Set up baseline metrics collection for a PostgreSQL server and create starter alert rules for high connections and long-running queries.

Frequently Asked Questions about database-monitoring

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I monitor PostgreSQL and MySQL query performance?▼

To monitor query performance, this Skill helps you identify slow queries, optimize execution plans, and track critical workloads using structured SQL tuning concepts and common monitoring queries for PostgreSQL and MySQL environments.

What database health checks should I run for active connections and replication?▼

Database health checks involve tracking active connections, identifying idle transactions, and monitoring replication health to maintain service levels, providing structured guidance to assess connection metrics across development, staging, and production environments.

How do I assess table bloat and index usage in PostgreSQL?▼

Assess table and index health by analyzing table sizes, dead tuples, and index usage metrics to prevent bloat and performance degradation, using structured monitoring guidance to evaluate storage and query efficiency.

Can I use this for setting up database monitoring across staging and production?▼

Yes, this Skill supports implementing robust database monitoring to detect performance issues and automate alerting across development, staging, and production environments, requiring knowledge of common monitoring queries and SQL tuning concepts.

What's the best way to start with proactive database monitoring?▼

The best way to start is setting up baseline metrics collection for a database server and creating starter alert rules for high connections and long-running queries to establish proactive health monitoring.

Related Skills

Explore More Data & Analytics Skills→
bingeli1379bingeli1379
2

sql-optimization

Analyzes and optimizes SQL queries across multiple database platforms and dialects.

Community
Advanced
EstomEstom

database-optimizer

Analyze slow PostgreSQL and MySQL queries and optimize execution plans.

Community
Advanced
EngineerWithAIEngineerWithAI
4

grafana-dashboards

Generate and manage Grafana dashboards for real-time system and application metric visualization.

Official
Intermediate
odeciojuniorodeciojunior

sql-server-toolkit

Route SQL Server tasks to specialist agents for diagnostics, tuning, and review.

Community
Intermediate