
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







