Use
COMPOSIOFOR YOU
Give Claude, Codex, or any harness secure access to 1700+ tools
CLI
One command to add tools and auth to your coding agent
Build
DEVELOPER PLATFORM
SDKs, tools, and auth for agents and backend apps
MCP GATEWAY
One managed MCP endpoint for all your tools and agents
ENTERPRISE
SSO, governance, and audit controls for deploying agents org-wide
Features
TRIGGERS
Start background agents from events across your connected apps
FIREWALLNEW
Blocks instructions hidden in tool results before your agent reads them
INSTANTNEW
Audio, video, search, browser and data tools, with no keys to manage
OPTIMIZATION
Lower cost per completed task with optimised tools and skills
FOR AGENTS
CLAUDE CODEX OPENCLAW CURSOR HERMES
BUILT FOR
OFFICE WORK SALES MARKETING PRODUCT & DESIGN CUSTOMER SUPPORT ENGINEERING HR & RECRUITING FINANCE & OPS E-COMMERCE CONTENT & MEDIA IT & SECURITY
ALL USE CASES
DOCS

How to integrate Prisma MCP with Mastra AI

Connect Mastra AI 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.

51 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

This guide walks you through connecting Prisma to Mastra AI using the Composio tool router. By the end, you'll have a working Prisma agent that can create projects and databases, run SQL queries, inspect database schemas, manage connections, and restore backups through natural language commands.

This guide will help you understand how to give your Mastra AI agent real control over a Prisma account through Composio's Prisma MCP server.

Before we dive in, let's take a quick look at the key ideas and tools involved.

Also integrate Prisma with

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

TL;DR

Here's what you'll learn:

Set up your environment so Mastra, OpenAI, and Composio work together
Create a Tool Router session in Composio that exposes Prisma tools
Connect Mastra's MCP client to the Composio generated MCP URL
Fetch Prisma tool definitions and attach them as a toolset
Build a Mastra agent that can reason, call tools, and return structured results
Run an interactive CLI where you can chat with your Prisma agent

What is Mastra AI?

Mastra AI is a TypeScript framework for building AI agents with tool support. It provides a clean API for creating agents that can use external services through MCP.

Key features include:

MCP Client: Built-in support for Model Context Protocol servers
Toolsets: Organize tools into logical groups
Step Callbacks: Monitor and debug agent execution
OpenAI Integration: Works with OpenAI models via @ai-sdk/openai

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.

What is the Composio tool router, and how does it fit here?

What is Composio SDK?

Composio's Composio SDK helps agents find the right tools for a task at runtime. You can plug in multiple toolkits (like Gmail, HubSpot, and GitHub), and the agent will identify the relevant app and action to complete multi-step workflows. This can reduce token usage and improve the reliability of tool calls. Read more here: Getting started with Composio SDK

The tool router generates a secure MCP URL that your agents can access to perform actions.

How the Composio SDK works

The Composio SDK follows a three-phase workflow:

Discovery: Searches for tools matching your task and returns relevant toolkits with their details.
Authentication: Checks for active connections. If missing, creates an auth config and returns a connection URL via Auth Link.
Execution: Executes the action using the authenticated connection.

Step-by-step Guide

Step by step09 STEPS

Prerequisites

Before starting, make sure you have:

Node.js 18 or higher
A Composio account with an active API key
An OpenAI API key
Basic familiarity with TypeScript

Getting API Keys for OpenAI and Composio

OpenAI API Key

Go to the OpenAI dashboard and create an API key.
You need credits or a connected billing setup to use the models.
Store the key somewhere safe.

Composio API Key

Log in to the Composio dashboard.
Go to Settings and copy your API key.
This key lets your Mastra agent talk to Composio and reach Prisma through MCP.

Install dependencies

bash

npm install @composio/core @mastra/core @mastra/mcp @ai-sdk/openai dotenv

Install the required packages.

What's happening:

@composio/core is the Composio SDK for creating MCP sessions
@mastra/core provides the Agent class
@mastra/mcp is Mastra's MCP client
@ai-sdk/openai is the model wrapper for OpenAI
dotenv loads environment variables from .env

Set up environment variables

bash

COMPOSIO_API_KEY=your_composio_api_key_here
COMPOSIO_USER_ID=your_user_id_here
OPENAI_API_KEY=your_openai_api_key_here

Create a .env file in your project root.

What's happening:

