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 your agent in Agent Studio
- In the Integrations panel, click Add Integration Config
- Select MySQL from the integration list
- Give the config a display name (e.g., "MySQL - Production")
- Enter your Connection String (stored encrypted)
- Save the agent revision
No separate authentication setup is needed — credentials are embedded in the connection string.
Using in Your Agent
- In an Agent Step, attach MySQL tools from the tools panel
- The agent uses your integration config for all MySQL operations
- 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 |