MCP App Store
by KeenEthics
Prisma icon

Prisma MCP Server for Claude and ChatGPT

By View source

Overview

Prisma MCP integration for Postgres database management, schema migrations, SQL queries, and connection string management. Provision Prisma Postgres databases, run migrations, and interact with your data directly.

How to connect

  1. Claude: Open the Prisma plugin listing for Claude and install it in Claude Code. Claude listing Prisma exposes 18 tools here.
  2. ChatGPT: Open the Prisma listing in the ChatGPT app directory and choose Connect. ChatGPT listing Prisma exposes 42 tools here.

Tools

create_object_store_bucket

ChatGPT
Creates an object-store bucket in a project. The name is generated when omitted, and the bucket belongs to the project's default branch when no branch ID is provided.

create_object_store_bucket_key

ChatGPT
Creates an S3-compatible access key for an object-store bucket. The secret access key is returned once and cannot be retrieved later.

create_prisma_branch

ChatGPT
Create a Git branch's Prisma environment. The first branch in an empty project becomes production; later branches are previews.

create_prisma_postgres_connection_string

ChatGPT
Creates a named connection string for a Prisma Postgres database. Returns the Prisma connection string and a direct Postgres connection string when one is available.

create_prisma_postgres_database

ChatGPT
Creates a managed Prisma Postgres database and project in the selected region. Returns Prisma and direct Postgres connection strings.

create_prisma_postgres_recovery

ChatGPT
Restores a Prisma Postgres backup into a new database. The target database name must be unique within the workspace.

create_prisma_project

ChatGPT
Create an empty project in the selected workspace. A project groups an app and its databases and branches. This does not create a database or a deployment.

delete_object_store_bucket

ChatGPT
Permanently deletes an object-store bucket, every object stored in it, and all its access keys. This action cannot be undone.

delete_object_store_bucket_key

ChatGPT
Permanently deletes an object-store bucket access key. The key stops working immediately and cannot be restored.

delete_prisma_compute_app

ChatGPT
Permanently deletes a Prisma Compute app. This action cannot be undone. If deleteDeployments is false and active deployments exist, deletion fails with a conflict.

delete_prisma_compute_deployment

ChatGPT
Permanently deletes a Prisma Compute deployment, stopping it and removing its endpoint binding if needed. This can interrupt traffic and cannot be undone.

delete_prisma_compute_env_var

ChatGPT
Permanently deletes a Prisma Compute environment variable by ID. The stored value cannot be recovered.

delete_prisma_postgres_connection_string

ChatGPT
Permanently deletes a Prisma Postgres connection string by ID. The connection string cannot be restored.

delete_prisma_postgres_database

ChatGPT
Permanently deletes a Prisma Postgres database by ID. This action cannot be undone. A project's default database cannot be deleted independently.

execute_prisma_postgres_schema_update

ChatGPT
Executes schema-changing SQL on a Prisma Postgres database. Schema changes may cause permanent data loss.

execute_sql_query

ChatGPT
Executes a data SQL query on a Prisma Postgres database. The query may read, modify, or delete data but cannot change the database schema.

fetch_workspace_details

ChatGPT
Fetch the details of the selected Prisma Postgres workspace. The Result will be returned as JSON.

get_agent_approval

ChatGPT
Read a decision on this agent's approval request. Prefer the prisma.approval.resolved MCP event when your harness supports Events; otherwise check this tool every five seconds until the request is decided or expires.

get_agent_connection

ChatGPT
Read this Prisma MCP connection's enrolled agent identity, workspace access, and permission policy. The MCP client's OAuth authorization enrolls the connection automatically.

get_database_schema

ChatGPT
Shows the database schema recorded by Prisma 8 migrations. On a non-main branch, compares its current applied contract with the matching database on main. Does not introspect the live database or run migrations.

get_prisma_composer_topology

ChatGPT
Returns the last reported Composer topology and Console links for a project branch, plus its current apps and their stored endpoint URLs. Logical IDs identify authored nodes, not deployed resource IDs. This is not live deployment health. A null writtenAt and empty graph mean no topology has been reported. Does not return environment variable values or credentials.

get_prisma_compute_deployment_logs

ChatGPT
Reads a finite page of runtime logs for a Prisma Compute deployment by ID. The terminal record includes a cursor for the next page.

get_prisma_github_setup

ChatGPT
Get the Console link where the sponsor can install or connect the Prisma GitHub App to the selected workspace. GitHub access must be authorized by a person.

introspect_database_schema

