Prisma Expert

The Prisma Expert skill enables AI agents to generate, modify, and debug Prisma ORM configurations for database interactions. It automates schema creation, migration generation, and query optimization within TypeScript or JavaScript projects using the Prisma library.

When to use it

• You need to set up a new database schema from scratch without writing raw SQL.
• Your team requires automated migrations to keep production and development databases in sync.
• You want an AI agent to refactor existing Prisma models for better performance or clarity.
• Debugging complex relationship errors or type mismatches in your data layer.

Key capabilities

• Generates Prisma schema files (.prisma) based on natural language descriptions of database structures.
• Creates and applies migration scripts automatically when schema changes occur.
• Writes optimized SQL queries using the Prisma query builder syntax.
• Validates TypeScript types against the current database state to prevent runtime errors.

Example prompts

• "Create a Prisma schema for an e-commerce system with Users, Orders, and Products tables."
• "Generate a migration script to add a 'status' field to the User table with a default value of 'pending'."
• "Optimize this slow query that fetches all orders with their associated line items using Prisma."

Tips & gotchas

Ensure your project has the prisma package installed and a valid package.json before requesting schema generation. The skill works best when you provide context about your specific database engine (e.g., PostgreSQL, MySQL) to tailor the schema output correctly.