Integrate MySQL Tools

This guide walks you through configuring and authenticating the MySQL tools in Airia, enabling your agents to interact with your MySQL database.

Airia provides the following MySQL tools:

• MySQL Query Tool: To execute SQL queries against your MySQL database.
• MySQL Metadata Retrieval Tool: To retrieve schema metadata for your MySQL database.

Both tools are required for comprehensive interaction with your MySQL Database.

​

Supported MySQL Versions

Airia currently supports:

• MySQL Server version 8.0 and higher.

​

Prerequisites

To connect Airia to your MySQL server, you will need the following details:

• Hostname/Endpoint
• Port (default: 3306)
• Database name
• Basic Credentials:
  • User name
  • Password

💡 Note: These details can be retrieved from your MySQL server. For example, if your server is hosted on Azure, connection details can often be found on the connection page within the Azure portal.

​

Add and Configure MySQL Tools

Follow these steps to add and configure each MySQL tool:

1. Add a MySQL Tool:
   • Navigate to the Tools section in your Airia dashboard.
   • From the library, select the MySQL tool you wish to add (e.g., MySQL Query Tool).
2. Provide Connection Details:
   • On the tool configuration page, provide the following details:
     • Hostname/Endpoint: Your MySQL server’s hostname or IP address.
     • Port: The port number your MySQL server is listening on (default 3306).
     • Database name: The name of the database you want to connect to.
   • For User name and Password, set them as a Basic authentication credential.
3. Save the Tool:
   • Click Save to add the configured tool to your library.
4. Repeat for Other Tool:
   • Repeat steps 1-3 for the MySQL Metadata Retrieval Tool, providing the same connection values.

​

Next Steps

Now that your MySQL tools are added, you can integrate them into an agent to query your MySQL database.

• Use MySQL tools in an Agent

⚠️ Warning: Your MySQL server must be accessible by Public IP. If you encounter connectivity issues, contact support@airia.com. We can provide you with the necessary IP addresses to whitelist on your firewall.