How to integrate Prisma MCP with Atomic Agent

Connect Atomic Agent 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

Atomic Agent is an open-source AI agent that runs on your machine and supports local models through llama.cpp. Connect it to 1,700+ apps through Composio, including Prisma.

This guide uses Atomic Agent's built-in Composio integration. You need Atomic Agent v0.5.6 or later, your own Composio API key, and a Prisma account. See the Atomic Agent documentation for installation instructions.

For exact tool slugs and parameter tables, see the tool catalog in the Composio docs.

Also integrate Prisma with

How Atomic Agent connects to Prisma

Atomic Agent connects to Composio's Tool Router over Streamable HTTP MCP. It discovers the tools needed for your request, and Composio handles account authentication.

Execution and account-connection tools follow Atomic Agent's configured approval policy. Review any approval prompt before allowing an action on your connected account.

Connect Prisma to Atomic Agent

  1. Sign up or sign in to the Composio dashboard. Copy your API key.
  2. In Atomic Agent, open the Integrations tab and select Composio. Select API key, press e, paste the key, and press Enter. The tools become available immediately, without a restart.
  3. Ask Atomic Agent to do something in Prisma. It searches Composio for the right tool.
  4. On first use, open the sign-in link returned in the chat. Connect your Prisma account, then return to Atomic Agent to continue.

Headless setup

Add the following line to ~/.atomic-agent/.env, replacing YOUR_COMPOSIO_API_KEY with your key. Start Atomic Agent after saving the file.

bash
COMPOSIO_API_KEY=YOUR_COMPOSIO_API_KEY

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.

Use Prisma from Atomic Agent

With your account connected, ask Atomic Agent to work with Prisma in natural language. You can connect more apps through the same Composio integration as you need them.

Visit the Atomic Agent website or inspect the Atomic Agent source code.

Troubleshooting

Why is my API key rejected?

Copy the key directly from the Composio dashboard. Atomic Agent requires ASCII characters because it sends the key in an HTTP header. Remove any extra characters introduced when copying.

Why are Composio tools unavailable after saving a key?

Check that you use Atomic Agent v0.5.6 or later and that Composio is enabled in your configuration. A "composio": { "enabled": false } setting disables the integration while keeping the saved key on disk.

Does Composio have a free plan?

The Hobby plan includes 100,000 tool calls per month. Composio-managed OAuth apps have a lower included allowance. See Composio pricing for the current limits that apply to your connection.

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