Prisma-Remote
The Model-Context-Protocol (MCP) gives LLMs a way to call APIs and thus access external systems in a well-defined manner. Prisma's provides two MCP servers: a *local* and a *remote* one. If you're building an "AI platform" and want to give the ability to manage database to your users, use the remote MCP server.
The Prisma Remote MCP Server allows AI agents to interact with Prisma's database management capabilities. It is designed for developers building AI platforms who want to provide database management functionalities to their users.
Capabilities: The server exposes a set of tools for database operations, including:
CreateBackupToolCreateConnectionStringToolCreateRecoveryToolDeleteConnectionStringToolDeleteDatabaseToolListBackupsToolListConnectionStringsToolListDatabasesToolExecuteSqlQueryToolIntrospectSchemaTool
Usage: The Prisma Remote MCP Server can be integrated into AI tools in two primary ways:
-
Direct Endpoint Connection: Many AI platforms and playgrounds (e.g., Cloudflare's AI Playground, Claude Desktop & Web integrations) can connect directly to the server's endpoint URL:
https://mcp.prisma.io/mcp -
Local stdio Proxy: For local development environments or tools that prefer a stdio interface, you can run a local client that proxies to the remote server:
npx -y mcp-remote https://mcp.prisma.io/mcp
Configuration Example (JSON):
{
"mcpServers": {
"Prisma-Remote": {
"command": "npx",
"args": ["-y", "mcp-remote", "https://mcp.prisma.io/mcp"]
}
}
}
Recommend MCP Servers 💡
mcp-snowflake-reader
A read-only MCP server providing secure access to Snowflake databases via MCP protocol
mcp-odbc-server
Typescript based Model Context Procotol (MCP) Server for Open Database Connectivity (ODBC)
fireproof
A Model Context Protocol server that provides a JSON document store with CRUD operations using a Fireproof database for LLM tool use.
mcp-clickhouse
Connect ClickHouse to your AI assistants.
@niledatabase/nile-mcp-server
MCP server for Nile Database - Manage and query databases, tenants, users, auth using LLMs
@joshuayoes/deno-kv-mcp
An MCP server for interacting with Deno KV (Key-Value) instances, providing tools to set, get, delete, and list key-value pairs.