Prisma MCP server

Connect Prisma to Claude, ChatGPT, Cursor, Claude Code, Codex, Gemini, GitHub Copilot and any other MCP client, for your whole team. Metorial adds security, governance, and tracing, and gives everyone one Magic MCP URL to connect.

What you can do with the Prisma MCP server

Ask your agent in plain language. Each of these maps to a real tool on the server.

  • Use the create database tool in Prisma
  • Use the create connection tool in Prisma
  • Use the get project tool in Prisma
  • Use the list databases tool in Prisma
  • Use the transfer project tool in Prisma
  • Use the delete connection tool in Prisma

Supported Tools

create_database

Create Database

Create a new Prisma Postgres database within an existing project. The database will be provisioned in the specified region and connection details will be returned.

create_connection

Create Connection

Create a new connection string for a Prisma Postgres database. This generates new credentials that can be used to connect to the database.

get_project

Get Project

Retrieve details of a specific project by its ID, including its associated databases and their connection information.

list_databases

List Databases

Discover accessible Prisma Postgres database IDs, names, regions, and projects. Optionally filter by a project ID from list_projects. Omit cursor and limit to retrieve all pages.

transfer_project

Transfer Project

Transfer a project (including all its databases) to another user's workspace. The recipient must have provided an OAuth access token that grants workspace access. This is typically used in partner provisioning flows.

delete_connection

Delete Connection

Delete a connection string from a Prisma Postgres database. Any applications using this connection will lose access.

list_workspaces

List Workspaces

List all workspaces accessible to the authenticated user. Workspaces are organizational containers for projects and databases on the Prisma Data Platform.

get_database_usage

Get Database Usage

Retrieve Prisma Postgres operation and storage usage for a date range. Legacy query-count and egress fields remain absent when the provider does not report them.

get_database

Get Database

Retrieve detailed information about a specific Prisma Postgres database, including its connection strings, direct connection credentials, endpoints, and project association.

create_project

Create Project

Create a new project with a default Prisma Postgres database. A project is a container for databases. When a region is provided, a default database is provisioned unless createDefaultDatabase is false.

list_connections

List Connections

List connections for a specific Prisma Postgres database, including direct, pooled, and Accelerate endpoints. Secret connection strings may only be returned when created.

delete_database

Delete Database

Permanently delete a Prisma Postgres database. This action is irreversible and will destroy all data, connections, and backups associated with the database.

get_database_backups

Get Database Backups

Retrieve recent backup metadata for a Prisma Postgres database, including retention and whether more backups exist. The API does not expose a continuation cursor for this endpoint.

get_current_user

Get Current User

Identify the authenticated Prisma user, workspace, and credential type. Service tokens may have a workspace without a user.

delete_project

Delete Project

Permanently delete a Prisma project and its resources. Discover the project with list_projects and verify ownership before deletion.

list_regions

List Regions

Discover Prisma Postgres region IDs and availability before provisioning a database.

list_projects

List Projects

Discover accessible Prisma projects with their IDs, names, workspace, and default region. Use these project IDs when managing databases.

Connect Prisma to your AI client

Every client uses the same Magic MCP URL, and so does any other MCP client. Add it once and sign in with SSO.

  1. Enable Prisma in Metorial. In your Metorial portal, enable the Prisma MCP server and sign in with the account that owns the data. Access stays governed by your team policies.
  2. Add a custom connector. Open Customize, then Connectors. Select Add, then Custom, then Web.
  3. Paste your Metorial MCP URL. Name it Metorial, paste your Magic MCP URL (<your-magic-mcp-url>) and continue.
  4. Sign in. Select Add and sign in to load Prisma tools.

Run Prisma through the Metorial gateway

One governed layer for every app your agents reach, not a separate connector per tool.

  • Give Prisma and every other app to your whole team through one MCP gateway, behind your SSO.
  • Scope which teams and agents can use Prisma tools with role-based access control, and trace every call.
  • Prefer to run it yourself? Metorial is open source and self-hostable.

More integrations teams use with Prisma

Google Sheets

