How to connect Prisma to Claude

Connect Claude Web, Desktop and Cowork to Prisma MCP. Create a new postgres database in your project, run a sql query to list all users, and more using natural language, with authentication handled for you.

Get started for free Get a demo

Prisma

Oauth2Api Key

Prisma Data Platform is a suite of database tools for managing workspaces, projects, and PostgreSQL environments. It simplifies data access, query optimization, and secure platform automation.

22 Tools

Managed auth

Connect Prisma without auth hassles

We manage OAuth, API keys, token refresh, and scopes — you just build.

Book a call

Explore the MCP Gateway

Introduction

Claude is Anthropic's AI assistant, available on the web, in the desktop app, and on mobile. Cowork is its agent for knowledge work, and it runs on all of those surfaces too. Connected to your apps, Claude can work with your files and services to accomplish complex tasks on your behalf.

This guide walks you through the easiest and most secure way to connect your Prisma account to Claude via Composio Connect, enabling it to create a new Postgres database in your project, run a SQL query to list all users, delete a database connection by name, and more such actions on your behalf without compromising your account security.

Setup is the same on Claude Web, Desktop, and Cowork, and you only need to do it once. The connector is tied to your account, so it's available in all three.

Also integrate Prisma with

OpenAI Agents SDK Claude Agent SDK Claude Code Codex OpenClaw Hermes Atomic Agent Google ADK LangChain Vercel AI SDK Mastra AI LlamaIndex CrewAI Pydantic AI AutoGen

Connecting Prisma to Claude Web, Desktop, and Cowork

Two ways to add the Composio connector. Pick whichever you prefer.

1. Add with one click

Click the button. Claude opens with the Composio connector filled in. Click Add, then go to step 2.

Add to Claude

Add manually

In Claude Desktop, click Customize in the left sidebar, then select Connectors and click the + icon at the top.

Claude Desktop connectors screen with Add custom connector selected

Click Add custom connector and paste in the Composio MCP server URL:

bash

https://connect.composio.dev/mcp

Add custom connector dialog with Composio MCP server URL

2. Authorize in your browser

Click Connect. You'll be redirected to a browser window where you can authorize Composio to continue.

Composio authorization screen for Claude Web, Desktop, and Cowork

3. Connect your Prisma account

Back in Claude, ask it to connect to Prisma or give it any Prisma-related task.

For example, ask Claude to:

"Create a new Postgres database in your project"
"Run a SQL query to list all users"
"Delete a database connection by name"

It will prompt you to authenticate and authorize access.

That's it. Composio's tools are now available in Claude, and your Prisma account is ready to use.

What is the Prisma Claude Connector, and what's possible with it?

The Prisma MCP server is an implementation of the Model Context Protocol that connects your AI agent and assistants like Claude, Cursor, etc directly to your Prisma account. It provides structured and secure access to your database management, so your agent can perform actions like creating projects, managing databases, executing SQL queries, and handling API keys on your behalf.

Automated project and database provisioning: Instantly create new Prisma projects and managed PostgreSQL databases in your workspace, complete with connection strings and API keys for fast onboarding.
On-demand SQL execution and analysis: Have your agent run SQL commands or select queries for reporting, data inspection, or schema changes—without manual intervention.
API key and connection management: Programmatically generate, rotate, or revoke database API keys, ensuring secure and controlled access for all your applications.
Workspace and resource monitoring: Retrieve detailed information about your workspaces, projects, and databases, allowing your agent to validate deployments or monitor status in real time.
Safe resource cleanup and deletion: Direct your agent to delete databases, projects, or specific connections—helping you maintain a tidy, secure, and cost-effective data platform.

Troubleshooting

1. Why does Claude not use the Composio connector for Prisma?

The connector can show as connected, but Claude must use it in each Prisma conversation.

Click + at the lower left of the chat, or type /.
Hover Connectors.
Turn on Composio.
Ask Claude to connect to Prisma again.

2. Why does Claude show an MCP server error before Prisma connects?

Claude can show Couldn't reach the MCP server or Authorization with the MCP server failed when you add the connector for Prisma.

Check that the connector URL is https://connect.composio.dev/mcp.
Connectors run from Anthropic's cloud, so your device network is usually not the problem.
Add the connector again from Customize > Connectors, then ask Claude to connect Prisma.
If it fails again, send the error and the ofid_ reference id to support@composio.dev.

3. Why does the Prisma authorization link not work?

The Composio connector is one server. Your Prisma account connects separately when Claude asks for it.

If the browser does not open, or the link expires, ask Claude to retry the Prisma connection.
Composio creates a fresh Prisma authorization link.
Open that link in your browser and finish the Prisma sign-in.

4. Why do Prisma actions fail after they worked before?

The Prisma connection can expire or lose permission.

Ask Claude to inspect the Prisma connection.
If the connection is unhealthy, disconnect it when Claude prompts you.
Reconnect the Prisma account and retry the action.
If Claude shows a permission prompt, approve it before Claude changes data in Prisma.
If the action still fails with a permission error, check that the connected account has that permission in Prisma itself.

5. How do I switch to a different Prisma account?

Claude can manage the Prisma connection for you.

