Prisma Expert

What it does

The Prisma Expert skill enables AI agents to interact with databases using Prisma, an ORM for Node.js. It allows users to perform database operations like querying, mutating data, and defining models based on the Prisma schema.

When to use it

• When you need to query or mutate a PostgreSQL, MySQL, or SQLite database using Prisma.
• To generate Prisma client code from a schema definition for easier database interaction.
• For setting up and managing database relationships in a Node.js application.
• When automating repetitive database tasks such as seeding data or running migrations.

Key capabilities

• Execute CRUD operations via Prisma ORM.
• Generate Prisma clients based on a schema file.
• Support for multiple databases including PostgreSQL, MySQL, and SQLite.
• Ability to define and manage database models through Prisma schema definitions.

Example prompts

• "Generate a Prisma client for my PostgreSQL database using the schema in prisma/schema.prisma."
• "Query all users from the 'users' table where age is greater than 25."
• "Create a new user with name 'John Doe' and email '[email protected]' in the database."

Tips & gotchas

• Ensure your Prisma schema file is correctly configured before using this skill.
• This skill assumes familiarity with Prisma CLI and basic Node.js setup.