Prisma Orm

What it does

This skill allows AI agents to interact with and manage data using Prisma ORM. It facilitates database operations like querying, creating, updating, and deleting records through a type-safe and developer-friendly interface. The agent can leverage Prisma's schema definition language for efficient and reliable data management tasks.

When to use it

• Data Extraction: Retrieve specific information from a database based on complex criteria (e.g., "Find all customers who spent over $100 last month").
• Content Creation: Generate new entries in a database, such as creating user accounts or product listings.
• Automated Updates: Modify existing data records according to predefined rules or triggers (e.g., automatically update inventory levels after a sale).
• Data Deletion: Remove obsolete or irrelevant data from the database based on specified conditions.

Key capabilities

• Prisma ORM integration
• Type-safe database interactions
• Schema definition language support
• Querying, creating, updating, and deleting records

Example prompts

• "Retrieve all users with email addresses ending in '@example.com'."
• "Create a new product entry with name 'Widget', price 19.99, and description 'A useful widget'."
• "Update the status of order ID 123 to 'shipped'."

Tips & gotchas

• Requires a Prisma schema file (schema.prisma) to be defined for the database connection.
• Ensure the agent has appropriate database access permissions.