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

MCP serverHigh risk

prisma/mcp

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 status

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.

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.

Editors’ pick

The official FastAPI skill, bundled with the package, teaching agents to write code for the installed version

SkillLow risk102.3K
Editors’ pick

Official skills and agents from the .NET team: performance, MSBuild, NuGet, upgrades, testing, ASP.NET Core, Blazor and MAUI

PluginMedium risk5.4K

Firebase MCP Server

Firebase CLI and MCP Server

Editors’ pick

Official Firebase MCP server from the Firebase CLI: projects, Firestore, Auth, Crashlytics, Remote Config and function logs

MCP serverHigh risk4.5K
Editors’ pick

Laravel's official MCP server, guidelines and skills: the agent sees the DB schema, logs and package versions and searches ecosystem docs

MCP serverMedium risk3.6K