Adding Databases

You can connect a database to your agent so it can access and use structured data. Zams supports MySQL, PostgreSQL, and SQL Server. This guide shows you how to add and configure a new database connection.

Prerequisites

Before you begin, ensure you have:

• Access to your database (MySQL, PostgreSQL, or SQL Server).

• Database credentials (host, username, password, database name, and port).

• Whitelist the following IP addresses in your database’s firewall/security settings:
  54.190.82.25 44.224.213.129 54.200.67.134 54.200.67.134

Important: You must whitelist the IP addresses provided in the setup window. Otherwise, Zams cannot connect to your database.

Steps

Step 1: Open the Add Data Window

1. Inside your agent, go to the Data tab.

2. Click Add Data.

Step 2: Select Database Type

1. In the Type dropdown, select Database.

2. In the Database dropdown, choose your database type:

• MySQL

• PostgreSQL

• SQL Server

Step 3: Whitelist IP Addresses

1. Copy the list of IP addresses displayed in the IP Addresses to Whitelist section.
   54.190.82.25 44.224.213.129 54.200.67.134 54.200.67.134

2. Add these IPs to your database’s whitelist or firewall configuration.

3. Save the changes in your database security settings.

Note: Without whitelisting, the connection will fail.

Step 4: Enter Connection Details

1. In Display Name, enter a name you will use to identify this connection.

2. Fill in your database details:

Step 5: Save and Test Connection

1. Click Connect.

2. If the connection is successful, your database will be linked to your agent.

3. Use tagging for referencing it on your prompts (e.g. @Sales Database)