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.

Name Type Required Description

databaseId string required The unique identifier of the Prisma Postgres database. Get it from List Databases.

projectId string required The 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.

Name Type Required Description

databaseId string required The unique identifier of the Prisma Postgres database. Get it from List Databases.

name string required A 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.

Name Type Required Description

name string required A unique display name for the resource.

region string required The 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.

Name Type Required Description

backupId string required The unique identifier of the backup to restore. Get it from List Backups.

databaseId string required The unique identifier of the Prisma Postgres database. Get it from List Databases.

targetDatabaseName string required A 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.

Name Type Required Description

id string required The 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.

Name Type Required Description

databaseId string required The 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.

Name Type Required Description

databaseId string required The unique identifier of the Prisma Postgres database. Get it from List Databases.

projectId string required The unique identifier of the Prisma project. Get it from List Databases.

query string required The 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.

Name Type Required Description

databaseId string required The unique identifier of the Prisma Postgres database. Get it from List Databases.

projectId string required The unique identifier of the Prisma project. Get it from List Databases.

query string required The 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.

Name Type Required Description

databaseId string required The unique identifier of the Prisma Postgres database. Get it from List Databases.

projectId string required The 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.

Name Type Required Description

databaseId string required The 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.

Name Type Required Description

databaseId string required The 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.