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-databricks-server
MCP Server for Databricks
prisma/mcp
A remote Model-Context-Protocol (MCP) server by Prisma, designed for AI platforms to manage Prisma Postgres databases and execute SQL queries.
mcp-node-mssql
An MCP server that provides context from SQL Server databases using the node-mssql library.
@xexr/mcp-libsql
A secure Model Context Protocol (MCP) server for libSQL databases, offering comprehensive tools, connection pooling, and transaction support, built with TypeScript for various MCP clients.
mcp-server-ds
null
@skysqlinc/skysql-mcp
SkySQL MCP server and client repository.