Grafana

Accessible over the internet, Google authentication only.

https://grafana.telemetry.slamcore.com/ (click Sign in with Google and connect your slamcore.com Google Workspace account).

Direct database access

Read-only, only possible from the office network, either physically or with the exit node configured to route all traffic through tailscale. If you need this, ask someone to share the password with you, via 1Password or any other way.

Python

import psycopg
conn = psycopg.connect(
    host="db.telemetry.slamcore.com", port=5432, dbname="postgres",
    user="analysis", password="<password>",
    sslmode="verify-full", sslrootcert="system")
rows = conn.execute("SELECT * FROM sessions LIMIT 100").fetchall()

Pandas

import pandas as pd
from sqlalchemy import create_engine
engine = create_engine(
    "postgresql+psycopg://analysis:<password>@db.telemetry.slamcore.com:5432/postgres"
    "?sslmode=verify-full&sslrootcert=system")
df = pd.read_sql("SELECT * FROM sessions LIMIT 100", engine)

psql CLI

psql "postgresql://analysis:<password>@db.telemetry.slamcore.com:5432/postgres?sslmode=verify-full&sslrootcert=system"