Prisma Postgres Official Remote MCP Server

๐Ÿ›ก๏ธ Officialโœ“ VerifiedStreamable HTTPOAuth 2.1๐Ÿ›ก๏ธ A+~301 tok5 toolsยทOnline505msยท30d uptime: 100%ยทLast checked 2m ago

Prisma's hosted MCP (mcp.prisma.io/mcp) exposes Prisma Postgres provisioning โ€” create databases, run SQL, inspect schemas and manage connection strings โ€” over OAuth 2.1.

https://mcp.prisma.io/mcp
Provider
Prisma โ†—
Source
https://github.com/prisma/prisma โ†—
Categories
๐Ÿ—„๏ธ Databases & Backend-as-a-Service๐Ÿ› ๏ธ Developer Tools & Git
ไธญๆ–‡็ฎ€ไป‹

Prisma ๅฎ˜ๆ–น่ฟœ็จ‹ MCP ๆœๅŠกๅ™จใ€‚AI ไปฃ็†ๅฏ้€š่ฟ‡ OAuth ๅˆ›ๅปบๅ’Œ็ฎก็† Prisma Postgres ๆ•ฐๆฎๅบ“ใ€ๆ‰ง่กŒ SQL ๅนถๆฃ€ๆŸฅๆจกๅผใ€‚

Maintainer of Prisma Postgres? Claim or update this listing โ†’

Streamable HTTPhttps://mcp.prisma.io/mcp
Install in Cursor โ†’

Or add to ~/.cursor/mcp.json:

{
  "mcpServers": {
    "prisma": {
      "url": "https://mcp.prisma.io/mcp"
    }
  }
}

๐Ÿงฐ Prisma Postgres MCP Tools & Schema (5)

ToolSafetyDescriptionParameters
list_databases
~39 tok
๐ŸŸข ReadList Prisma Postgres databases in your workspace.โ€”
create_database
~64 tok
๐ŸŸ  WriteProvision a new Prisma Postgres database.name*: stringregion: string
execute_sql
~68 tok
๐ŸŸ  WriteRun a SQL statement against a database.databaseId*: stringsql*: string
get_database_schema
~55 tok
๐ŸŸข ReadInspect tables and columns of a database.databaseId*: string
get_connection_string
~55 tok
๐ŸŸข ReadGet a connection string for a database.databaseId*: string

๐Ÿ›ก๏ธ Security, Quality & Context Token Audit

๐Ÿ›ก๏ธ Grade A+Context tax: ~301 tokens injected into every system prompt by this serverโ€™s 5 tools

Every tool definition (name + description + input schema) is injected into your LLMโ€™s context on every request โ€” Estimate per-call LLM token cost โ†’

  • No prompt-injection or hidden-character anomalies detected in tool descriptions
  • Streamable HTTP primary endpoint (current 2025-03-26 transport)
  • OAuth 2.1 with PKCE S256 enforced
  • Official first-party endpoint operated by the vendor
  • Manually verified by RemoteMCP.net

๐Ÿ” OAuth 2.1 & Security

Auth type
OAuth 2.1
Dynamic Client Registration
โœ… Supported
PKCE S256
โœ… Supported
Protected resource metadata
https://mcp.prisma.io/.well-known/oauth-protected-resource (expected location)
๐Ÿ” Audit OAuth 2.1 Config โ†’

๐Ÿงฉ Recommended Agent Skills

๐Ÿ“– Prisma Postgres MCP Endpoint Overview & Security Guide

Prisma Postgres MCP โ€” Remote MCP Server

Prisma's remote MCP gives agents a managed Postgres sandbox workflow โ€” spin up a Prisma Postgres database, apply schema migrations, run SQL and fetch connection strings โ€” ideal for prototyping data models without local setup.

Official Prisma Postgres MCP Endpoint & Transport Architecture

  • Endpoint URL: https://mcp.prisma.io/mcp
  • Transport: Streamable HTTP

Streamable HTTP is the current MCP transport (2025-03-26 spec): a single URL accepts JSON-RPC POSTs and may stream responses over SSE, so one endpoint serves both simple and streaming workloads. Prisma Postgres MCP does not publish a separate legacy SSE endpoint, so your client must speak Streamable HTTP.

Authentication, Scopes & Permission Boundaries

Prisma Postgres MCP uses OAuth 2.1 โ€” the first request returns a 401 Unauthorized challenge with a WWW-Authenticate header pointing at the authorization metadata. Compliant clients (Cursor, Claude, VS Code, ChatGPT) handle the whole flow โ€” PKCE and Dynamic Client Registration, so no manual client setup is needed โ€” and simply open a browser consent screen.

Of the 5 cataloged tools, 3 are read-only and 2 can write or mutate state (create resources, run SQL, post messages). Grant access only to the accounts and projects you intend agents to act on, and prefer scoped credentials or a dedicated workspace where the provider supports them.

Common Troubleshooting & Connection Tips

  • 401 Unauthorized on connect โ€” that's expected; the server is OAuth-protected. Let your client complete the browser consent flow, or inspect the endpoint in our OAuth debugger to see the exact WWW-Authenticate challenge.
  • "Session expired" / stale Mcp-Session-Id โ€” just re-send initialize; stateless clients can ignore session headers entirely.
  • Databases you create live in your Prisma workspace and follow its plan limits.
  • SQL tools execute real statements โ€” write tools can mutate schema and data.

