Sql Guide

What it does

This skill allows AI agents to understand and execute SQL queries against relational databases. It can retrieve, insert, update, and delete data based on provided instructions. The agent can also generate SQL statements from natural language descriptions of desired database operations.

When to use it

• Data Extraction: Retrieve specific information from a database, such as customer order history or product inventory levels.
• Report Generation: Create reports by querying and aggregating data from multiple tables in a database.
• Database Updates: Modify existing records within a database, like updating a customer's address or adding a new product.
• Data Analysis: Perform basic analysis on data stored in databases, such as calculating averages or identifying trends.

Key capabilities

• SQL query execution
• Natural language to SQL translation
• Data retrieval (SELECT)
• Data modification (INSERT, UPDATE, DELETE)

Example prompts

• "Get me a list of all customers who live in California."
• "Create a new user with the username 'newuser' and password 'password'."
• "Update the price of product ID 123 to $19.99."

Tips & gotchas

The agent requires access to a database connection string (host, port, username, password) to function correctly. Be mindful of security implications when providing this information and avoid hardcoding sensitive credentials directly into prompts.