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 based on database designs, assist in writing Prisma Client queries for data retrieval and manipulation, and help troubleshoot common Prisma issues. The agent leverages its knowledge to optimize database interactions and ensure efficient data management within your application.

When to use it

• Database Schema Design: You need to translate a conceptual database design into a Prisma schema file.
• Complex Queries: You're struggling to write complex queries using the Prisma Client API.
• Troubleshooting Errors: You are encountering errors in your Prisma setup or data access layer and require debugging assistance.
• Code Generation: Automate the creation of boilerplate code for interacting with your database through Prisma.

Key capabilities

• Prisma schema generation
• Prisma Client query writing & optimization
• Error troubleshooting related to Prisma configuration and usage
• Database interaction automation

Example prompts

• "Generate a Prisma schema for a database with tables 'users', 'posts', and 'comments'."
• "Write a Prisma Client query to retrieve all users who have posted more than 5 comments."
• "I'm getting an error: 'PrismaClientError: Relation not found'. What could be the problem?"

Tips & gotchas

This skill assumes you already have a basic understanding of Prisma and Node.js. Providing clear and specific details about your database structure or query requirements will yield more accurate and helpful results.