Data Sources
Warehouses
PostgreSQL

PostgreSQL

Connect Compass to your PostgreSQL database to analyze data through natural language queries in Slack.

Setup Instructions

  • Contact your database administrator for connection details
  • Request a read-only database user account
  • Ensure your network allows connections from Compass IP addresses
  • Test connection using standard PostgreSQL client tools

Required PostgreSQL Permissions

  • CONNECT privilege on database – Establish connections
  • USAGE on schema – Access schema objects
  • SELECT on tables – Query table data for analysis

Network Information

Connection Method: PostgreSQL protocol over port 5432

IP Addresses: 52.25.53.27, 44.242.128.111, 52.35.195.86

May require firewall allowlisting or VPN access

Connecting to Compass

  1. Go to dagstercompass.com/login (opens in a new tab) or type !admin in your Compass Slack channel
  2. Click Add Connection → PostgreSQL
  3. Enter your connection details:
    • Host
    • Port (usually 5432)
    • Database name
    • Username
    • Password
    • Schema (optional)
  4. Click Test Connection to verify
  5. Click Save to complete setup

Need Help?

DatabricksTrino