Prisma MCP
Prisma's remote MCP server for Postgres databases, Compute apps and object storage
BestMCPTools
Prisma MCP
bestmcptools.org
Last verified: November 17, 2026
How to Install Prisma MCP
$claude mcp add --transport http prisma https://mcp.prisma.io/mcpCompatible with: Claude Code, Claude Desktop, Cursor, VS Code, Windsurf, Gemini CLI.
Setup by client
This is a remote server. If it requires sign-in, your client opens a browser sign-in window (OAuth) the first time it connects. Clients without OAuth support cannot use servers that require it.
Cursor (~/.cursor/mcp.json)
{
"mcpServers": {
"prisma-mcp": {
"url": "https://mcp.prisma.io/mcp"
}
}
}VS Code (.vscode/mcp.json)
{
"servers": {
"prisma-mcp": {
"type": "http",
"url": "https://mcp.prisma.io/mcp"
}
}
}Claude Code (terminal)
claude mcp add --transport http prisma-mcp https://mcp.prisma.io/mcpAdd any API keys or environment variables the server's README lists.
About Prisma MCP
Prisma MCP is the Model Context Protocol server from Prisma, the company behind the Prisma ORM and the Prisma Postgres database. It is a remote server at https://mcp.prisma.io/mcp that lets an AI client manage Prisma Postgres databases, apps deployed on Prisma Compute, and Object Storage buckets and access keys. You sign in with your Prisma account, pick a workspace and approve access. The docs describe only the remote option and do not describe a local one.
Quick facts (as of November 17, 2026)
| Prisma MCP | |
|---|---|
| Maker | Prisma |
| Type | Remote server using Streamable HTTP; the docs describe no local option |
| Server URL | https://mcp.prisma.io/mcp |
| Auth | Prisma account sign-in, workspace selection and approval in the browser |
| Documented clients | Claude Code, Claude Desktop, Cursor, VS Code, Windsurf, Warp, Gemini CLI, fx, and Codex (installed through a Prisma plugin) |
| Tools | 31 listed on the MCP tools reference page |
| Price | The MCP docs state no price; Prisma Postgres plans have their own prices (see Pricing) |
| Source | Documentation only; the docs we read do not link a dedicated repository for the server |
What it is
Prisma MCP gives an assistant hands on the managed side of the Prisma platform. The docs group the capabilities into databases (create, list, run SQL, restore automated backups), Object Storage (manage buckets and access keys), Compute (manage existing deployments, read logs, set environment variables), Composer (show how project resources connect) and a documentation search. It works at the workspace level: tools operate within the workspace you selected when you authorized the connection.
Prisma's changelog has an entry dated October 2, 2026 titled "Let your coding agent set up Prisma, and decide what needs your approval", which says the Prisma MCP server works with Prisma Compute. That is the most recent dated signal we found for the server.
Tools and capabilities
The tools reference lists the tools by area. Exact names from that page:
- Workspace and databases:
fetch_workspace_details,list_prisma_postgres_databases,create_prisma_postgres_database,delete_prisma_postgres_database - Connection strings:
list_prisma_postgres_connection_strings,create_prisma_postgres_connection_string,delete_prisma_postgres_connection_string - Backups and recovery:
list_prisma_postgres_backups,create_prisma_postgres_recovery(restores a backup to a new database) - Schema and queries:
introspect_database_schema,execute_sql_query,execute_prisma_postgres_schema_update - Object Storage:
list_object_store_buckets,create_object_store_bucket,delete_object_store_bucket,create_object_store_bucket_key,delete_object_store_bucket_key - Documentation:
search_prisma_documentation, which answers a question with a cited answer from the Prisma docs - Compute apps and builds:
list_prisma_compute_apps,list_prisma_compute_builds,list_prisma_compute_deployments,get_prisma_compute_deployment_logs - Compute deployment management:
promote_prisma_compute_deployment,rollback_prisma_compute_app,start_prisma_compute_deployment,stop_prisma_compute_deployment,delete_prisma_compute_deployment,delete_prisma_compute_app - Compute environment variables:
set_prisma_compute_env_var,delete_prisma_compute_env_var - Composer projects:
get_prisma_composer_topology
Several of these write or delete: database deletion, bucket deletion, deployment deletion and environment variable changes are all in the list. The reference states that execute_sql_query runs SQL to read, change or delete data without changing the schema, and that schema changes go through a separate tool, execute_prisma_postgres_schema_update.
Setup for Claude, Cursor and other clients
Every configuration on the docs page points at the same URL. These are the commands and files the docs give.
Claude Code
claude mcp add --transport http prisma https://mcp.prisma.io/mcp
Claude Desktop (config file at ~/Library/Application Support/Claude/claude_desktop_config.json on macOS, %APPDATA%\Claude\claude_desktop_config.json on Windows):
{
"mcpServers": {
"Prisma": {
"url": "https://mcp.prisma.io/mcp"
}
}
}
The docs add that Claude Desktop and Claude on the web can also add the server as an integration named Prisma with the same URL.
Cursor (~/.cursor/mcp.json for all projects, or .cursor/mcp.json inside one project):
{
"mcpServers": {
"Prisma": {
"url": "https://mcp.prisma.io/mcp"
}
}
}
VS Code (.vscode/mcp.json in your workspace; this file uses servers, not mcpServers):
{
"servers": {
"Prisma": {
"url": "https://mcp.prisma.io/mcp"
}
}
}
The page also covers Windsurf (~/.codeium/windsurf/mcp_config.json), Warp, Gemini CLI (gemini mcp add --transport http Prisma https://mcp.prisma.io/mcp --scope user) and fx. We did not copy those configs in full; check the docs page for them.
Authentication
You need a Prisma account and access to a workspace, which groups your projects. When a client first connects you sign in, select a workspace and approve access. The docs say Codex and fx also authenticate through Prisma Console, and that Codex is set up through the prisma/codex-plugin plugin. They do not describe an API key option for the MCP server on the page we read, and they do not say what scopes the approval grants beyond the selected workspace.
Limits and things to watch
- Destructive tools exist. The docs warn that tools that change or delete resources can cause data loss or interrupt live traffic, and tell you to check the target workspace and resources before approving.
- Default database protected.
delete_prisma_postgres_databasecannot delete a project's default database. - Apps with live deployments.
delete_prisma_compute_appfails if active deployments exist, unlessdeleteDeploymentsis set to true. - No builds from the assistant. Compute tools manage existing apps and deployments only. They do not build or upload source code, and
start_prisma_compute_deploymentalso does not build or upload. - Secrets stay hidden. Environment variable values are encrypted and never returned.
- Topology can be stale.
get_prisma_composer_topologymay be outdated and does not check whether apps are running. - Guardrails scope. The docs state that the destructive-command guardrails apply only to Prisma CLI commands, not to MCP tool calls. Treat approval prompts in your client as your main control.
- No numeric limits. The docs page gives no rate or size limits; per-tool limits are on the tools reference.
Pricing
The MCP documentation does not state a price for the server. The usage it triggers falls under your Prisma plan. As of November 2026, Prisma's pricing page lists Prisma Postgres plans at Free ($0, 200k operations, 2 GB storage), Starter ($10 per month, 1M operations), Pro ($49 per month, 10M operations) and Business ($129 per month, 50M operations). Free has a fixed $0 spend limit, while Starter, Pro and Business can set one. The same page lists separate Compute usage rates (for example $1 per million requests beyond the included amount on paid plans) and no Object Storage pricing, and the MCP docs do not say how MCP actions are billed, so check Prisma's pricing before relying on it.
Pros and cons
Pros
- Official remote server from the vendor, with one URL for every client.
- Covers databases, backups, SQL, object storage and Compute logs and deployments in one connection.
- A documentation search tool that answers from Prisma's own docs.
- No local install or credentials file to manage; sign-in happens in the browser.
Cons
- Useful mainly if you already host on Prisma Postgres or Prisma Compute.
- Remote only per the docs.
- Includes tools that delete databases, buckets and deployments, so approvals matter.
- The docs give no rate limits and no read-only switch that we could find.
Who it is for
A good fit if:
- You run Prisma Postgres, Compute or Object Storage and want an assistant to inspect schemas, read logs or manage environment variables.
- You want your coding agent to create a database and get a connection string without leaving the editor.
Not the right tool if:
- You use another database host. See Neon MCP, Supabase MCP or MongoDB MCP.
- You need a server that runs entirely on your own machine. The docs describe only the remote server.
Alternatives
Neon MCP manages serverless Postgres from an assistant, Supabase MCP covers a Postgres-based backend platform, and MongoDB MCP is the choice for document databases.
What we don't know
- Repository. The Prisma ORM repository page we opened shows no archive notice but does not mention MCP, so we do not link it as the server's source. We could not find a dedicated repository for the MCP server in the docs we read.
- Release cadence. Beyond the October 2, 2026 changelog entry, we saw no version numbers or release dates for the server.
- Scopes and permissions. The docs do not say what the approval grants beyond the selected workspace, or whether read-only access is possible.
- Billing of MCP actions. The MCP docs do not say whether any tool call has its own charge.
- Behavior in practice. This page is based on documentation only.
How this page was put together
We read Prisma's MCP server documentation, the MCP tools reference, the changelog and the pricing page on November 17, 2026, and compared the documented tools, setup steps and warnings.
Sources
Pricing
Freemium: from No MCP server charge stated in Prisma docs (as of November 2026); Prisma Postgres Free plan $0, Starter from $10/month
Our Take on Prisma MCP
An official remote server for teams on Prisma Postgres or Compute. It covers databases, SQL, backups, storage and deployments, but it includes delete tools and the docs give no rate limits or read-only switch.
Alternatives to Prisma MCP
Neon's hosted MCP server for Postgres projects, branches, SQL and migrations
View Neon MCP →MongoDB's official MCP server for queries, aggregations and Atlas admin
View MongoDB MCP →