Connections

Connections allow you to link your PostgreSQL database to Telemetry. Once connected, you can write queries against your database and display the results in your apps.

​

Setting up a connection

To create a new connection:

1. Navigate to the Connections page
2. Click “New Connection”
3. Enter your database credentials:
   • Host — Your database host (e.g., db.example.com)
   • Port — Usually 5432 for PostgreSQL
   • Database — The database name
   • Username — Database user
   • Password — Database password
4. Click “Test Connection” to verify
5. Save your connection

​

Connection security

Your database credentials are encrypted and stored securely. Telemetry uses SSL connections to communicate with your database. Best practices:

• Use a dedicated database user with limited permissions
• Grant only SELECT permissions for read-only dashboards
• Use SELECT, INSERT, UPDATE permissions for data entry apps
• Avoid using your root database user

​

Supported databases

Currently, Telemetry supports:

• PostgreSQL

​

Connection per organization

Connections are scoped to your organization. All apps and queries within an organization can access the organization’s connections.

​

Troubleshooting

​

Connection refused

• Verify your host and port are correct
• Check that your database allows connections from external IPs
• Ensure your firewall allows inbound connections on the database port

​

Authentication failed

• Double-check your username and password
• Verify the user has permission to access the specified database

​

SSL required

• Telemetry requires SSL connections
• Ensure your database is configured to accept SSL connections