# Prisma (MCP Server)

> Manage Prisma Postgres databases, backups and Compute from AI tools

- Type: MCP server
- Publisher: Prisma (official)
- Categories: Development, Data & Analytics
- Website: https://www.prisma.io/docs/postgres/integrations/mcp-server
- Docs: https://www.prisma.io/docs/ai/mcp-tools
- Transport: streamable-http
- Server URL: https://mcp.prisma.io/mcp
- Sign-in: oauth
- Listed: 2025-06-01

## About

Prisma's remote MCP server lets AI tools create and manage Prisma Postgres databases, connection strings, backups and recoveries, run SQL and introspect schemas. It also covers Object Storage, Prisma Compute deployments and documentation search. Users sign in with their Prisma account and pick a workspace.

## Install

1. **Connect it in ChatGPT** Turn on Developer mode in ChatGPT (Settings → Security and login), open Plugins, select + and paste https://mcp.prisma.io/mcp as the MCP server URL, then sign in with OAuth. Add it to a chat from the composer's tools menu.

2. **Or add it to Codex or the API**

   Codex CLI:

   ```bash
   codex mcp add prisma --url https://mcp.prisma.io/mcp
   codex mcp login prisma
   ```

   config.toml:

   ```toml
   [mcp_servers.prisma]
   url = "https://mcp.prisma.io/mcp"
   ```

   Responses API:

   ```python
   import os
   from openai import OpenAI
   
   client = OpenAI()
   
   response = client.responses.create(
       model="gpt-6-astra",
       tools=[{
           "type": "mcp",
           "server_label": "prisma",
           "server_url": "https://mcp.prisma.io/mcp",
           "authorization": os.environ["PRISMA_API_KEY"],
           "require_approval": "never",
       }],
       input="Create a new Prisma Postgres database in my workspace",
   )
   print(response.output_text)
   ```

## Tools

- `fetch_workspace_details`
- `list_prisma_postgres_databases`
- `create_prisma_postgres_database`
- `delete_prisma_postgres_database`
- `create_prisma_postgres_connection_string`
- `list_prisma_postgres_backups`
- `create_prisma_postgres_recovery`
- `execute_sql_query`
- `introspect_database_schema`
- `search_prisma_documentation`

## Example prompts

- "Create a new Prisma Postgres database in my workspace"
- "Introspect the schema of my database"
- "Restore yesterday's backup to a new database"
- "How do I define a many-to-many relation in Prisma?"

## Also available as

- app: [Prisma](https://chatgptplugins.directory/apps/prisma.md)

## Related

- [Chrome DevTools MCP](https://chatgptplugins.directory/mcp/chrome-devtools.md): Let coding agents control and debug a live Chrome browser
- [Playwright MCP](https://chatgptplugins.directory/mcp/playwright.md): Browser automation for agents via Playwright accessibility snapshots
- [GitHub](https://chatgptplugins.directory/mcp/github.md): Manage repos, issues, pull requests and Actions from your AI agent
- [Context7](https://chatgptplugins.directory/mcp/context7.md): Pull up-to-date, version-specific library docs into your coding agent
- [Supabase](https://chatgptplugins.directory/mcp/supabase.md): Manage Supabase databases, migrations, edge functions and logs
- [Stripe](https://chatgptplugins.directory/mcp/stripe.md): Query and act on your Stripe account and search Stripe docs from any agent

---
Source: https://chatgptplugins.directory/mcp/prisma · Index: https://chatgptplugins.directory/llms.txt · Independent and community-run. Not affiliated with or endorsed by OpenAI. ChatGPT is a trademark of OpenAI.