Set up Timescale and Grafana

Add Timescale as a data source in Grafana

You can use Grafana to visualize queries directly from your Timescale database.

Before you begin, make sure you have:

Created a Timescale Cloud service.
Installed a self-managed Grafana account, or signed up for Grafana Cloud.
Found the connection details for the database you want to use as a data source. The details are contained in the cheatsheet you downloaded when you created the service.

Self-hosted Grafana

Grafana Cloud

In your web browser, log in to the Grafana dashboard at http://localhost:3000/. The default username is admin with a default password of admin.
In the Grafana dashboard, navigate to Configuration → Data sources. Click Add data source.
In the Add data source page, search for PostgreSQL, and select it.
Configure the data source using your connection details:
- In the Name field, type a name to use for the dataset.
- In the Host field, type the host and port for your connection, in this format: <HOST>:<PORT>. For example, example.tsdb.cloud.timescale.com:35177.
- In the Database field, type tsdb.
- In the User field, type tsdbadmin, or another privileged user.
- In the Password field, type the password.
- In the TLS/SSL Mode field, select require
- In the PostgreSQL details section, toggle TimescaleDB on.
- All other fields can be left as default values.
Click Save & test to check your details have been set correctly.