Prisma MCP

Name: Prisma MCP
Author: Prisma

by Prisma

Manage Prisma Postgres databases — schema, migrations, and queries via natural language

database Node.js Intermediate Self-hostable Verified

⭐ 300 stars 📅 Updated: 1mo ago

View on GitHub View package

Description

Official Prisma MCP server that gives LLMs the ability to manage Prisma Postgres databases through natural language. Handle the full database lifecycle — from schema design and migrations to querying and introspection — directly from your AI assistant. Built by the Prisma team, it leverages Prisma's type-safe database access layer and migration engine. Create and modify schemas, run migrations, execute queries, and introspect existing databases without switching tools. Perfect for developers who use Prisma ORM and want AI-assisted database management integrated into their workflow.

✅ Best for

Developers using Prisma ORM who want AI-assisted database management

⏭️ Skip if

You use a different ORM or need support for non-Postgres databases

💡 Use cases

Designing and evolving database schemas through conversational AI
Running Prisma migrations from AI assistants during development
Querying Prisma Postgres databases with natural language
Introspecting existing databases to understand schema and relationships

👍 Pros

✓ Official project maintained by the Prisma team
✓ Full database lifecycle — schema, migrations, queries, and introspection
✓ Type-safe database access leveraging Prisma ORM's proven engine
✓ Simple npx install with familiar Prisma configuration

👎 Cons

✗ Focused on Prisma Postgres — not a generic multi-database connector
✗ Migration operations can be destructive — requires careful review
✗ Schema changes through AI require understanding of Prisma schema language

🔧 Exposed tools (4 tools)

Tool	Category	Description
introspect_database	discovery	Introspect an existing database to generate Prisma schema
manage_schema	management	Create or modify the Prisma schema definition
run_migration	management	Run a Prisma migration to apply schema changes
execute_query	query	Execute a database query through Prisma

⚡ Installation

Prerequisites:

• Node.js v18+
• Prisma account credentials or database connection string
• API key required

Check Claude Code documentation to configure this MCP server.

💡 Tips & tricks

Configure your database connection string via the DATABASE_URL environment variable as you would in a standard Prisma project. Use introspect_database first on existing projects to give the LLM context about your schema before making changes. Always review generated migrations before applying to production.

🔄 Alternatives

drizzle-mcp

Similar functionality

Supabase MCP

AI-powered Supabase project management with database, functions, and storage