Grafana Dashboard Design & Query Optimization
Design and optimize Grafana dashboards with AI-guided queries
What You Can Do
Create production-ready Grafana dashboards that visualize your metrics effectively and perform efficiently. Claude helps you write optimized PromQL and other database queries, configure smart alerts with custom thresholds, and design intuitive layouts that surface the metrics that matter most. You get dashboard JSON, query recommendations, and alert configurations ready to deploy.
Features
Automatically create dashboards with the right chart types (graphs, gauges, tables, heatmaps)
Write efficient PromQL, SQL, and other query languages with proper aggregation and scrape intervals
Configure alerts with appropriate severity levels, notification routing, and escalation logic
Build interactive navigation between dashboards for root-cause analysis
Add context markers for deployments, incidents, and SLO changes
Recommend retention policies, sampling strategies, and dashboard refresh rates
Example Output
Example 1: Dashboard JSON Output
{
"dashboard": {
"title": "Service Health Overview",
"panels": [
{
"title": "Request Latency (p95)",
"targets": [{
"expr": "histogram_quantile(0.95, rate(http_request_duration_seconds_bucket[5m]))"
}],
"type": "graph"
},
{
"title": "Error Rate",
"targets": [{
"expr": "rate(http_requests_total{status=~\"5..\"}[5m])"
}],
"type": "stat"
}
]
}
}
Example 2: Alert Rule Configuration
alert:
name: "High Error Rate"
expr: 'rate(http_requests_total{status=~"5.."}[5m]) > 0.05'
for: "5m"
severity: "critical"
annotations:
description: "Error rate exceeds 5% for the past 5 minutes"
runbook: "https://wiki.example.com/error-rate"
Example 3: Query Optimization
Before: rate(http_request_duration_seconds_sum[5m]) / rate(http_request_duration_seconds_count[5m])
After: histogram_quantile(0.95, rate(http_request_duration_seconds_bucket[5m])) — More efficient, uses precomputed buckets
What's Included
- SKILL.md: Complete skill instructions for Claude with dashboard design patterns and query optimization strategies
- Dashboard Templates: Pre-built JSON templates for common scenarios (service health, database monitoring, infrastructure)
- Query Reference: PromQL, SQL, and Loki query patterns with explanations
- Alert Configuration Checklist: Step-by-step guide for designing effective alert rules
- Performance Tuning Workflows: Decision trees for optimization strategies based on query type and data volume
Who It's For
- DevOps and SRE engineers — Build monitoring dashboards for systems and services
- Platform engineers — Design standardized observability platforms for teams
- Database administrators — Create performance monitoring and query health dashboards
- Security and compliance teams — Build security event monitoring and audit dashboards
- Product analytics teams — Design KPI and business metric dashboards
Best For
- Creating new Grafana dashboards from scratch
- Optimizing slow or resource-heavy queries
- Designing alert rules with business-appropriate thresholds
- Troubleshooting dashboard performance and refresh times
- Standardizing dashboard layouts across teams
You might also like
You can instantly generate engaging captions, story arcs, and pitch-ready copy for your sports photography. Whether you're covering a championship game, developing a photo essay series, or submitting work to media outlets, this skill crafts deadline-ready narratives that showcase your images and hook editors. Transform raw photos into publication-quality coverage with professional storytelling that brings readers into the defining moments of athletic competition.
by manwithstyle
You can design comprehensive Datadog monitoring strategies that transform raw metrics into actionable intelligence. Claude helps you architect dashboards that surface critical insights, configure intelligent alerts that reduce false positives, and build escalation workflows that speed up incident response. The result: measurably lower MTTR and a team that trusts your alerts.
by manwithstyle
You can transform complex datasets into compelling interactive narratives that maintain coherence while inviting exploration. This skill helps you architect data-driven stories where insights unfold naturally through guided discovery points, keeping readers engaged without limiting their agency. Readers navigate your narrative with purpose, uncovering patterns and relationships that would remain hidden in static presentations.
by manwithstyle
Transform breaking news briefs into compelling visual story frameworks that guide photographers toward impactful coverage. You'll receive multiple narrative angles, detailed shot lists organized by scene and purpose, and complete assignment briefs with sourcing guidance. Each output ensures comprehensive emotional and contextual storytelling from first frame to final edit.
by manwithstyle
Analyze Docker container logs instantly to identify root causes of failures, crashes, and resource bottlenecks. Get actionable recommendations for resource allocation, network configuration, and architectural improvements that eliminate production issues before they cascade.
by manwithstyle
Systematically analyze your AWS accounts to identify cost optimization opportunities, security gaps, and performance bottlenecks. You'll receive prioritized, actionable recommendations tailored to your architecture, from EC2 right-sizing to unused resource cleanup and security hardening.
by manwithstyle
This skill walks you through a structured data analysis workflow—from initial exploration and claim verification to identifying compelling story angles and building evidence-backed narratives. You'll learn to spot anomalies, validate statistics, and construct defensible arguments that stand up to scrutiny. It's designed for journalists who want to move beyond surface-level data work into serious investigative storytelling.
by manwithstyle
Accelerate your beat reporting by organizing research, identifying story angles, discovering sources, and developing narrative frameworks. You can quickly synthesize complex topics, spot emerging trends, and prepare comprehensive story outlines that anchor your reporting. This skill helps you go deeper on your beat with less time spent on research logistics.
by manwithstyle