COMPOSIO_API_KEY authenticates your requests to Composio
COMPOSIO_USER_ID tells Composio which user this session belongs to
OPENAI_API_KEY lets the Mastra agent call OpenAI models

Import libraries and validate environment

typescript

import "dotenv/config";
import { openai } from "@ai-sdk/openai";
import { Agent } from "@mastra/core/agent";
import { MCPClient } from "@mastra/mcp";
import { Composio } from "@composio/core";
import * as readline from "readline";

import type { AiMessageType } from "@mastra/core/agent";

const openaiAPIKey = process.env.OPENAI_API_KEY;
const composioAPIKey = process.env.COMPOSIO_API_KEY;
const composioUserID = process.env.COMPOSIO_USER_ID;

if (!openaiAPIKey) throw new Error("OPENAI_API_KEY is not set");
if (!composioAPIKey) throw new Error("COMPOSIO_API_KEY is not set");
if (!composioUserID) throw new Error("COMPOSIO_USER_ID is not set");

const composio = new Composio({
  apiKey: composioAPIKey as string,
});

What's happening:

dotenv/config auto loads your .env so process.env.* is available
openai gives you a Mastra compatible model wrapper
Agent is the Mastra agent that will call tools and produce answers
MCPClient connects Mastra to your Composio MCP server
Composio is used to create a Tool Router session

Create a Tool Router session for Prisma

typescript

async function main() {
  const session = await composio.create(
    composioUserID as string,
    {
      toolkits: ["prisma"],
    },
  );

  const composioMCPUrl = session.mcp.url;
  console.log("Prisma MCP URL:", composioMCPUrl);

What's happening:

create spins up a short-lived MCP HTTP endpoint for this user
The toolkits array contains "prisma" for Prisma access
session.mcp.url is the MCP URL that Mastra's MCPClient will connect to

Configure Mastra MCP client and fetch tools

typescript

const mcpClient = new MCPClient({
    id: composioUserID as string,
    servers: {
      nasdaq: {
        url: new URL(composioMCPUrl),
        requestInit: {
          headers: session.mcp.headers,
        },
      },
    },
    timeout: 30_000,
  });

console.log("Fetching MCP tools from Composio...");
const composioTools = await mcpClient.getTools();
console.log("Number of tools:", Object.keys(composioTools).length);

What's happening:

MCPClient takes an id for this client and a list of MCP servers
The headers property includes the x-api-key for authentication
getTools fetches the tool definitions exposed by the Prisma toolkit

Create the Mastra agent

typescript

const agent = new Agent({
    name: "prisma-mastra-agent",
    instructions: "You are an AI agent with Prisma tools via Composio.",
    model: "openai/gpt-5",
  });

What's happening:

Agent is the core Mastra agent
name is just an identifier for logging and debugging
instructions guide the agent to use tools instead of only answering in natural language
model uses openai("gpt-5") to configure the underlying LLM

Set up interactive chat interface

typescript

let messages: AiMessageType[] = [];

console.log("Chat started! Type 'exit' or 'quit' to end.\n");

const rl = readline.createInterface({
  input: process.stdin,
  output: process.stdout,
  prompt: "> ",
});

rl.prompt();

rl.on("line", async (userInput: string) => {
  const trimmedInput = userInput.trim();

  if (["exit", "quit", "bye"].includes(trimmedInput.toLowerCase())) {
    console.log("\nGoodbye!");
    rl.close();
    process.exit(0);
  }

  if (!trimmedInput) {
    rl.prompt();
    return;
  }

  messages.push({
    id: crypto.randomUUID(),
    role: "user",
    content: trimmedInput,
  });

  console.log("\nAgent is thinking...\n");

  try {
    const response = await agent.generate(messages, {
      toolsets: {
        prisma: composioTools,
      },
      maxSteps: 8,
    });

    const { text } = response;

    if (text && text.trim().length > 0) {
      console.log(`Agent: ${text}\n`);
        messages.push({
          id: crypto.randomUUID(),
          role: "assistant",
          content: text,
        });
      }
    } catch (error) {
      console.error("\nError:", error);
    }

    rl.prompt();
  });

  rl.on("close", async () => {
    console.log("\nSession ended.");
    await mcpClient.disconnect();
    process.exit(0);
  });
}

main().catch((err) => {
  console.error("Fatal error:", err);
  process.exit(1);
});

What's happening:

messages keeps the full conversation history in Mastra's expected format
agent.generate runs the agent with conversation history and Prisma toolsets
maxSteps limits how many tool calls the agent can take in a single run
onStepFinish is a hook that prints intermediate steps for debugging

