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

# PostgreSQL

<Card title="Strong Security" icon="shield-check" iconType="sharp-solid" color="#49DE80">
  Brewit never has access to your database credentials. All credentials are
  encrypted and stored in AWS Secret Manager.
</Card>

## Connect your PostgreSQL database

<Steps>
  <Step title="Create">
    Create PostgreSQL connection
    [here](https://app.brewit.ai/resources/new/postgresql)
  </Step>

  <Step title="Configure">
    Information needed: Host, Port, Database Name, Username, Password
  </Step>

  <Step title="Test the connection">
    Click **Test Connection** button to verify that Brewit can successfully
    connect to PostgreSQL. If the test fails, check the data source settings and
    try again.
  </Step>

  <Step title="Save the resource">
    Click **Create** button to complete the setup. Now you can start chatting
    with Brewit's BI agent to analyze your data.
  </Step>
</Steps>

<Note>
  If your database has **SSL** or **SSH** tunnel enabled, please reach out to
  [mark@brewit.ai](mailto:mark@brewit.ai).
</Note>

## Whitelist Brewit's IP addresses

If the data source is behind a firewall or restricts access based on IP address, then you must ensure that Brewit can access it.
If necessary, configure your data source to allow access from Brewit's IP addresses.

Allow Brewit to read into your Microsoft SQL Server using the following IP addresses:

```
18.235.135.168
34.194.74.33
```