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

Ready to run

npx skills add https://github.com/allthingslinux/atl.services --skill database-monitoring

💬 Prompt for ChatGPT / Claude Chat▼

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.