mysql

What it does

This skill allows AI agents to execute read-only SQL queries against multiple MySQL databases. It's designed for retrieving data and exploring schema information without modifying the underlying database. The agent can run SELECT statements to extract specific data points or entire tables for analysis.

When to use it

• Data Exploration: Quickly examine the structure of a MySQL database, including table names and column definitions.
• Reporting & Analytics: Retrieve specific data sets from MySQL databases to generate reports or perform analytical tasks.
• Schema Validation: Verify the existence of tables and columns before integrating with other systems.
• Data Checks: Run SELECT queries to confirm data integrity and identify potential issues within a database.

Key capabilities

• Execute read-only SQL queries.
• Supports multiple MySQL databases.
• Primarily designed for SELECT statements.
• Allows exploration of database schemas and tables.

Example prompts

• "Show me the names of all tables in the 'customers' database."
• "Run a SELECT query to retrieve the first 10 rows from the 'orders' table in the 'sales' database."
• "What are the column names for the 'products' table in the 'inventory' database?"

Tips & gotchas

• The skill is limited to read-only operations; any attempt to modify data will fail.
• Ensure the AI agent has appropriate credentials and access permissions to the target MySQL databases.