Prisma Development

What it does

This skill enables AI agents to interact with databases using Prisma, a modern database toolkit. It allows agents to define schemas, execute queries, and manage data migrations directly within the codebase.

When to use it

• You need an AI agent to automatically generate database schema files from natural language descriptions.
• Your workflow requires automated execution of database migrations during deployment pipelines.
• You want an agent to perform read/write operations on a PostgreSQL, MySQL, or SQLite database without manual SQL scripting.
• You are building a full-stack application where the agent must understand and manipulate your ORM layer.

Key capabilities

• Define and update Prisma schema models for various relational databases.
• Generate type-safe queries based on the defined data model.
• Execute and manage database migrations to evolve the schema over time.
• Integrate seamlessly with existing Node.js or TypeScript projects using the Prisma Client.

Example prompts

• "Create a Prisma schema for an e-commerce store with Users, Products, and Orders tables."
• "Write a migration script to add an 'email' field to the User model and update all existing records."
• "Query the database to find all products where the price is greater than $50 and sort them by name."

Tips & gotchas

Ensure your project has Prisma installed and configured with a valid connection string before asking the agent to run migrations. Always review generated migration files before applying them to production databases to prevent data loss.