Prisma Cursor Plugin

February 4, 2026 · View on GitHub

A comprehensive Cursor plugin for Prisma development, providing MCP server integration, AI rules, specialized skills, custom agents, and automation hooks.

Features

🔌 MCP Server Integration

Direct integration with Prisma MCP server
Database introspection and querying
Schema management through AI

📋 Rules

Schema Conventions: Enforces Prisma naming conventions and best practices
Migration Best Practices: Guidelines for safe database migrations

🎯 Skills

Schema Designer: Design and modify Prisma schemas following best practices
Migration Manager: Safely create, deploy, and manage database migrations

🤖 Custom Agents

Prisma Expert: Comprehensive Prisma development expertise
Schema Reviewer: Specialized schema review and optimization

⚡ Automation Hooks

Pre-commit: Validates Prisma schema before commits
Post-save: Auto-formats Prisma schema files on save
On-schema-change: Regenerates TypeScript types after schema changes

Installation

From Cursor Marketplace

# Install via Cursor CLI
cursor plugin install prisma-cursor-plugin

Manual Installation

Clone this repository
Copy to your Cursor plugins directory
Run setup script:

npm run setup

Configuration

Database Connection

Create a .env file in your project root:

DATABASE_URL="postgresql://user:password@localhost:5432/mydb"

MCP Server

The Prisma MCP server is automatically configured. Ensure your DATABASE_URL environment variable is set.

Usage

Using Rules

Rules are automatically applied to your Prisma schema files:

Schema conventions enforce naming standards
Migration best practices guide safe database changes

Using Skills

Invoke skills via Cursor AI:

/schema-designer - Design new schemas or modify existing ones
/migration-manager - Create and manage migrations

Using Agents

Switch to custom agents in Cursor:

Prisma Expert: For general Prisma development tasks
Schema Reviewer: For schema reviews and optimization

Automation Hooks

Hooks run automatically on configured events:

Schema validation before commits
Auto-formatting on save
Type generation after schema changes

Project Structure

prisma-cursor-plugin/
├── .cursor/
│   └── plugin.json           # Plugin manifest
├── rules/
│   ├── schema-conventions.mdc
│   └── migration-best-practices.mdc
├── skills/
│   ├── schema-designer/
│   │   └── SKILL.md
│   └── migration-manager/
│       └── SKILL.md
├── agents/
│   ├── prisma-expert.md
│   └── schema-reviewer.md
├── scripts/
│   ├── setup.sh
│   ├── pre-commit.sh
│   ├── format-schema.js
│   └── generate-types.ts
├── hooks.json                # Hook definitions
├── mcp.json                  # MCP server configuration
├── package.json
└── README.md

Development

Scripts

# Setup the plugin
npm run setup

# Build MCP server (when implemented)
npm run build

# Development mode (when implemented)
npm run dev

# Run code generation scripts
npm run generate

Requirements

Node.js >= 18
Prisma CLI (installed automatically by setup)
Database connection (PostgreSQL, MySQL, SQLite, etc.)

Examples

Creating a Schema

model User {
  id        Int      @id @default(autoincrement())
  email     String   @unique
  name      String?
  posts     Post[]
  createdAt DateTime @default(now())
  updatedAt DateTime @updatedAt

  @@index([email])
}

model Post {
  id          Int      @id @default(autoincrement())
  title       String
  content     String?
  published   Boolean  @default(false)
  authorId    Int
  author      User     @relation(fields: [authorId], references: [id])
  createdAt   DateTime @default(now())
  updatedAt   DateTime @updatedAt

  @@index([authorId])
  @@index([published])
}

Creating a Migration

# Create and apply migration
npx prisma migrate dev --name add_user_posts

# Deploy to production
npx prisma migrate deploy