Mysql

What it does

This skill allows AI agents to interact with and manage MySQL databases. It facilitates tasks such as executing SQL queries, retrieving data, creating tables, and updating existing records. The agent can use this skill to perform database operations based on natural language instructions.

When to use it

• Data Retrieval: When you need the agent to fetch specific information from a MySQL database (e.g., "Get me all customers in California").
• Report Generation: To generate reports by querying and aggregating data stored within a MySQL database.
• Database Updates: When you want the agent to modify data, such as updating customer addresses or adding new products.
• Schema Management: To create or alter tables and other database objects based on your instructions.

Key capabilities

• SQL query execution
• Data retrieval from MySQL databases
• Database schema modification (table creation/alteration)
• Data updates within the database

Example prompts

• "Find all orders placed after January 1st, 2023."
• "Create a table called 'products' with columns for name, price, and description."
• "Update the email address for customer ID 123 to [email protected]."

Tips & gotchas

• Requires access credentials (username and password) to connect to the MySQL database. Ensure these are provided securely.