Complete Code

Here's the complete code to get you started with Prisma and Mastra AI:

typescript

import "dotenv/config";
import { openai } from "@ai-sdk/openai";
import { Agent } from "@mastra/core/agent";
import { MCPClient } from "@mastra/mcp";
import { Composio } from "@composio/core";
import * as readline from "readline";

import type { AiMessageType } from "@mastra/core/agent";

const openaiAPIKey = process.env.OPENAI_API_KEY;
const composioAPIKey = process.env.COMPOSIO_API_KEY;
const composioUserID = process.env.COMPOSIO_USER_ID;

if (!openaiAPIKey) throw new Error("OPENAI_API_KEY is not set");
if (!composioAPIKey) throw new Error("COMPOSIO_API_KEY is not set");
if (!composioUserID) throw new Error("COMPOSIO_USER_ID is not set");

const composio = new Composio({ apiKey: composioAPIKey as string });

async function main() {
  const session = await composio.create(composioUserID as string, {
    toolkits: ["prisma"],
  });

  const composioMCPUrl = session.mcp.url;

  const mcpClient = new MCPClient({
    id: composioUserID as string,
    servers: {
      prisma: {
        url: new URL(composioMCPUrl),
        requestInit: {
          headers: session.mcp.headers,
        },
      },
    },
    timeout: 30_000,
  });

  const composioTools = await mcpClient.getTools();

  const agent = new Agent({
    name: "prisma-mastra-agent",
    instructions: "You are an AI agent with Prisma tools via Composio.",
    model: "openai/gpt-5",
  });

  let messages: AiMessageType[] = [];

  const rl = readline.createInterface({
    input: process.stdin,
    output: process.stdout,
    prompt: "> ",
  });

  rl.prompt();

  rl.on("line", async (input: string) => {
    const trimmed = input.trim();
    if (["exit", "quit"].includes(trimmed.toLowerCase())) {
      rl.close();
      return;
    }

    messages.push({ id: crypto.randomUUID(), role: "user", content: trimmed });

    const { text } = await agent.generate(messages, {
      toolsets: { prisma: composioTools },
      maxSteps: 8,
    });

    if (text) {
      console.log(`Agent: ${text}\n`);
      messages.push({ id: crypto.randomUUID(), role: "assistant", content: text });
    }

    rl.prompt();
  });

  rl.on("close", async () => {
    await mcpClient.disconnect();
    process.exit(0);
  });
}

main();

Conclusion

You've built a Mastra AI agent that can interact with Prisma through Composio's Tool Router. You can extend this further by:

Adding other toolkits like Gmail, Slack, or GitHub
Building a web-based chat interface around this agent
Using multiple MCP endpoints to enable cross-app workflows

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

Use Prisma MCP with Claude Code

Claude Cowork

Use Prisma MCP with Claude Cowork

OpenAI Agents SDK

Use Prisma MCP with OpenAI Agents SDK

Claude Agent SDK

Use Prisma MCP with Claude Agent SDK

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

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. Mastra AI 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

How to integrate Prisma MCP with Mastra AI

Connect Prisma without auth hassles

Introduction

Also integrate Prisma with

TL;DR

What is Mastra AI?

What is the Prisma MCP server, and what's possible with it?

What is the Composio tool router, and how does it fit here?

What is Composio SDK?

How the Composio SDK works

Step-by-step Guide

Prerequisites

Getting API Keys for OpenAI and Composio

Install dependencies

Set up environment variables

Import libraries and validate environment

Create a Tool Router session for Prisma

Configure Mastra MCP client and fetch tools

Create the Mastra agent

Set up interactive chat interface

Complete Code

Conclusion

Supported Tools

How to build Prisma MCP Agent with another framework

Claude Code

Claude Cowork

OpenAI Agents SDK

Claude Agent SDK

Codex

OpenClaw

Hermes

Atomic Agent

Google ADK

LangChain

Vercel AI SDK

LlamaIndex

CrewAI

Pydantic AI

AutoGen

Explore Other Toolkits

Supabase

Codeinterpreter

GitHub

1password

Frequently asked questions

What are the differences in Tool Router MCP and Prisma MCP?+

Can I use Tool Router MCP with Mastra AI?+

Can I manage the permissions and scopes for Prisma while using Tool Router?+

How safe is my data with Composio Tool Router?+

Start with Prisma.It takes 30 seconds.