Sql Pro

What it does

This skill allows AI agents to execute SQL queries against specified databases. It can retrieve, insert, update, and delete data based on user instructions. The agent will connect to the database using provided credentials and return the query results in a structured format.

When to use it

• Data Extraction: Retrieve specific information from a database for reporting or analysis (e.g., "Get me all customers who spent over $100 last month.").
• Database Updates: Modify data within a database based on user requests (e.g., "Update the price of product X to $25.").
• Data Insertion: Add new records into tables in a database (e.g., “Add a new customer with these details…").
• Complex Queries: Execute more complex SQL queries involving joins, aggregations, and subqueries for advanced data manipulation.

Key capabilities

• Database connection via credentials.
• SQL query execution.
• Data retrieval from databases.
• Data modification (insert, update, delete).
• Structured result formatting.

Example prompts

• "Run the following SQL query: SELECT * FROM products WHERE price > 50."
• “Insert a new row into the ‘orders’ table with these values.”
• "Update the 'status' column in the 'tasks' table to 'completed'."

Tips & gotchas

• Ensure you provide valid database connection credentials (host, username, password, database name).
• The agent requires a working SQL database and appropriate permissions.