About
Overview
The Prisma MCP Server enables AI agents to interact with databases through Prisma's ORM layer. It reads your Prisma schema to understand models and relations, generates and executes Prisma Client queries, and supports migration management. Works with PostgreSQL, MySQL, SQLite, MongoDB, and other Prisma-supported databases.
Capabilities
Tools & Capabilities
⚡query
Execute a Prisma Client query
⚡get_schema
Get the Prisma schema definition
⚡list_models
List all models defined in the schema
⚡create_migration
Create a new migration
⚡raw_query
Execute a raw SQL query through Prisma
Setup
Installation
bash
Install
npx -y prisma-mcp-serverExamples
Example Usage
javascript
Usage
{
"mcpServers": {
"prisma": {
"command": "npx",
"args": ["-y", "prisma-mcp-server"],
"env": {
"DATABASE_URL": "postgresql://localhost/mydb"
}
}
}
}Quick Info
Authorprisma
LanguageTypeScript
StatusBeta
Stars★ 310
Last UpdatedFeb 12, 2026