skills.rest
alexmarucci
alexmarucciCOMMUNITY
Explore all skills by this author →
GitHub

database-monitoring

Query Datadog DBM performance metrics and create database monitors.

Updated Jan 14, 2022
Search Tags:#performance metrics#datadog#querying#database monitoring#dbm
One-click install
npx skills add https://github.com/alexmarucci/dotfiles --skill database-monitoring-alexmarucci
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: database-monitoring
Source: https://github.com/alexmarucci/dotfiles/tree/main/claude/skills/database-monitoring
Command: npx skills add https://github.com/alexmarucci/dotfiles --skill database-monitoring-alexmarucci

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill requires pup, and includes scripts (resource) and references (resource) components.

What problem does it solve?

This Skill streamlines the process of querying and managing Datadog Database Monitoring (DBM) data, including database metrics, query performance, and DBM-specific monitors, by automating the interaction with the Metrics API and Monitors API.

Core Features & Use Cases

  • Query Database Metrics: Retrieve performance metrics through the Metrics API.
  • Create DBM Monitors: Set up database-specific monitors for query performance, connection pools, and database health.
  • List Database Hosts: View databases being monitored in your infrastructure.
  • Analyze Query Performance: Help interpret database metrics and identify performance issues.
  • Monitor Configuration: Guide users on DBM setup and configuration.
  • Use Case: For example, when you need to check the connection count for a specific database in your infrastructure.

Quick Start

Use the database-monitoring skill to get the average connection count for the last hour for the database with host 'db-prod-01'.

Frequently Asked Questions about database-monitoring

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

FAQPage Schema
How do I query database performance metrics using Datadog DBM?▼

Retrieve database performance metrics through Datadog DBM by interacting with the Metrics API to query hosts and analyze query performance. You can extract specific metrics like average connection counts over defined time ranges for targeted infrastructure analysis.

Can I create DBM monitors for PostgreSQL and MySQL query performance?▼

Yes, you can create DBM monitors for PostgreSQL, MySQL, SQL Server, Oracle, and MongoDB. The Skill interacts with the Datadog Monitors API to set up alerts for query performance, connection pools, and overall database health.

What do I need to set up Datadog Database Monitoring for my infrastructure?▼

To set up Datadog Database Monitoring, you need valid Datadog API keys and an active DBM configuration. The Skill guides users through the monitor configuration and setup process for supported database technologies.

Does Datadog DBM work with MongoDB and Oracle databases?▼

Yes, Datadog DBM works with MongoDB and Oracle databases, alongside PostgreSQL, MySQL, and SQL Server. The Skill handles common database technologies to query metrics and manage monitors across these platforms.

What's the best way to analyze query performance issues in Datadog?▼

The best way to analyze query performance issues in Datadog is by querying DBM data through the Metrics API. This Skill helps interpret database metrics to identify performance bottlenecks and monitor connection pool health.

Why do I need Datadog API keys for database monitoring?▼

You need Datadog API keys for database monitoring because the Skill requires authentication to interact with the Metrics API and Monitors API. These keys enable secure retrieval of performance metrics and creation of DBM monitors.

Related Skills

Explore More Software Engineering Skills→
tbroadleytbroadley

datadog

Query and analyze Datadog logs, metrics, and monitors via the Datadog API.

Community
Intermediate
Proxy2021Proxy2021
5

api_monitor

Aggregate endpoint metrics, latency, and alert status to monitor API health.

Community
Advanced
alexmaruccialexmarucci

dd-apm

Analyze distributed tracing and service performance metrics with Datadog APM.

Community
Advanced
gemini-cli-extensionsgemini-cli-extensions
42

cloud-sql-postgres-monitor

Fetch PromQL metrics, EXPLAIN plans, and active queries for Cloud SQL PostgreSQL.

Official
Intermediate