Prisma Expert

What it does

This skill provides expert assistance with Prisma, a Node.js ORM (Object-Relational Mapper). It can generate Prisma schema definitions, write database migrations based on schema changes, and help debug complex queries. The agent is proficient in understanding Prisma's type-safe API and best practices for interacting with databases.

When to use it

• Schema Generation: You need to quickly define a new database model but don’t want to manually create the Prisma schema file.
• Migration Creation: Your database schema has changed, and you require a migration script to update your database safely.
• Query Optimization: Existing Prisma queries are slow or inefficient, and you need help identifying bottlenecks and improving performance.
• Debugging: You're encountering errors with your Prisma setup or queries and need assistance in diagnosing the root cause.

Key capabilities

• Prisma schema generation
• Database migration creation
• Query debugging and optimization
• Understanding of Prisma’s type-safe API

Example prompts

• "Generate a Prisma schema for a 'Product' model with fields: id, name, description, price."
• "Create a database migration to add an index on the 'email' column in the 'User' table."
• "My Prisma query is very slow. Can you help me optimize it?"

Tips & gotchas

• The agent performs best when provided with clear and concise instructions regarding the desired schema or query modifications.
• Ensure your environment has a working Node.js installation, as Prisma relies on this runtime.