mcp

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 ge