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 💡
T1nker-1220/aws-postgress-mcp-server
An MCP server enabling read-only SQL query access to AWS PostgreSQL databases via stdio transport.
querypie-mcp-server
MCP server for QueryPie enabling administrators to manage data, monitor resources, and detect suspicious behavior.
@avarant/typesense-mcp-server
A Model Context Protocol (MCP) Server that interfaces with Typesense search engine
influxdata/influxdb3_mcp_server
MCP Server for integrating InfluxDB 3 (Core/Enterprise/Cloud Dedicated) with MCP clients
fastomop/omcp_a2a
An MCP server providing tools for interacting with OMOP CDM databases and generating SQL queries using NLP, integrated with Ollama.
mcp-server-tidb
An MCP server implementation that provides access to TiDB (serverless) database functionalities.