Prisma MCP connector

1. Install the SDK

   Node.js

   npm install @scalekit-sdk/node

   Python

   pip install scalekit

   Full SDK reference: Node.js | Python

2. Set your credentials

   Add your Scalekit credentials to your .env file. Find values in app.scalekit.com > Developers > API Credentials.

   .env

   SCALEKIT_ENVIRONMENT_URL=<your-environment-url>
   SCALEKIT_CLIENT_ID=<your-client-id>
   SCALEKIT_CLIENT_SECRET=<your-client-secret>

3. Authorize and make your first call

   Node.js

   quickstart.ts

   import { ScalekitClient } from '@scalekit-sdk/node'
   import 'dotenv/config'
   
   const scalekit = new ScalekitClient(
     process.env.SCALEKIT_ENV_URL,
     process.env.SCALEKIT_CLIENT_ID,
     process.env.SCALEKIT_CLIENT_SECRET,
   )
   const actions = scalekit.actions
   
   const connector = 'prismamcp'
   const identifier = 'user_123'
   
   // Generate an authorization link for the user
   const { link } = await actions.getAuthorizationLink({ connectionName: connector, identifier })
   console.log('Authorize Prisma MCP:', link)
   process.stdout.write('Press Enter after authorizing...')
   await new Promise(r => process.stdin.once('data', r))
   
   // Make your first call
   const result = await actions.executeTool({
     connector,
     identifier,
     toolName: 'prismamcp_fetch_workspace_details',
     toolInput: {},
   })
   console.log(result)

   Python

   quickstart.py

   import os
   from scalekit.client import ScalekitClient
   from dotenv import load_dotenv
   load_dotenv()
   
   scalekit_client = ScalekitClient(
       env_url=os.getenv("SCALEKIT_ENV_URL"),
       client_id=os.getenv("SCALEKIT_CLIENT_ID"),
       client_secret=os.getenv("SCALEKIT_CLIENT_SECRET"),
   )
   actions = scalekit_client.actions
   
   connection_name = "prismamcp"
   identifier = "user_123"
   
   # Generate an authorization link for the user
   link_response = actions.get_authorization_link(
       connection_name=connection_name,
       identifier=identifier,
   )
   print("Authorize Prisma MCP:", link_response.link)
   input("Press Enter after authorizing...")
   
   # Make your first call
   result = actions.execute_tool(
       tool_input={},
       tool_name="prismamcp_fetch_workspace_details",
       connection_name=connection_name,
       identifier=identifier,
   )
   print(result)

What you can do

Connect this agent connector to let your agent:

• List prisma postgres databases, prisma postgres connection strings, prisma postgres backups — List all Prisma Postgres databases in the workspace
• Schema introspect database — Introspect and return the schema of a Prisma Postgres database as JSON
• Fetch workspace details — Retrieve details of the current Prisma Postgres workspace, including plan limits and usage
• Execute sql query, prisma postgres schema update — Execute a SQL query on a Prisma Postgres database and return the results as JSON
• Delete prisma postgres database, prisma postgres connection string — Permanently delete a Prisma Postgres database by its ID
• Create prisma postgres recovery, prisma postgres database, prisma postgres connection string — Restore a Prisma Postgres database from a backup into a new database

Tool list

Use the exact tool names from the Tool list below when you call execute_tool. If you’re not sure which name to use, list the tools available for the current user first.

prismamcp_create_prisma_postgres_backup#Create an automated backup for a Prisma Postgres database. Note: on-demand backup creation is not currently supported; backups are created automatically by the system.2 params▾

Create an automated backup for a Prisma Postgres database. Note: on-demand backup creation is not currently supported; backups are created automatically by the system.

NameTypeRequiredDescription

databaseIdstringrequiredThe unique identifier of the Prisma Postgres database. Get it from List Databases.

projectIdstringrequiredThe unique identifier of the Prisma project. Get it from List Databases.

prismamcp_create_prisma_postgres_connection_string#Create a new connection string for a Prisma Postgres database. Returns both Prisma and direct connection strings when available.2 params▾

Create a new connection string for a Prisma Postgres database. Returns both Prisma and direct connection strings when available.

NameTypeRequiredDescription

