MySQL
by MySQL
Connect to MySQL databases to query, insert, update, and manage data
How agents use MySQL
- ✓Agent queries a MySQL table to retrieve records needed as context before generating a response
- ✓Agent inserts workflow results — events, outputs, logs — into a table for persistence and auditability
- ✓Agent updates order status, inventory counts, or user data as part of an e-commerce workflow
- ✓Agent runs aggregation queries to compute metrics or summaries used in a reporting step
- ✓Agent performs a transactional write to ensure data consistency when multiple records must change together
Agent actions
Inputs: query, parameters
Returns: rows, rowCount, fields
Inputs: table, data
Returns: insertId, affectedRows
Inputs: query, parameters
Returns: affectedRows, changedRows
Inputs: query, parameters
Returns: affectedRows
Inputs: queries
Returns: results, success
Inputs: procedure, parameters
Returns: results
Inputs: table
Returns: columns, primaryKey, indexes
Inputs: table, data, batchSize
Returns: totalInserted, batches
Example workflows
User management system
Query and manage user data in MySQL
Analytics data warehouse
Store and query analytics data
E-commerce order processing
Manage orders, inventory, and customer data
About MySQL
- Vendor
- MySQL
- Pricing Always review details with the vendor
- Free — MySQL is open-source and free to use. Cloud hosting may have costs.
- Authentication
- Basic auth
- Compatible nodes
- AgentResourceInputOutput
- Website
- https://www.mysql.com
Build an AI workflow with MySQL
Use the Agentic Planner to design, visualize, and connect MySQL with your other tools.
Open Agentic PlannerRelated Databases tools
PostgreSQL
Connect to PostgreSQL databases to query, insert, update, and manage data
MongoDB
Connect to MongoDB databases to store, query, and manage document-based data
Pinecone
Upsert and query vector embeddings in Pinecone for retrieval-augmented generation (RAG), semantic search, and similarity matching in agent workflows.