Prisma with AI coding tools
Prisma ORM and Prisma Postgres work with AI coding agents through installable skills, an MCP server, and editor integrations. This page collects the setup guides, prompts, and tutorials for using them together.
Run the following command to bootstrap your database with a prompt:
bunx --bun prisma@prev init --prompt "Create a habit tracker application"pnpm dlx prisma@prev init --prompt "Create a habit tracker application"yarn dlx prisma@prev init --prompt "Create a habit tracker application"npx prisma@prev init --prompt "Create a habit tracker application"Each guide covers setup and prompts for using Prisma in a specific AI editor or agent.
- Cursor - Define project-specific rules and use your schema as context to generate accurate queries and code.
- Codex - Install the Prisma Codex plugin with Prisma ORM skills and the remote Prisma MCP server.
- Windsurf - Automate your database workflows by generating schemas, queries, and seed data in this AI-powered editor.
- Github Copilot - Get Prisma-aware code suggestions, run CLI commands from chat, and query the Prisma docs.
- ChatGPT - Learn how to connect the Prisma MCP server to ChatGPT to manage your databases with natural language.
AI agents often generate outdated Prisma v6 code. Install Prisma Skills to give your agent accurate, up-to-date v7 knowledge: CLI commands, Client API, upgrade guides, database setup, and Prisma Postgres workflows.
bunx skills add prisma/skillspnpm dlx skills add prisma/skillsyarn dlx skills add prisma/skillsnpx skills add prisma/skills- Available skills and setup - See all available skills and learn how to install them.
- Available skills and setup - See all available skills and learn how to install them.
With Prisma's MCP server, your AI tool can create Prisma Postgres databases, run SQL queries, restore automated backups, and manage Object Storage. It can also manage Prisma Compute deployments, read app logs, set environment variables, and inspect how your Composer services connect.
{
"mcpServers": {
"Prisma": {
"url": "https://mcp.prisma.io/mcp"
}
}
}- Available tools - The full list of tools the Prisma MCP server exposes.
- Integrating in AI tools - Configuration for Cursor, Claude, Warp, and other AI tools.
- How we built it - How the MCP protocol works and how the Prisma MCP server was built.
Tutorials that build a full application from scratch with an AI coding assistant.
- Build a Linktree Clone SaaS - Build a Linktree clone SaaS with Next.js, Prisma Postgres, and Clerk auth using AI assistance.
- Vibe Coding with Limits - How to Build Apps in the Age of AI
- Vibe Coding an E-commerce App - with Prisma MCP and Next.js
- Integrating the Vercel AI SDK - in a Next.js application
- Automate with Pipedream - Connect Prisma Postgres to 2,800+ apps in automated workflows
- Firebase Studio - Prompt your application with Firebase Studio & Prisma Postgres