How to Connect Grafana to a Streaming Database

How to Connect Grafana to a Streaming Database

#

Grafana connects to RisingWave as a PostgreSQL data source — no plugins needed. Materialized views update in real time, so your Grafana dashboards show live streaming data without manual refresh.

Setup Steps

1. Add PostgreSQL Data Source in Grafana

  • Go to Configuration → Data Sources → Add → PostgreSQL
  • Host: risingwave-host:4566
  • Database: dev
  • User: root
  • SSL Mode: disable (or configure TLS)

2. Create a Dashboard Panel

-- Example query for Grafana panel
SELECT window_start as time, event_type, count as value
FROM events_per_minute
ORDER BY window_start DESC
LIMIT 100;

3. Set Auto-Refresh

Set dashboard auto-refresh to 5-10 seconds. RisingWave materialized views are always current, so every refresh shows the latest data.

Tips

  • Use $__timeFilter(time_column) for Grafana time range integration
  • Materialized views are pre-computed — queries are fast (10-20ms)
  • No need for separate cache or API layer

Frequently Asked Questions

Does Grafana support RisingWave natively?

Grafana connects to RisingWave via the built-in PostgreSQL data source. No special plugin needed. Any query that works in psql works in Grafana.

Best-in-Class Event Streaming
for Agents, Apps, and Analytics
GitHubXLinkedInSlackYouTube
Sign up for our to stay updated.