🐘📊

Database Monitoring Dashboard

Intermediate

Monitoring

Stream Postgres metrics — query latency, lock waits, vacuum stats — into Grafana for a live operations dashboard.

MCPs Required

🐘Postgres📊Grafana

Workflow Steps

  1. 1
    Enable pg_stat_statements extension
  2. 2
    Scrape slow queries every 60 seconds
  3. 3
    Export metrics to Grafana via Postgres data source
  4. 4
    Set alert threshold for p99 query time
  5. 5
    Page on-call when SLO is breached

More Monitoring Recipes

💬🟢

Database Change Alerts

Get a Slack alert whenever a critical Supabase table row is created, updated, or deleted — ideal for audit trails.

🐛💬

Error Alerting Pipeline

Sentry new issues are de-duplicated, enriched with commit info, and routed to the right Slack channel based on project.

📊💬

Alert Routing from Grafana

Grafana alerts are enriched with runbook links and routed to the correct Slack channel based on severity and team labels.

🟡📊

Analytics Dashboard

Connect ClickHouse to Grafana to build real-time analytics dashboards over billions of events with sub-second query times.

Ready to build this workflow?

Install the MCPs from the marketplace and start automating in minutes.

🐘Install Postgres📊Install Grafana