SIGN UPLOG IN
X (Twitter)LinkedInGitHubDiscordYouTube

How to integrate Prisma MCP with OpenClaw

Connect OpenClaw 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 freeGet a demo
Prisma logoPrisma
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.

51 Tools

Introduction

OpenClaw is the fastest growing agent harness out there, which can work 24/7 to automate almost any kind of tasks. However, its capabilities are limited to the tools it has access to. Composio allows your OpenClaw to access Prisma with authentication management handled for you. You can execute actions on Prisma via your favorite OpenClaw interface (Telegram, WhatsApp, TUI, etc), whichever you prefer.

Also integrate Prisma with

Claude CodeClaude CoworkOpenAI Agents SDKClaude Agent SDKCodexHermesAtomic AgentGoogle ADKLangChainVercel AI SDKMastra AILlamaIndexCrewAIPydantic AIAutoGen

Why use Composio?

Apart from a managed and hosted MCP server, you will get:

  • Programmatic tool calling allows LLMs to write its code in a remote workbench to handle complex tool chaining. Reduces to-and-fro with LLMs for frequent tool calling.
  • Handling Large tool responses out of LLM context to minimize context rot.
  • Dynamic just-in-time access to 20,000 tools across 1700+ other Apps for cross-app workflows. It loads the tools you need, so LLMs aren't overwhelmed by tools you don't need.

How to install Prisma with OpenClaw

Using Composio API Key and Setup Prompt

Copy the setup prompt from the OpenClaw dashboard
  • Run it in your OpenClaw chat interface.
  • Authenticate Prisma from the dashboard
  • Go back to your OpenClaw interface and start asking questions.

Using OpenClaw/Composio Plugin

1. Install OpenClaw Composio plugin

bash
openclaw plugins install @composio/openclaw-plugin

2. Copy the API Key from dashboard.composio.dev

3. Setup OpenClaw Config

bash
openclaw config set plugins.entries.composio.config.consumerKey "ck_your_key_here"

4. Restart OpenClaw

bash
openclaw gateway restart

5. Go to your chat interface and start asking questions.

6. When prompted, authenticate the app and you're all set.

How It Works

The plugin connects to Composio's MCP server at https://connect.composio.dev/mcp and registers all available tools directly into the OpenClaw agent. Tools are called by name — no extra search or execute steps needed.

If a tool returns an auth error, the agent will prompt you to connect that toolkit at dashboard.composio.dev.

Configuration

bash
{
  "plugins": {
    "entries": {
      "composio": {
        "enabled": true,
        "config": {
          "consumerKey": "ck_your_key_here"
        }
      }
    }
  }
}
OptionDescriptionDefault
enabledEnable or disable the plugintrue
consumerKeyYour Composio consumer key (ck_...)—
mcpUrlMCP server URL (advanced)https://connect.composio.dev/mcp

What is the Prisma MCP server, 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.

Conclusion

You've successfully integrated Prisma with OpenClaw using Composio plugin. Now interact with Prisma directly from your terminal, Web UI, or any messenger app using natural language commands.

Key benefits of this setup:

  • Seamless integration across TUI, Web UIs, and Messenger apps like Telegram, WhatsApp, Slack, etc.
  • Natural language commands for Prisma operations
  • Managed authentication through Composio
  • Access to 20,000+ tools across 1700+ apps for cross-app workflows
  • Programmatic tool calling for complex tool chaining

Next steps:

  • Try asking OpenClaw to perform various Prisma operations
  • Explore cross-app workflows by connecting more toolkits like Calendar, Slack, Notion, etc.
  • Build complex automation scripts that leverage OpenClaw's 24/7 running capabilities
TOOLS

Supported Tools

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

Create Bucket

Create an object-store bucket in an existing Prisma project.

Create Bucket Key

Create an access key for an existing Prisma object-store bucket.

Create Database Connection

Create new API key connection for database access.

Create Project Database

Create new postgres database in an existing Prisma project.

Create Managed Connection

Create a managed connection for an existing Prisma database.

Create Managed Database

Create a managed database in a Prisma project, optionally cloning or restoring it.

Create Prisma Project

Create new Prisma project with managed postgres database.

Create Service Token

