CreateBackupToolLABSCO SUMMARY
Provisioning and recovery, both inside the agent's reach.
The backup and restore pair is what lifts it above a query tool: an agent can take a backup before a migration and restore into a fresh database when it goes wrong, without anyone opening a console.
What it is
Prisma's MCP offering, in two shapes: a local server for a developer working on their own machine, and a remote server for platforms that want to hand database management to their own users. The tools below are the remote server's, covering Prisma Postgres databases, connection strings, backups and queries.
What you get
- Prisma Postgres databases in your workspace listed, and one deleted by id
- A connection string created for a database, listed, or deleted
- A managed backup created, and the available backups listed
- A database restored from a backup into a new database
- SQL executed against a Prisma Postgres database
- A database's schema introspected
Requirements
The remote server runs through mcp-remote against Prisma's hosted endpoint, and follows the standard JSON MCP client configuration. Choose the local server instead if you are working against a database on your own machine.
Setup effort
Paste a URL, then authorize — add the endpoint to your client, then approve the OAuth consent screen
USE CASES
01
Getting a connection string for a database you just made
Find the database in the workspace, then mint a connection string against it.
02
Taking a safety net before a migration
Create a managed backup and confirm it landed before the schema changes.
03
Recovering from a migration that went wrong
Pick the backup from before the change and restore it into a new database rather than over the top of the broken one.
04
Answering a question about live data
Run the SQL against the database directly and read the result in the conversation.
05
Finding out what shape the schema is actually in
Introspect the database rather than trusting the schema file in the repository.
06
Rotating credentials after someone leaves
List the existing connection strings, delete the ones that should go, and issue replacements.
17 tools
Listed in project docs. Your client may show a different list.
CreateConnectionStringToolCreateRecoveryToolDeleteConnectionStringToolDeleteDatabaseToolListBackupsToolListConnectionStringsToolListDatabasesToolExecuteSqlQueryToolIntrospectSchemaToolmigrate-statusmigrate-devmigrate-resetPrisma-Postgres-account-statusCreate-Prisma-Postgres-DatabasePrisma-LoginPrisma-StudioBEFORE YOU INSTALL
What to know first
Tools you get
17 tools named in the project's documentation.
Requires
npx on PATH
INSTALLATION
Connect your client
Add the endpoint to your client, then approve the OAuth consent screen.
Server setup
ENDPOINT URL
https://mcp.prisma.io/mcpMCP Clients
VS Code
VS CODE · JSON
{
"servers": {
"Prisma-Local": {
"command": "npx",
"args": [
"-y",
"prisma",
"mcp"
]
},
"Prisma-Remote": {
"command": "npx",
"args": [
"-y",
"mcp-remote",
"https://mcp.prisma.io/mcp"
]
}
}
}Cursor, Windsurf, Claude Desktop
JSON
{
"mcpServers": {
"Prisma-Local": {
"command": "npx",
"args": [
"-y",
"prisma",
"mcp"
]
},
"Prisma-Remote": {
"command": "npx",
"args": [
"-y",
"mcp-remote",
"https://mcp.prisma.io/mcp"
]
}
}
}Warp
WARP · JSON
{
"mcpServers": {
"Prisma": {
"command": "npx",
"args": [
"-y",
"prisma",
"mcp"
],
"env": {},
"working_directory": null,
"start_on_launch": true
}
}
}Claude Code
CLAUDE CODE · TERMINAL
claude mcp add prisma-local npx prisma mcp
