How to integrate Prisma MCP with Codex

Connect Codex 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.

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

Codex is one of the most popular coding harnesses out there. And MCP makes the experience even better. With the Prisma MCP integration, Codex can create projects and databases, run SQL queries, inspect database schemas, manage connections, and restore backups, all without leaving the terminal or the app, whichever you prefer.

Also integrate Prisma with

Why use Composio?

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

  • CodeAct: A dedicated workbench that allows GPT to write its code to handle complex tool chaining. Reduces to-and-fro with LLMs for frequent tool calling.
  • Large tool responses: Handle them to minimise 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 GPTs aren't overwhelmed by tools you don't need.

How to install Prisma MCP in Codex

Run the setup command

Run this command in your terminal to add the Composio MCP server to Codex.

Terminal

It will initiate the authentication in a browser window, authorize Codex to access your Composio account.

Composio authentication page

(Optional) Authenticate with OAuth

To authenticate manually, run the login command to open a browser window and authorize Codex to access your Composio account.

bash
codex mcp login composio

Verify the connection

Run codex mcp list to confirm Composio appears as a registered MCP server.

bash
codex mcp list

Codex App

Codex App follows the same approach as VS Code.

  1. Click ⚙️ on the bottom left → MCP Servers → + Add servers → Streamable HTTP:
  2. Fill the header and Key fields with { "x-consumer-api-key" = "ck_*******" }.
  3. The Key is the Composio API key, that you can find on dashboard.composio.dev
  4. Click on Authenticate and authorize Codex to your Composio account and you're all set.
Codex App MCP setup
  1. Restart and verify if it's there in .codex/config.toml
bash
[mcp_servers.composio]
url = "https://connect.composio.dev/mcp"
http_headers = { "x-consumer-api-key" = "ck_*******" }

Try it

Ask Codex for a Prisma task. The first time, Composio asks you to connect your Prisma account.

For example, ask it to:

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

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 Codex using Composio's MCP server. Now you can interact with Prisma directly from your terminal, VS Code, or the Codex App using natural language commands.

Key benefits of this setup:

  • Seamless integration across CLI, VS Code, and standalone app
  • Natural language commands for Prisma operations
  • Managed authentication through Composio
  • Access to 20,000+ tools across 1700+ apps for cross-app workflows
  • CodeAct workbench for complex tool chaining

Next steps:

  • Try asking Codex to perform various Prisma operations
  • Explore cross-app workflows by connecting more toolkits
  • Build automation scripts that leverage Codex's AI 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.

FAQ

Frequently asked questions

Start with Prisma.It takes 30 seconds.

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

Start building