> ## 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.

# MySQL

<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 MySQL database

<Steps>
  <Step title="Create">
    Create MySQL connection [here](https://app.brewit.ai/resources/new/mysql)
  </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 MySQL. 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
```