Create, read, and update spreadsheets and their cell data. Read and write values to individual cells, ranges, or multiple ranges using A1 notation or named ranges. Apply cell formatting including text styles, backgrounds, borders, number formats, and conditional formatting. Manage sheets (tabs) within a spreadsheet—add, delete, copy, rename, and reorder them. Create and manage embedded charts, pivot tables, filter views, data validation rules, protected ranges, named ranges, and merged cells. Perform batch operations to apply multiple updates atomically.

GitHub

Manage repositories, issues, and pull requests. Create and configure branches, star repositories, review code, and merge changes. Automate CI/CD workflows with GitHub Actions, manage workflow runs, secrets, and artifacts. Track issues with labels, milestones, and assignees. Search across code, repositories, issues, and users. Manage organizations, teams, and memberships. Create and manage projects, gists, packages, deployments, and environments. Access security alerts including code scanning, secret scanning, and Dependabot alerts. Read and write file contents in repositories. Manage webhooks, notifications, and codespaces.

Salesforce

Manage CRM data including Accounts, Contacts, Leads, Opportunities, Cases, and custom objects. Create, read, update, and delete records. Query data using SOQL and search across objects using SOSL. Perform bulk data operations for large-scale imports, exports, and migrations. Execute composite requests to batch multiple operations in a single API call. Access analytics, reports, and dashboards. Manage files and attachments associated with records. Interact with Chatter feeds, posts, and groups for social collaboration. Manage org metadata including custom objects, fields, layouts, and workflows. Query data using GraphQL for precise data retrieval across related objects.

Sharepoint

Manage SharePoint sites, document libraries, lists, and files. Create, read, update, and delete lists and list items with custom columns. Resolve site users to numeric Person/Group LookupId values. Upload, download, move, copy, and version files in document libraries. Search across sites, files, folders, lists, and list items using Microsoft Search. Manage permissions at site, list, and item levels with granular access control. Define and manage content types and site columns. Retrieve site properties and search for sites across Microsoft 365.

Airtable

Create, read, update, and delete records in Airtable bases and tables. Manage base schemas including creating tables and fields. Filter records using formulas, sort by fields, and scope queries to specific views. Upsert records to find, create, or update in a single call. Upload attachments to records, read and write record comments, list accessible bases, and receive real-time base change events through webhooks.

Google Drive

Upload, download, create, copy, move, rename, trash, and permanently delete files and folders in Google Drive. Search for files using complex queries filtering by name, MIME type, owner, modification date, labels, and other metadata. Share files and folders with specific users, groups, or domains with role-based permissions (owner, writer, commenter, reader). Manage shared drives and their members. Export Google Workspace files (Docs, Sheets, Slides) to standard formats like PDF, DOCX, and XLSX. Track file revision history and restore earlier versions. Create, read, update, and delete threaded comments and replies on files. Read label definitions and search files by label. Browse the Drive apps installed for your account. Store app-specific data in a hidden per-user folder.

Technical notes for Prisma

Manage Prisma Postgres projects, databases, connections, backups, and usage with the public REST API. Discover authorized workspaces and available regions, provision databases, transfer projects through controlled partner flows, and identify the authenticated principal.

Frequently asked questions

Common questions about connecting Prisma to AI agents with Metorial.

  1. How many tools does the Prisma MCP server have?
    The Prisma MCP server exposes 17 tools, including Create Database, Create Connection, Get Project. Each one is governed and traced through Metorial.
  2. Prisma exposes tools your agents call on demand; it does not publish event triggers yet. Everything still runs through one governed MCP URL.
  3. Any MCP client, including VS Code, Windsurf, Zed, OpenCode and Grok. Each one reaches the Prisma MCP server through the same Metorial URL.
  4. Use role-based access control to decide which teams, users, and agents can use Prisma and which of its tools they can call.
  5. Yes. Metorial is open source, so you can run the Prisma MCP server yourself or use the hosted gateway.

Connect Prisma to production AI agents

See how Metorial gives your team governed access to Prisma, with tracing and security controls built in.