MySQL
MySQL database integration for querying, inserting, updating, and deleting data
The MySQL integration lets your agents query, insert, update, and delete data in MySQL databases.
Prerequisites
You need:
- MySQL connection string — The connection URI for your MySQL instance (e.g.,
Server=myserver;Database=mydb;User Id=user;Password=pass;). This includes authentication credentials.
Setup
- Open Integrations from the sidebar
- Select MySQL from the catalog
- Click Add Integration Config
- Give the config a display name (e.g., "MySQL - Production")
- Enter your Connection String (stored encrypted)
- Save the config
No separate authentication setup is needed — credentials are embedded in the connection string.
Using in Your Agent
- Open your agent in Agent Studio and select an Agent Step
- Under Attached Integration Configurations, click Attach configuration and choose your config
- Attach MySQL tools from the tools panel
- Tools are referenced as
mysql.query,mysql.insert, etc.
Available Tools
| Tool | Description | Action Type |
|---|---|---|
list_tables | List all tables in the database | ReadOnly |
describe_table | Get the schema of a table | ReadOnly |
query | Execute a SELECT query | ReadOnly |
insert | Insert rows into a table | Reversible |
update | Update rows in a table | Reversible |
delete | Delete rows from a table | Irreversible |