Mysql Skill

What it does

This skill allows AI agents to interact with and manipulate MySQL databases. It can execute SQL queries, retrieve data, and perform basic database operations. The agent can be used to query information from a database or update existing records based on provided instructions.

When to use it

• Data Retrieval: Extract specific information from a database for reporting or analysis (e.g., "Get me the names of all customers who placed an order in the last month.").
• Database Updates: Modify data within a MySQL database, such as updating customer addresses or product prices (e.g., "Change the price of item ID 123 to $19.99").
• Data Validation: Check for inconsistencies or errors in a database by running queries and analyzing results (e.g., “Find all orders with a shipping date after the order date.").
• Database Schema Inspection: Retrieve information about tables, columns, and data types within a MySQL database.

Key capabilities

• Execute SQL Queries
• Retrieve Data from Tables
• Update Database Records
• Interact with MySQL Databases

Example prompts

• "Run the query 'SELECT * FROM customers WHERE city = 'New York''."
• "Update the product price for item ID 5 to $25.00 using SQL."
• “What are the names of all tables in the database?”

Tips & gotchas

The agent requires access credentials (hostname, username, password) to connect to the MySQL database. Ensure these credentials are provided securely and that the user has appropriate permissions within the database.