prisma-expert

The prisma-expert skill provides specialized guidance and solutions for developers using the Prisma ORM, addressing challenges in schema design, database migrations, query optimization, and relational modeling across PostgreSQL, MySQL, and SQLite. It helps users identify and resolve common issues in Prisma projects, such as relation errors, missing indexes, enum mismatches, and migration conflicts. By focusing on Prisma-specific problems, this skill streamlines database operations and ensures that the schema and queries align correctly with best practices, reducing runtime errors and improving application performance.

The skill's main capabilities include detecting the development environment and Prisma version, diagnosing schema and migration problems, and recommending progressive fixes ranging from minimal corrections to complete overhauls. It provides structured playbooks for schema design and migrations, highlighting common issues, diagnostic commands, prioritized fixes, and best practices. The skill also integrates environment checks, such as verifying Prisma Client generation and existing migrations, and guides users through safe migration workflows for both development and production environments. Additionally, it offers resources and references for further learning directly from Prisma's official documentation.

Prisma-expert is designed for backend developers, database engineers, and full-stack developers who work with Prisma ORM and relational databases. It is particularly useful in team environments where schema consistency, migration management, and query optimization are critical. Use cases include resolving schema validation errors, optimizing queries for performance, managing migrations safely across development and production, and implementing robust relational models. By providing step-by-step guidance, the skill helps users improve database reliability, reduce deployment risks, and maintain efficient Prisma-based applications.