๐Ÿš€ How to Connect

  1. Copy the Prisma Postgres MCP endpoint URL
    The remote endpoint is https://mcp.prisma.io/mcp.
  2. Add it to your MCP client
    Claude Code: claude mcp add --transport http prisma https://mcp.prisma.io/mcp. Cursor: add "prisma": { "url": "https://mcp.prisma.io/mcp" } under mcpServers in ~/.cursor/mcp.json. Other clients work similarly.
  3. Complete the OAuth consent
    On first connection your client opens a Prisma consent screen in the browser. Approve it to grant access; the token is stored by the client and refreshed automatically.
  4. Verify with the online inspector
    Paste https://mcp.prisma.io/mcp into remotemcp.net/inspector, run initialize and tools/list, and confirm Prisma Postgres MCP's 5 tools respond.

โ“ FAQ

What is the Prisma Postgres MCP remote MCP endpoint?

The primary endpoint is https://mcp.prisma.io/mcp. It is an official first-party server operated by Prisma, speaking the Streamable HTTP transport.

How do I authenticate with Prisma Postgres MCP?

Prisma Postgres MCP uses OAuth 2.1. When your client first connects it receives a 401 challenge, discovers the authorization server via RFC 9728 metadata, and opens a browser consent screen. Dynamic Client Registration is supported, so compliant clients register themselves automatically.

I'm getting a 401 Unauthorized from Prisma Postgres MCP โ€” what's wrong?

A 401 means your client hasn't completed (or has lost) the OAuth authorization. Remove and re-add the server in your client to restart the consent flow, and check that your browser session can reach the provider's login page. If the 401 arrives without a WWW-Authenticate header, run it through our OAuth debugger to see what's missing.

Which MCP clients work with Prisma Postgres MCP?

Any client that supports remote MCP servers: Cursor, Claude Code (`claude mcp add --transport http prisma https://mcp.prisma.io/mcp`), VS Code Copilot, ChatGPT connectors, Windsurf, Kiro (`~/.kiro/settings/mcp.json`), and Claude Desktop via the `mcp-remote` bridge.

What tools does Prisma Postgres MCP expose?

5 tools are cataloged in this directory โ€” including `list_databases`, `create_database`, `execute_sql` and more. Use our online inspector to fetch the live tool list straight from the endpoint.

๐Ÿ”— Connect Guides

โš”๏ธ Featured in Comparisons

๐Ÿ“› Embed Status Badge in README

Prisma Postgres MCP status badge
[![Remote MCP Status](https://remotemcp.net/api/badge/status/prisma.svg)](https://remotemcp.net/servers/prisma)
Prisma Postgres MCP inspector badge
[![Test in Inspector](https://remotemcp.net/api/badge/inspect/prisma.svg)](https://remotemcp.net/inspector?url=https%3A%2F%2Fmcp.prisma.io%2Fmcp)
Prisma Postgres MCP audit grade badge
[![MCP Audit Grade](https://remotemcp.net/api/badge/grade/prisma.svg)](https://remotemcp.net/servers/prisma)
Prisma Postgres MCP context tax badge
[![Context Tax](https://remotemcp.net/api/badge/tokens/prisma.svg)](https://remotemcp.net/servers/prisma)

Related Servers

Supabase MCPSupabase

Supabase's hosted MCP server for your projects and databases. Agents can run SQL, apply migrations and generate TypeScript types with OAuth-scoped access.

https://mcp.supabase.com/mcp
๐Ÿ›ก๏ธ Officialโœ“ VerifiedStreamable HTTPOAuth 2.1๐Ÿ›ก๏ธ A+~992 tok30 toolsOnline34ms
MongoDBMongoDB

MongoDB's hosted remote MCP server. MongoDB's hosted MCP server connects agents to Atlas clusters โ€” browse databases, run read queries, inspect schemas and manage Atlas resources with OAuth-scoped access. It is protected by OAuth 2.1; compliant clients complete a browser consent flow with PKCE.

https://mcp.mongodb.com/mcp
๐Ÿ›ก๏ธ Officialโœ“ VerifiedStreamable HTTPOAuth 2.1๐Ÿ›ก๏ธ A+~1112 tok36 toolsOnline542ms
Airtable MCPAirtable

Airtable's official remote MCP server. Agents can list bases and tables, read records, and create or update rows over OAuth 2.1 with granular scopes.

https://mcp.airtable.com/mcp
๐Ÿ›ก๏ธ Officialโœ“ VerifiedStreamable HTTPOAuth 2.1๐Ÿ›ก๏ธ A+~389 tok5 toolsOnline209ms

Neon's official remote MCP server for serverless Postgres. Agents can manage projects and branches and run SQL over Streamable HTTP with OAuth.

https://mcp.neon.tech/mcp
๐Ÿ›ก๏ธ Officialโœ“ VerifiedStreamable HTTPOAuth 2.1๐Ÿ›ก๏ธ A+~742 tok23 toolsOnline338ms