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 💡
@gongrzhe/server-redis-mcp
A Redis MCP server implementation for interacting with Redis databases
gateway
Universal MCP-Server for your Databases optimized for LLMs and AI-Agents.
schemaflow
Real-time PostgreSQL & Supabase schema access for AI-IDEs via Model Context Protocol (MCP)
kwdb-mcp-server
A server implementation of the Model Context Protocol (MCP) that enables interaction with the KWDB database, supporting read, write, query, and DDL operations, and providing business intelligence features.
py-mcp-mssql
A Model Context Protocol server for accessing Microsoft SQL Server databases
memgraph/ai-toolkit
A lightweight MCP server connecting Memgraph with LLMs, exposing database tools via MCP