> ## Documentation Index
> Fetch the complete documentation index at: https://docs.evidence.studio/llms.txt
> Use this file to discover all available pages before exploring further.

# PostgreSQL

> PostgreSQL is one of the world's most widely used open-source relational databases. Evidence syncs your PostgreSQL data automatically, keeping your reports up to date.

## Add New Connector

To add a PostgreSQL connector:

1. Select **Connectors** in the left sidebar and click "New Connector"
2. Select **PostgreSQL** from the list of connectors
3. Fill in the connection details below and click "Create Connector"
4. Select the schemas and tables you want to sync
5. Configure your sync schedule

<Note>
  Your PostgreSQL database must have TLS/SSL enabled. Evidence requires encrypted connections for security.

  If you're using Supabase, enable "Enforce SSL on incoming connections" in your database settings. See [Supabase SSL Enforcement](https://supabase.com/features/ssl-enforcement) for details.
</Note>

## Connection Options

<ResponseField name="Host" type="text" required>
  The hostname or IP address of your PostgreSQL server. For Supabase, use the Session Pooler connection string from your project's database settings.
</ResponseField>

<ResponseField name="Port" type="number" required>
  The port number for your PostgreSQL server
</ResponseField>

<ResponseField name="User" type="text" required>
  The username for database authentication
</ResponseField>

<ResponseField name="Password" type="password" required>
  The password for database authentication
</ResponseField>

<ResponseField name="Database" type="text" required>
  The name of the database to connect to
</ResponseField>

<ResponseField name="Connection Type" type="select" required>
  How to connect to your database
</ResponseField>

<ResponseField name="Trust SSL/TLS Certificates" type="checkbox">
  Automatically trust the server's SSL/TLS certificates. Enable this for cloud databases like Supabase, AWS RDS, or other providers that use custom certificate authorities.
</ResponseField>

### SSH Tunnel Options

If using SSH Tunnel connection type:

<ResponseField name="SSH Host" type="text" required>
  The hostname of your SSH server
</ResponseField>

<ResponseField name="SSH Port" type="number" required>
  The port number for SSH connection
</ResponseField>

<ResponseField name="SSH User" type="text" required>
  The username for SSH authentication
</ResponseField>

## Additional Resources

* [Fivetran PostgreSQL Documentation](https://fivetran.com/docs/connectors/databases/postgresql)