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
- 49 ★ on the repository
- Last commit
Broad access
Why this level
- Resets databases, applies migrations and runs SQL
- The remote server can delete databases and connection strings
Install
- Works in
Manual install
{
"mcpServers": {
"Prisma-Local": {
"command": "npx",
"args": ["-y", "prisma", "mcp"]
}
}
}Local server for migrations and Prisma Studio.
Access and checks
How we reviewBroad accessThe tool can change data, run commands or handle secrets.
- Resets databases, applies migrations and runs SQL
- The remote server can delete databases and connection strings
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 statusMCP
- Transport
- stdio, http
- Authentication
- OAuth
Limitations
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.
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.
Discussion
No questions or reviews yet.
Related
MCP serversA PostgreSQL MCP server with index tuning, EXPLAIN plans, database health checks and a read-only mode
Instant REST and MCP over PostgreSQL: the agent reads an existing database through an MCP endpoint with no backend to write
Supabase's official MCP server: the agent manages tables, reads project config and queries data after an OAuth login
Apollo's MCP server: turns chosen GraphQL operations into tools the agent uses to work with your API
Prisma 8 skill
prisma-8
The official Prisma 8 skill installed from your project's packages: data contract, migrations, queries and version upgrades
mcp-graphql: MCP server for GraphQL APIs
mcp-graphql
Two GraphQL tools for MCP clients: the agent fetches your API schema and runs queries against a single endpoint
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.