Database

What it does

This skill provides access to and manipulation of data stored within a database. It allows agents to query, insert, update, and delete records based on provided instructions. The agent can retrieve specific information or perform complex operations on the data contained within the connected database.

When to use it

• Data Retrieval: When you need an AI agent to extract specific pieces of information from a structured dataset (e.g., customer details, product inventory).
• Record Updates: To automate tasks like updating order statuses or modifying user profiles in a database.
• Report Generation: When the agent needs to compile data and generate summaries or reports based on database contents.
• Data Analysis: To perform basic analysis of data stored within a database, such as finding averages or identifying trends.

Key capabilities

• Querying databases using SQL-like commands
• Inserting new records into tables
• Updating existing record values
• Deleting records from the database

Example prompts

• "Retrieve all customer names and email addresses from the 'customers' table."
• "Update the quantity of product ID 123 in the 'inventory' table to 50."
• "Delete the order with order ID 456 from the 'orders' table."

Tips & gotchas

The skill requires a connection to a database, and you will need to provide the necessary credentials for access. Be mindful of data security when constructing prompts – avoid including sensitive information directly in the prompt itself.