如何将 Prisma Postgres 远程 MCP 连接到 Cline
约 1 分钟即可把 Prisma 的远程 MCP 服务端接入 Cline。如需排查 OAuth / 401 问题,可先用 OAuth 2.1 调试器体检端点。
Streamable HTTPhttps://mcp.prisma.io/mcp
Install in Cursor →
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
Install in VS Code →
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"
}
}
}接入步骤
- 打开 Cline MCP 设置 — Cline 侧边栏 → MCP Servers → 编辑
cline_mcp_settings.json。 - 添加服务端 — 写入
"prisma": { "type": "streamableHttp", "url":https://mcp.prisma.io/mcp}。 - 完成认证 — 首次调用时客户端会打开 Prisma 的 OAuth 授权页面——点击允许后工具即可用。
- 验证 — 在 在线 Inspector 中粘贴
https://mcp.prisma.io/mcp并运行 initialize + tools/list 验证连通性。
🧰 工具预览(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 |