ChatGPT
Returns the schema of a Prisma Postgres database as structured JSON.

list_object_store_buckets

ChatGPT
Lists object-store buckets in the workspace, up to 100 per page. Results can be filtered by project ID, and a non-null next cursor indicates another page.

list_prisma_branches

ChatGPT
List a project's production and preview branches. Each branch has its own apps and databases.

list_prisma_compute_apps

ChatGPT
List Prisma Compute apps in the selected workspace. Results are ordered from oldest to newest. Use projectId to narrow the list and nextCursor to fetch another page.

list_prisma_compute_builds

ChatGPT
List Prisma Compute builds in the selected workspace, newest first. Results can be filtered by project, branch, or state. Use nextCursor to fetch another page.

list_prisma_compute_deployments

ChatGPT
Lists deployments for a Prisma Compute app by ID, newest first. Results include a nextCursor when another page is available.

list_prisma_github_installations

ChatGPT
List active GitHub App installations connected to the selected workspace. Use an installation ID to list repositories or link a project.

list_prisma_github_repositories

ChatGPT
List repositories visible to a GitHub App installation in this workspace. Returns GitHub's numeric repository ID for linking. Fetch subsequent pages when hasMore is true.

list_prisma_postgres_backups

ChatGPT
Lists the available automated backups for a Prisma Postgres database.

list_prisma_postgres_connection_strings

ChatGPT
Lists the available connection strings for a Prisma Postgres database, 100 per page. When nextCursor is non-null there are more connection strings; call again with cursor set to it.

list_prisma_postgres_databases

ChatGPT
Lists the Prisma Postgres databases in the selected workspace, including each database's project, region, status, and ID, 100 per page. When nextCursor is non-null there are more databases; call again with cursor set to it.

list_prisma_projects

ChatGPT
List projects in the selected workspace, including their IDs and names. A project groups an app and its databases and branches.

promote_prisma_compute_deployment

ChatGPT
Promote a deployment to be the live endpoint for a Prisma Compute app. The deployment must be running. Returns the stable endpoint domain.

rollback_prisma_compute_app

ChatGPT
Roll a Prisma Compute app back to an existing deployment. The target is started if it is stopped. Returns the stable endpoint domain and whether a cold start was performed.

search_prisma_documentation

ChatGPT
Search Prisma's official documentation and knowledge sources to answer questions about Prisma Compute, Prisma Postgres, Prisma ORM, schema design, and migrations. Returns an answer grounded in the docs, with citations.

set_prisma_compute_env_var

ChatGPT
Create or update an environment variable for a Prisma Compute project. The value is stored encrypted and is never returned. Omit branchId to set a project-level template variable. class "production" is template-only, so it never takes a branchId. A branchId is allowed only with class "preview" and only for a preview branch; the production branch reads the template.

start_prisma_compute_deployment

ChatGPT
Start a Prisma Compute deployment by requesting VM creation in Foundry. The artifact must already be uploaded. Returns the preview domain once the start request is accepted.

stop_prisma_compute_deployment

ChatGPT
Stop a running Prisma Compute deployment by requesting VM shutdown in Foundry. If the deployment is the app's live endpoint, the endpoint binding is removed first.

create_object_store_bucket

Claude

create_object_store_bucket_key

Claude

create_prisma_postgres_connection_string

Claude

create_prisma_postgres_database

Claude

create_prisma_postgres_recovery

Claude

delete_object_store_bucket

Claude

delete_object_store_bucket_key

Claude

delete_prisma_postgres_connection_string

Claude

delete_prisma_postgres_database

Claude

execute_prisma_postgres_schema_update

Claude

execute_sql_query

Claude

fetch_workspace_details

Claude

introspect_database_schema

Claude

list_object_store_buckets

Claude

list_prisma_postgres_backups

Claude

list_prisma_postgres_connection_strings

Claude

list_prisma_postgres_databases

Claude

search_prisma_documentation

Claude

Example Prompts

Click any prompt to copy it.

Similar Apps

Listed on MCP App Store

Listed on MCP App Store

Add this badge to your site or README. It links to this page.

HTML

<a href="https://mcp-app-store.keenethics-labs.com/app/prisma"><img src="https://mcp-app-store.keenethics-labs.com/badges/listed-on-mcp-app-store.svg" alt="Listed on MCP App Store" width="220" height="44"></a>

Markdown

[![Listed on MCP App Store](https://mcp-app-store.keenethics-labs.com/badges/listed-on-mcp-app-store.svg)](https://mcp-app-store.keenethics-labs.com/app/prisma)