Prisma Postgres Official Remote MCP Server
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.
- 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 โ
Or add to ~/.cursor/mcp.json:
{
"mcpServers": {
"prisma": {
"url": "https://mcp.prisma.io/mcp"
}
}
}claude mcp add --transport http prisma https://mcp.prisma.io/mcp
Or add to .vscode/mcp.json:
{
"servers": {
"prisma": {
"type": "http",
"url": "https://mcp.prisma.io/mcp"
}
}
}- Open Settings โ Connectors (Integrations) โ Add Custom Connector.
- Paste the endpoint URL:
https://mcp.prisma.io/mcp - Complete the browser OAuth 2.1 login flow when prompted.
Bridge the remote endpoint into stdio with mcp-remote in claude_desktop_config.json:
{
"mcpServers": {
"prisma": {
"command": "npx",
"args": [
"-y",
"mcp-remote",
"https://mcp.prisma.io/mcp"
]
}
}
}Add to ~/.codeium/windsurf/mcp_config.json:
{
"mcpServers": {
"prisma": {
"serverUrl": "https://mcp.prisma.io/mcp"
}
}
}Add to ~/.kiro/settings/mcp.json (or .kiro/settings/mcp.json in your workspace), then reopen Kiro's Agent panel to pick up the server:
{
"mcpServers": {
"prisma": {
"url": "https://mcp.prisma.io/mcp"
}
}
}Add to ~/.codex/config.toml โ Codex reads remote HTTP servers from [mcp_servers.*] tables:
[mcp_servers.prisma] url = "https://mcp.prisma.io/mcp"
Add to cline_mcp_settings.json (Cline โ MCP Servers โ Configure), or paste it via Cline's MCP marketplace file:
{
"mcpServers": {
"prisma": {
"type": "streamableHttp",
"url": "https://mcp.prisma.io/mcp"
}
}
}Add to ~/.gemini/settings.json under mcpServers โ httpUrl for Streamable HTTP, url for legacy SSE:
{
"mcpServers": {
"prisma": {
"httpUrl": "https://mcp.prisma.io/mcp"
}
}
}๐งฐ Prisma Postgres MCP Tools & Schema (5)
| Tool | Safety | Description | Parameters |
|---|---|---|---|
| list_databases ~39 tok | ๐ข Read | List Prisma Postgres databases in your workspace. | โ |
| create_database ~64 tok | ๐ Write | Provision a new Prisma Postgres database. | name*: stringregion: string |
| execute_sql ~68 tok | ๐ Write | Run a SQL statement against a database. | databaseId*: stringsql*: string |
| get_database_schema ~55 tok | ๐ข Read | Inspect tables and columns of a database. | databaseId*: string |
| get_connection_string ~55 tok | ๐ข Read | Get a connection string for a database. | databaseId*: string |
๐ก๏ธ Security, Quality & Context Token Audit
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)
๐งฉ 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-Authenticatechallenge. - "Session expired" / stale
Mcp-Session-Idโ just re-sendinitialize; 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
- Copy the Prisma Postgres MCP endpoint URLThe remote endpoint is https://mcp.prisma.io/mcp.
- Add it to your MCP clientClaude Code:
claude mcp add --transport http prisma https://mcp.prisma.io/mcp. Cursor: add"prisma": { "url": "https://mcp.prisma.io/mcp" }undermcpServersin ~/.cursor/mcp.json. Other clients work similarly. - Complete the OAuth consentOn 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.
- Verify with the online inspectorPaste 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
Related Servers
Supabase's hosted MCP server for your projects and databases. Agents can run SQL, apply migrations and generate TypeScript types with OAuth-scoped access.
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.
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.
Neon's official remote MCP server for serverless Postgres. Agents can manage projects and branches and run SQL over Streamable HTTP with OAuth.