Prisma MCP Server
Two official Prisma MCP servers: a local one for migrations and Prisma Studio, and a remote one for managing Prisma Postgres databases
Install
{
"mcpServers": {
"Prisma-Local": {
"command": "npx",
"args": ["-y", "prisma", "mcp"]
}
}
}Local server for migrations and Prisma Studio.
This is third-party code. Review the repository files before installing.
What it does
The local server runs from the Prisma CLI and gives the agent developer commands: check migration status, create and apply a migration, reset the database, open Prisma Studio, log in to Prisma Console and create a Prisma Postgres database. The remote server targets platforms that manage databases for their users. Through it the agent lists databases, creates and deletes connection strings, makes and restores backups, runs SQL and introspects the schema.
Who it is for. For Prisma ORM developers and Prisma Postgres users.
Good fit when
- You want the agent to create and apply Prisma migrations as the schema evolves
- You need a quick Prisma Postgres database for a prototype
- You want to back up and query a Prisma Postgres database from chat
Not a fit when
- The project does not use Prisma
- The database is production and the agent must not reset or delete it
Example request
Add a Product model to the schema, create a migration and check migration statusLimitations
The remote server works only with Prisma Postgres and requires a Prisma Console login. The local migrate-reset tool resets the database with --force and the remote server can delete databases, so enable confirmations in your client. The server code lives in the Prisma CLI; this repository holds documentation and configs. Access to Prisma Console from Russia without a VPN is unverified.
How to disable. Remove the Prisma-Local and Prisma-Remote blocks from your editor's MCP configuration.
MCP
- Transport
- stdio, http
- Authentication
- OAuth
Security check
- Resets databases, applies migrations and runs SQL
- The remote server can delete databases and connection strings
README in short
The README explains the local versus remote server and lists each one's tools. It gives start commands, sample prompts and JSON configs for VS Code, Cursor, Windsurf, Claude Code and other clients, including one-click install. Cloudflare's AI Playground is suggested for trying the remote server.
FAQ
Which server should I pick?
Use the local one for your own development. The remote one is for platforms that let their users manage databases.
Do I need a Prisma account?
Not for migrations with the local server. Creating Prisma Postgres databases and using the remote server require a Prisma Console login.
Related
The official FastAPI skill, bundled with the package, teaching agents to write code for the installed version
Official skills and agents from the .NET team: performance, MSBuild, NuGet, upgrades, testing, ASP.NET Core, Blazor and MAUI
Firebase MCP Server
Firebase CLI and MCP Server
Official Firebase MCP server from the Firebase CLI: projects, Firestore, Auth, Crashlytics, Remote Config and function logs
Laravel's official MCP server, guidelines and skills: the agent sees the DB schema, logs and package versions and searches ecosystem docs