TimescaleDB
Connect a TimescaleDB database with a connection string over TLS.
Reads tables from a TimescaleDB database. TimescaleDB is a PostgreSQL extension, so it connects exactly like a Postgres database and hypertables appear as regular tables. Flitch only issues read queries, so it can never write to your database.
Add a source
TimescaleDB supports a connection string (a database user over TLS).
Prerequisites
- A reachable TimescaleDB host and database (Timescale Cloud or self-hosted).
- A user with read access to the tables you want.
Create a read-only user
CREATE USER flitch_readonly WITH PASSWORD 'choose-a-strong-password';
GRANT CONNECT ON DATABASE mydb TO flitch_readonly;
GRANT USAGE ON SCHEMA public TO flitch_readonly;
GRANT SELECT ON ALL TABLES IN SCHEMA public TO flitch_readonly;Build the connection string
On Timescale Cloud, copy the connection info from the service's Connection info panel.
postgresql://flitch_readonly:password@xxx.tsdb.cloud.timescale.com:5432/mydb?sslmode=requireOpen the form
Go to Data → Add → TimescaleDB, paste the connection string, then pick datasets.
Network access
Flitch connects from its own server, not your browser, so if your database is behind a firewall you must allow Flitch's connector egress IP (shown in the Add Source form) on the database port. Publicly reachable hosts need no change.
Team-wide credential (optional)
A team admin can store one shared credential in Settings → Data connections; new connections then default to it, with no per-connection secret.
Refresh
Refresh is off by default. Enable it to schedule a background refresh and serve from cache between runs. See Refresh.
Troubleshooting
Connection timed out / refused. Verify host and port, and that the egress IP is allowlisted.
Authentication failed. Check the user and password, and that the user can connect from Flitch's host.
SSL required. Keep sslmode=require; Timescale Cloud enforces TLS.