Ask Claude to disconnect or delete the current Prisma account.
Ask Claude to connect Prisma again.
Open the new Composio authorization link for Prisma.
Sign in with the other Prisma account in the browser.
After the account connects, ask Claude to retry the Prisma task.

6. Why is my Prisma connection missing in Claude Desktop or on a Team plan?

The connector belongs to your Claude account, so your Prisma connection works in Claude Web, Desktop, and Cowork.

In Claude Desktop, open Customize > Connectors.
Next to Composio, click ⋮ and click Clear cache.
If Prisma tools still do not appear, click ⋮, disconnect, remove the connector, and add it again.
On Team or Enterprise, an Owner or Primary Owner must enable the connector before you can connect Prisma.

TOOLS

Supported Tools

Every Prisma action and event your agent gets out of the box.

Create Database Connection

Create new API key connection for database access.

Create Project Database

Create new postgres database in an existing Prisma project.

Create Prisma Project

Create new Prisma project with managed postgres database.

Delete Database Connection

Permanently delete database connection and revoke API key access.

Delete Prisma Database

Permanently delete Prisma database and all stored data.

Delete Prisma Project

Permanently delete Prisma project and all associated resources.

Execute SQL Command

Execute SQL commands that modify database data or structure.

Execute SQL Query

Execute SQL SELECT queries against Prisma Postgres databases.

Get Prisma Database

Retrieve specific Prisma database by ID.

Get Database Usage Metrics

Retrieve usage metrics for a specific Prisma database.

Get Prisma Project

Retrieve specific Prisma project by ID.

Inspect Database Schema

Inspect database schema structure and table information.

List Prisma Accelerate Regions

Retrieve all available regions for Prisma Accelerate.

List Database Backups

Retrieve list of available backups for a specific database.

List Database Connections

Retrieve paginated list of connections for a specific database.

List Project Databases

Retrieve paginated list of databases for a specific Prisma project.

List Prisma Postgres Regions

Retrieve all available regions for Prisma Postgres.

List Prisma Projects

Retrieve paginated list of Prisma projects accessible to authenticated user.

List Workspace Integrations

Retrieve paginated list of integrations for a specific Prisma workspace.

List Prisma Workspaces

Retrieve paginated list of Prisma workspaces accessible to authenticated user.

Restore Database Backup

Restore database backup to new database instance.

Transfer Prisma Project

Transfer Prisma project ownership to another user's workspace.

FRAMEWORKS

How to build Prisma MCP Agent with another framework

OpenAI Agents SDK

Use Prisma MCP with OpenAI Agents SDK

Claude Agent SDK

Use Prisma MCP with Claude Agent SDK

Claude Code

Use Prisma MCP with Claude Code

Codex

Use Prisma MCP with Codex

OpenClaw

Use Prisma MCP with OpenClaw

Hermes

Use Prisma MCP with Hermes

Atomic Agent

Use Prisma MCP with Atomic Agent

Google ADK

Use Prisma MCP with Google ADK

LangChain

Use Prisma MCP with LangChain

Vercel AI SDK

Use Prisma MCP with Vercel AI SDK

Mastra AI

Use Prisma MCP with Mastra AI

LlamaIndex

Use Prisma MCP with LlamaIndex

CrewAI

Use Prisma MCP with CrewAI

Pydantic AI

Use Prisma MCP with Pydantic AI

AutoGen

Use Prisma MCP with AutoGen

MORE TOOLKITS

Explore Other Toolkits

Toolkit marketplace

Supabase

Oauth2Api Key

Supabase is an open-source backend platform offering scalable Postgres databases, authentication, storage, and real-time APIs. It lets developers build modern apps without managing infrastructure.

Codeinterpreter

No Auth

Codeinterpreter is a Python-based coding environment with built-in data analysis and visualization. It lets you instantly run scripts, plot results, and prototype solutions inside supported platforms.

GitHub

Oauth2

GitHub is a code hosting platform for version control and collaborative software development. It streamlines project management, code review, and team workflows in one place.

1password

Api Key

1Password is a password manager and digital vault for storing logins, secrets, notes, and secure documents. It helps individuals and teams protect credentials, share access safely, and reduce password risk.

FAQ

Frequently asked questions

With a standalone Prisma MCP server, the agents and LLMs can only access a fixed set of Prisma tools tied to that server. However, with the Composio Tool Router, agents can dynamically load tools from Prisma and many other apps based on the task at hand, all through a single MCP endpoint.

Yes, you can. Claude Cowork fully supports MCP integration. You get structured tool calling, message history handling, and model orchestration while Tool Router takes care of discovering and serving the right Prisma tools.

Yes, absolutely. You can configure which Prisma scopes and actions are allowed when connecting your account to Composio. You can also bring your own OAuth credentials or API configuration so you keep full control over what the agent can do.

All sensitive data such as tokens, keys, and configuration is fully encrypted at rest and in transit. Composio is SOC 2 Type 2 compliant and follows strict security practices so your Prisma data and credentials are handled as safely as possible.

Start with Prisma.It takes 30 seconds.

Managed auth, hosted MCP servers, and every Prisma tool your agent needs.Free to start.

Start building