databaseIdstringrequiredThe unique identifier of the Prisma Postgres database. Get it from List Databases.

namestringrequiredA unique display name for the resource.

prismamcp_create_prisma_postgres_database#Create a new managed Prisma Postgres database in the specified region.2 params▾

Create a new managed Prisma Postgres database in the specified region.

NameTypeRequiredDescription

namestringrequiredA unique display name for the resource.

regionstringrequiredThe AWS region to deploy the database in. Accepted values: us-east-1, us-west-1, eu-west-3, eu-central-1, ap-northeast-1, ap-southeast-1.

prismamcp_create_prisma_postgres_recovery#Restore a Prisma Postgres database from a backup into a new database.3 params▾

Restore a Prisma Postgres database from a backup into a new database.

NameTypeRequiredDescription

backupIdstringrequiredThe unique identifier of the backup to restore. Get it from List Backups.

databaseIdstringrequiredThe unique identifier of the Prisma Postgres database. Get it from List Databases.

targetDatabaseNamestringrequiredA unique name for the recovered database.

prismamcp_delete_prisma_postgres_connection_string#Permanently delete a connection string by its ID. This action cannot be undone.1 param▾

Permanently delete a connection string by its ID. This action cannot be undone.

NameTypeRequiredDescription

idstringrequiredThe unique identifier of the connection string. Get it from List Connection Strings.

prismamcp_delete_prisma_postgres_database#Permanently delete a Prisma Postgres database by its ID. This action cannot be undone.1 param▾

Permanently delete a Prisma Postgres database by its ID. This action cannot be undone.

NameTypeRequiredDescription

databaseIdstringrequiredThe unique identifier of the Prisma Postgres database. Get it from List Databases.

prismamcp_execute_prisma_postgres_schema_update#Execute a DDL schema update on a Prisma Postgres database. Use for schema changes only; use Execute SQL Query for data reads and writes.3 params▾

Execute a DDL schema update on a Prisma Postgres database. Use for schema changes only; use Execute SQL Query for data reads and writes.

NameTypeRequiredDescription

databaseIdstringrequiredThe unique identifier of the Prisma Postgres database. Get it from List Databases.

projectIdstringrequiredThe unique identifier of the Prisma project. Get it from List Databases.

querystringrequiredThe SQL query to execute against the database.

prismamcp_execute_sql_query#Execute a SQL query on a Prisma Postgres database and return the results as JSON. Does not have permission to run schema updates.3 params▾

Execute a SQL query on a Prisma Postgres database and return the results as JSON. Does not have permission to run schema updates.

NameTypeRequiredDescription

databaseIdstringrequiredThe unique identifier of the Prisma Postgres database. Get it from List Databases.

projectIdstringrequiredThe unique identifier of the Prisma project. Get it from List Databases.

querystringrequiredThe SQL query to execute against the database.

prismamcp_fetch_workspace_details#Retrieve details of the current Prisma Postgres workspace, including plan limits and usage.0 params▾

Retrieve details of the current Prisma Postgres workspace, including plan limits and usage.

prismamcp_introspect_database_schema#Introspect and return the schema of a Prisma Postgres database as JSON.2 params▾

Introspect and return the schema of a Prisma Postgres database as JSON.

NameTypeRequiredDescription

databaseIdstringrequiredThe unique identifier of the Prisma Postgres database. Get it from List Databases.

projectIdstringrequiredThe unique identifier of the Prisma project. Get it from List Databases.

prismamcp_list_prisma_postgres_backups#List all available automated backups for a Prisma Postgres database.1 param▾

List all available automated backups for a Prisma Postgres database.

NameTypeRequiredDescription

databaseIdstringrequiredThe unique identifier of the Prisma Postgres database. Get it from List Databases.

prismamcp_list_prisma_postgres_connection_strings#List all connection strings for a Prisma Postgres database.1 param▾

List all connection strings for a Prisma Postgres database.

NameTypeRequiredDescription

databaseIdstringrequiredThe unique identifier of the Prisma Postgres database. Get it from List Databases.

prismamcp_list_prisma_postgres_databases#List all Prisma Postgres databases in the workspace. Use the returned id as databaseId in other tools.0 params▾

List all Prisma Postgres databases in the workspace. Use the returned id as databaseId in other tools.