Connect TimescaleDB and Grafana

Grafana ships with built-in Prometheus, PostgreSQL, Jaeger, and other data source plugins that allow you to query and visualize data from a compatible database. To add a data source in Grafana you must be signed as a user with organization administration role privileges.

To connect Grafana with TimescaleDB on Timescale Cloud, start by installing Grafana. For more information about installing Grafana, see the Grafana installation documentation.

Alternatively, to connect your Grafana service to MST with your TimescaleDB service on Timescale Cloud, create a Grafana service on MST. You can try it for free for 30 days.

This section shows you how to connect TimescaleDB on Timescale Cloud as a data source in Grafana.

Configure TimescaleDB as a data source

To configure TimescaleDB as a data source you need to create a service, and then configure TimescaleDB as the data source in Grafana.

Creating a TimescaleDB service

  1. Sign in to the Timescale Cloud portal.
  2. Click Create service.
  3. You can choose to build your service with or without demo data.
  4. Click Download the cheatsheet. This .sql file contains the credentials that you require to configure TimescaleDB as a data source on Grafana.

Try for free on Timescale Cloud

Your Timescale Cloud trial is completely free for you to use for the first thirty days. This gives you enough time to complete all our tutorials and run a few test projects of your own.

Try for free

Configuring TimescaleDB as data source

To configure TimescaleDB service on Timescale Cloud with your Grafana installation, log in to Grafana and proceed to step 5 in this procedure.

  1. In the MST account Services view, click the name of your new Grafana service.
  2. On the service details page, take a note of the User and Password field for your service.
  3. Click the link in the Service URI field to open Grafana.
  4. Log in to Grafana with your service credentials.
  5. Navigate to ConfigurationData sources. The data sources page lists previously configured data sources for the Grafana instance.
  6. Click Add data source to see a list of all supported data sources.
  7. Type PostgreSQL in the search field and click Select.
  8. Configure the data source:
    • In the Name field, type name that you would like for dataset on TimescaleDB.
    • In the PostgreSQL Connection section, type the Database, User, and Password fields using the .sql file that you downloaded when creating the TimescaleDB service.
    • In the Host type <HOST>:<PORT> from the .sql file that you downloaded.
    • Set TLS/SSL Mode as require.
    • In PostgreSQL details enable TimescaleDB
  9. Click Save & test button. If the connection is successful Database Connection OK appears.

When you have configured TimescaleDB as a data source in Grafana, you can create panels that are populated with data using SQL.

Found an issue on this page?

Report an issue!

Keywords

Related Content