Supabase Prometheus Metrics & Grafana

1. Setup Accounts

Create an account on Grafana (https://grafana.com)
Create an account on Fly.io (https://fly.io)
You should already have a Supabase account and a Supabase project

2. Deploy the Grafana Agent on Fly.io

2A. Create the app

Change the app name in the fly.toml
Install the flyctl command-line tool: flyctl installation instructions
Log into fly: flyctl auth login
Create your fly app: flyctl apps create
- use the app name you added to fly.toml

2B. Gather the necessary secrets

SUPABASESERVICEROLESECRET
- Supabase service role secret
- found here: https://supabase.com/dashboard/project/_/settings/api
SUPABASEPROJECTURL
- Supabase project url
- found here: https://supabase.com/dashboard/project/_/settings/api
- exclude the https:// part, for example: zzzzzzzzzzzzzzzzzzzz.supabase.co
REMOTEWRITEENDPOINT
- Grafana prometheus remote write endpoint
- Grafana Cloud / My Account / Prometheus Details / (Remote Write Endpoint)
REMOTEUSERNAME
- Grafana prometheus Username
- Grafana Cloud / My Account / Prometheus Details / (Username / Instance ID)
REMOTEWRITEPASSWORD
- Grafana prometheus remote write password
- Grafana Cloud / My Account / Prometheus Details / (Password / API Key) / Generate now
Set your fly.io secrets in the script: set_secrets.sh
Set your fly secrets by executing the script: ./set_secrets.sh

2C. Deploy the `Grafana Agent App` on `fly.io`

This app will gather data from your Supabase project once per minute and ingest it into Grafana Cloud.

Deploy your fly app: fly deploy --config fly.toml

3. Create the Grafana Dashboard

Grafana Cloud / My Account / Grafana / Launch
Menu / Dashboards / New / Import
Upload JSON file: panels-full.json

Useful Links

https://grafana.com/docs/agent/latest/getting-started/create-config-file/

Exported metrics:

A list of exported metrics can be found here