# database-observability

> Claude/Codex skill by [@grafana](https://omgskills.com/library/grafana/index.md) · 286 stars · Updated 2026-10-17

Set up Grafana Cloud Database Observability for MySQL and PostgreSQL — enables \`pg\_stat\_statements\` / Performance Schema, creates a least-privilege monitoring user, configures the \`database\_observability.postgres\` / \`database\_observability.mysql\` Alloy components, ships query samples + visual explain plans + RED metrics + schema details to Grafana Cloud, and correlates slow queries with application traces via \`db.statement\` / \`db.system\` OTel attributes. Use when monitoring database performance, diagnosing slow queries, setting up DB observability for RDS / Aurora / Cloud SQL / Azure Database / self-managed instances, correlating DB metrics with APM, or alerting on query latency — even when the user says "my database is slow", "find the slow queries", or "monitor RDS" without saying "observability".

## Install

```sh
git clone https://github.com/grafana/skills /tmp/skills && ln -s /tmp/skills/skills/grafana-cloud/database-observability ~/.claude/skills/database-observability
```

## From README

Grafana Cloud Database Observability Docs: https://grafana.com/docs/grafana-cloud/monitor-applications/database-observability/ Query-level insights (RED metrics, query samples, explain plans) for MySQL and PostgreSQL without application code changes. GA since April 2026. Common Workflows PostgreSQL Add the Alloy config block from references/alloy-config.md § PostgreSQL Restart Alloy and wait 60s for first scrape Verify in Grafana Cloud → Database Observability — the instance should appear with non-empty dbquerytotal{dbinstance="mydb"} series. If empty after 2 minutes: check Alloy logs for connection errors, then re-verify pgstatstatements permissions.

## Links

- HTML page: https://omgskills.com/library/grafana/skills/database-observability/
- GitHub: https://github.com/grafana/skills
- Author: [@grafana](https://omgskills.com/library/grafana/index.md)

## More from this repo

- [k6-docs](https://omgskills.com/library/grafana/skills/k6-docs/index.md) — Used to write or review k6 documentation across the three k6 repositories - k6-DefinitelyTyped (TypeScript types),...
   - [@grafana](https://omgskills.com/library/grafana/index.md) · 295 stars
- [adaptive-metrics](https://omgskills.com/library/grafana/skills/adaptive-metrics/index.md) — Cut Grafana Cloud Metrics cost by shrinking active-series count with Adaptive Metrics aggregation rules —...
   - [@grafana](https://omgskills.com/library/grafana/index.md) · 286 stars
- [admin](https://omgskills.com/library/grafana/skills/admin/index.md) — Used to manage Grafana Cloud accounts — organizations, stacks, RBAC roles and assignments, SSO/SAML/OAuth/GitHub auth,...
   - [@grafana](https://omgskills.com/library/grafana/index.md) · 286 stars