Grafana

Grafana can visualize data stored in SereneDB using the built-in PostgreSQL data source.

Setup

1. Install and start Grafana following the official guide
2. Navigate to Connections > Data sources > Add data source
3. Select PostgreSQL
4. Enter the connection details:

Field	Value
Host	localhost:7890
Database	postgres
User	postgres
Password	leave empty for a local server; otherwise the role password
TLS/SSL Mode	disable

5. Click Save & test

Create a dashboard

1. Create a new dashboard and add a panel
2. Select your SereneDB data source
3. Write a raw SQL query — for example:

SQL

SELECT published_at AS time, viewsFROM articlesORDER BY published_at;

 time       | views
------------+-------
 2025-01-15 |  4200
 2025-03-01 |  5100

4. Choose a visualization type (Time series, Bar chart, Table, etc.)

note

The interactive query builder is currently not supported. Use raw SQL queries.