Create a service token in a Prisma workspace, optionally limited to one project.

Delete Bucket

Permanently delete a bucket, all objects stored in it, and all its access keys.

Delete Bucket Key

Revoke and delete a bucket access key by its bucket and key IDs.

Delete Database Connection

Permanently delete database connection and revoke API key access.

Delete Prisma Database

Permanently delete Prisma database and all stored data.

Delete Integration

Revoke the integration tokens by integration ID.

Delete Prisma Project

Permanently delete Prisma project and all associated resources.

Delete Service Token

Revoke a workspace service token by deleting it.

Execute SQL Command

Execute SQL commands that modify database data or structure.

Execute SQL Query

Execute SQL queries through a direct SSL PostgreSQL connection and return rows, row count, and execution time.

Get Bucket

Get an object-store bucket by ID, including its project and branch metadata.

Get Connection

Get a connection by ID, including its endpoints and database metadata.

Get Current Principal

Get the user, workspace, and credential represented by the current token.

Get Prisma Database

Retrieve specific Prisma database by ID.

Get Database Usage Metrics

Retrieve usage metrics for a specific Prisma database.

Get Integration

Get an integration by ID, including its scopes, client, and creating user.

Get Prisma Project

Retrieve specific Prisma project by ID.

Get Workspace

Get a workspace by ID, including its name, resource URL, and creation time.

Get Workspace Subscription

Get a workspace's subscription plan, usage-blocked status, and upgrade URL.

Inspect Database Schema

Inspect tables and columns in the public database schema, optionally for a named table.

List Prisma Accelerate Regions

Retrieve all available regions for Prisma Accelerate.

List All Connections

List all accessible connections, optionally filtered by database.

List All Databases

List databases across all projects accessible to the authenticated token.

List Database Backups

Retrieve list of available backups for a specific database.

List Bucket Keys

List access-key metadata for a bucket, without returning secret access keys.

List Buckets

List accessible object-store buckets with optional project and branch filters.

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 Integrations

List integrations for a workspace, including clients, creators, and scopes.

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 Regions

List all available regions across products, optionally filtered by product.

List Service Tokens

List workspace service-token metadata, newest first, without secret values.

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.

Poll Agent Approval

Poll an approval for the authenticated agent to await the sponsor's decision.

Restore Database Backup

Restore database backup to new database instance.

Restore Database

Destructively overwrite all target database data with a specified backup.

Revoke Integration Tokens

Revoke integration tokens for the specified client in the specified workspace.

Rotate Connection Credentials

Generate new credentials for an existing Prisma connection.

Transfer Prisma Project

Transfer Prisma project ownership to another user's workspace.

Update Bucket

Update a bucket's display label, logical identity, or branch.

Update Database

Update a database's display name, logical identity, or branch.

Update Project

Update an existing Prisma project's display name or settings.

FRAMEWORKS

How to build Prisma MCP Agent with another framework

Claude Code logo

Claude Code

Use Prisma MCP with Claude Code

Claude Cowork logo

Claude Cowork

Use Prisma MCP with Claude Cowork

OpenAI Agents SDK logo

OpenAI Agents SDK

Use Prisma MCP with OpenAI Agents SDK

Claude Agent SDK logo

Claude Agent SDK

Use Prisma MCP with Claude Agent SDK

Codex logo

Codex

Use Prisma MCP with Codex

Hermes logo

Hermes

Use Prisma MCP with Hermes

Atomic Agent logo

Atomic Agent

Use Prisma MCP with Atomic Agent

Google ADK logo

Google ADK

Use Prisma MCP with Google ADK

LangChain logo

LangChain

Use Prisma MCP with LangChain

Vercel AI SDK logo

Vercel AI SDK

Use Prisma MCP with Vercel AI SDK

Mastra AI logo

Mastra AI

Use Prisma MCP with Mastra AI

LlamaIndex logo

LlamaIndex

Use Prisma MCP with LlamaIndex

CrewAI logo

CrewAI

Use Prisma MCP with CrewAI

Pydantic AI logo

Pydantic AI

Use Prisma MCP with Pydantic AI

AutoGen logo

AutoGen

Use Prisma MCP with AutoGen

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. OpenClaw 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