Connecting Your PostgreSQL Database
SaturnSQL connects directly to your PostgreSQL databases. Here's how to add a connection and start querying.
Connection details you'll need
To connect, you'll need the following information from your database provider or infrastructure team:
- Host – The database server address (e.g., db.example.com)
- Port – Usually 5432 for PostgreSQL
- Database name – The specific database to connect to
- Username – Your database user
- Password – Your database password
SSL connections
SaturnSQL supports SSL-encrypted connections. If your database requires SSL (most cloud databases do), enable the SSL option when adding your connection. This ensures all data transferred between SaturnSQL and your database is encrypted.
Testing your connection
After entering your details, click "Test Connection" to verify everything works. If the test fails, double-check your credentials and ensure your database allows connections from SaturnSQL's IP addresses.