# Prisma — MCP server on mcp.ai
> Prisma Data Platform provides database tools including Accelerate (global database cache), Optimize (AI-driven query analysis), and Prisma Postgres (managed PostgreSQL). Manage workspaces, projects, environments, and API keys programmatically.

By: mcp.ai · official
Page: https://mcp.ai/prisma

## Connect (MCP protocol)
Remote MCP endpoint (HTTP, streamable): https://api.mcp.ai/p_prisma?ms=1781542320000
Add it as a custom/remote MCP connector, then authenticate when prompted.

## REST API (no MCP client required)
Every tool is also a REST endpoint, authed with a workspace API key.
Discover: GET https://api.mcp.ai/api/prisma/_endpoints   # public; lists every endpoint
Call:     POST https://api.mcp.ai/api/prisma/<endpoint>
  Authorization: Bearer sk_live_…   # create one at https://mcp.ai/settings/api-keys
  Content-Type: application/json
  Body: { …args }   →   { "ok": true, "tool": "<id>", "result": { … } }

## Developer docs
How to use (MCP or REST), markdown: https://mcp.ai/prisma/skill.md
Postman collection (v2.1): https://mcp.ai/prisma/postman.json

## Tools
- prisma_create_connection(name: string, databaseId: string) — Create new api key connection for database access. creates connection string with embedded credentials for application database access. returns complete connection details ready for immediate use.
- prisma_create_database(name: string, region: string, isDefault?: boolean, projectId: string) — Create new postgres database in an existing prisma project. creates database in specified region with connection strings and api keys. returns complete database details ready for immediate use.
- prisma_create_project(name: string, region: string) — Create new prisma project with managed postgres database. creates project in authenticated user's workspace with postgres database in specified region. returns complete project details including conne
- prisma_delete_connection(id: string) — Permanently delete database connection and revoke api key access. warning: this immediately revokes database access for any applications using this connection string. ensure no critical systems depend
- prisma_delete_database(databaseId: string) — Permanently delete prisma database and all stored data. warning: this action cannot be undone. all data in the database will be permanently destroyed. default databases typically cannot be deleted.
- prisma_delete_project(id: string) — Permanently delete prisma project and all associated resources. warning: this action cannot be undone. all databases, environments, and project data will be permanently destroyed. use with extreme cau
- prisma_execute_sql_command(command: string, parameters?: string[], connectionString: string) — Execute sql commands that modify database data or structure. runs insert, update, delete, create table, and other data modification commands safely through postgresql driver with parameterized query s
- prisma_execute_sql_query(query: string, parameters?: string[], connectionString: string) — Execute sql select queries against prisma databases. runs read-only queries safely through postgresql driver with automatic type mapping. perfect for data analysis, schema inspection, and reporting op
- prisma_get_database(databaseId: string) — Retrieve specific prisma database by id. returns database details including status, project context, and regional deployment. use for database monitoring, validation, and administrative operations.
- prisma_get_project(id: string) — Retrieve specific prisma project by id. returns project details including name, creation timestamp, and workspace information. use for project detail views, validation, and administrative operations.
- prisma_inspect_database_schema(tableName?: string, includeIndexes?: boolean, connectionString: string) — Inspect database schema structure and table information. returns comprehensive schema details including tables, columns, data types, constraints, and relationships. essential for understanding databas
- prisma_list_accelerate_regions() — Retrieve all available regions for prisma accelerate. returns regions where accelerate global database cache can be deployed. use for cache region selection to minimize latency for your users.
- prisma_list_backups(limit?: integer, databaseId: string) — Retrieve list of available backups for a specific database. returns backup details including status, size, type, and restoration readiness. use for backup monitoring, restoration planning, and complia
- prisma_list_connections(limit?: integer, cursor?: string, databaseId: string) — Retrieve paginated list of connections for a specific database. returns connection details including names, creation dates, and database context. use for api key management, security audits, and acces
- prisma_list_databases(limit?: integer, cursor?: string, projectId: string) — Retrieve paginated list of databases for a specific prisma project. returns database details including status, region, and project context. use for database discovery, monitoring, and project administ
- prisma_list_postgres_regions() — Retrieve all available regions for prisma postgres. returns regions where prisma postgres databases can be deployed with current availability status. use for region selection during database creation 
- prisma_list_projects(limit?: integer, cursor?: string) — Retrieve paginated list of prisma projects accessible to authenticated user. returns project ids, names, workspace info, and timestamps with cursor-based pagination. use for project discovery, ui sele
- prisma_list_workspaces(limit?: integer, cursor?: string) — Retrieve paginated list of prisma workspaces accessible to authenticated user. returns workspace ids, names, creation timestamps with cursor-based pagination. use for workspace discovery, ui selection
- prisma_restore_backup(backupId: string, databaseId: string, targetDatabaseName: string) — Restore database backup to new database instance. creates new database from existing backup with specified name. operation is asynchronous - monitor the returned database status for completion. restor
- prisma_transfer_project(id: string, recipientAccessToken: string) — Transfer prisma project ownership to another user. changes project ownership to recipient specified by their access token. current owner loses access unless explicitly granted by new owner.

## Links
Docs: https://mcp.ai/docs/mcps/prisma
Website: https://mcp.ai/mcps/prisma