Sqlmodel

What it does

The sqlmodel skill allows AI agents to interact with a task management API using SQLModel, an ORM (Object Relational Mapper) for SQLAlchemy. It enables querying and manipulating data within the database, such as creating new tasks, updating existing ones, or retrieving lists of tasks based on specific criteria. This skill facilitates more complex interactions than simple text-based commands.

When to use it

• Task Creation: An agent needs to create a new task in the system with specific details (e.g., title, description, due date).
• Status Updates: The agent should update the status of an existing task based on progress or completion.
• Reporting: Generate reports summarizing tasks by priority, assignee, or other relevant fields.
• Filtering Tasks: Retrieve a list of tasks that match certain criteria (e.g., overdue tasks, tasks assigned to a specific user).

Key capabilities

• SQLModel ORM integration
• Database query execution
• Task data manipulation (create, read, update)
• Data filtering and reporting

Example prompts

• "Create a new task titled 'Write Report' with description 'Draft the quarterly sales report' due on 2024-12-31."
• "Update the status of task ID 123 to 'Completed'."
• "List all overdue tasks assigned to John Doe."

Tips & gotchas

The agent requires access credentials (username and password) for the database. Ensure that the database schema matches the expected structure defined by the API.