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. See below for specific information on each.
If you're a developer working on a local machine and want your AI agent to help with your database workflows, use the local MCP server.
If you're building an "AI platform" and want to give the ability to manage database to your users, use the remote MCP server.
You can start the remote MCP server as follows:
npx -y mcp-remote https://mcp.prisma.io/mcp
Tools represent the capabilities of an MCP server. Here's the list of tools exposed by the remote MCP server:
CreateBackupTool: Create a new managed Prisma Postgres Backup.CreateConnectionStringTool: Create a new Connection String for a Prisma Postgres database with the given id.CreateRecoveryTool: Restore a Prisma Postgres Database to a new database with the given Backup id.DeleteConnectionStringTool: Delete a Connection String with the given connection string id.DeleteDatabaseTool: Delete a Prisma Postgres database with the given id.ListBackupsTool: Fetch a list of available Prisma Postgres Backups for the given database id and environment id.ListConnectionStringsTool: Fetch a list of available Prisma Postgres Database Connection Strings for the given database id and environment id.ListDatabasesTool: Fetch a list of available Prisma Postgres Databases for user's workspace.ExecuteSqlQueryTool: Execute a SQL query on a Prisma Postgres database with the given id.IntrospectSchemaTool: Introspect the schema of a Prisma Postgres database with the given id.
Once you're connected to the remote MCP server, you can also always prompt your AI agent to "List the Prisma tools" to get a full overview of the latest supported tools.
The remote Prisma MCP server follows the standard JSON-based configuration for MCP servers. Here's what it looks like:
{
"mcpServers": {
"Prisma-Remote": {
"command": "npx",
"args": ["-y", "mcp-remote", "https://mcp.prisma.io/mcp"]
}
}
}