Prisma Expert

What it does

This skill provides expertise in using Prisma, a Node.js ORM (Object-Relational Mapper). It can generate database schemas, write queries for data retrieval and manipulation, and assist with migrations – all within the context of a Node.js application leveraging Prisma. The skill is designed to streamline database interactions and improve developer productivity.

When to use it

• Schema Generation: You need help defining your database schema based on your application's data model.
• Query Assistance: You’re struggling with complex Prisma queries or need assistance optimizing existing ones.
• Migration Management: You require guidance in creating and applying database migrations using Prisma Migrate.
• Troubleshooting: You are encountering errors related to Prisma configuration or usage.

Key capabilities

• Database schema generation
• Prisma query creation and optimization
• Database migration assistance (using Prisma Migrate)
• Node.js ORM expertise

Example prompts

• "Generate a Prisma schema for a 'User' model with fields: id, name, email."
• "Write a Prisma query to find all users whose email contains 'example.com'."
• "How do I create a migration in Prisma to add a new column called 'createdAt' to the 'Post' table?"

Tips & gotchas

• This skill is most effective when used within a Node.js environment utilizing Prisma. Ensure your project is properly set up with Prisma before interacting with the skill.