prisma

Prisma Postgres Management

Server path: /prisma | Type: Application | PCID required: Yes

Tools

Tool	Description
prisma_delete_connections_by_id	Delete connection
prisma_delete_databases_by_database_id	Delete database
prisma_delete_integrations_by_id	Delete integration
prisma_delete_projects_by_id	Delete project
prisma_delete_workspaces_by_workspace_id_integrations_by_client_id	Revoke integration tokens
prisma_get_connections	List connections
prisma_get_connections_by_id	Get connection
prisma_get_databases	List databases
prisma_get_databases_by_database_id	Get database
prisma_get_databases_by_database_id_backups	Get list of backups
prisma_get_databases_by_database_id_connections	Get list of database connections
prisma_get_databases_by_database_id_usage	Get database usage metrics
prisma_get_integrations	Get list of integrations
prisma_get_integrations_by_id	Get integration by ID
prisma_get_projects	Get list of projects
prisma_get_projects_by_id	Get project
prisma_get_projects_by_project_id_databases	Get list of databases
prisma_get_regions	Get all regions
prisma_get_regions_accelerate	Get Prisma Accelerate regions
prisma_get_regions_postgres	Get Prisma Postgres regions
prisma_get_workspaces	Get list of workspaces
prisma_get_workspaces_by_id	Get workspace
prisma_get_workspaces_by_workspace_id_integrations	Get list of integrations
prisma_patch_databases_by_database_id	Update database
prisma_patch_projects_by_id	Update project
prisma_post_connections	Create connection
prisma_post_connections_by_id_rotate	Rotate connection credentials
prisma_post_databases	Create database
prisma_post_databases_by_database_id_connections	Create database connection string
prisma_post_databases_by_target_database_id_restore	Restore database (destructive)
prisma_post_projects	Create project with a postgres database
prisma_post_projects_by_id_transfer	Transfer project
prisma_post_projects_by_project_id_databases	Create database

---

prisma_delete_connections_by_id

Delete connection

Parameters:

Parameter	Type	Required	Default	Description
id	string	Yes	—	The id value

Show inputSchema

{
  "type": "object",
  "properties": {
    "PCID": {
      "type": "string",
      "description": "Pink Connect ID for the authenticated connection"
    },
    "id": {
      "type": "string",
      "description": "The id value"
    }
  },
  "required": [
    "PCID",
    "id"
  ]
}

---

prisma_delete_databases_by_database_id

Delete database

Parameters:

Parameter	Type	Required	Default	Description
databaseId	string	Yes	—	Database Id

Show inputSchema

{
  "type": "object",
  "properties": {
    "PCID": {
      "type": "string",
      "description": "Pink Connect ID for the authenticated connection"
    },
    "databaseId": {
      "type": "string",
      "description": "Database Id"
    }
  },
  "required": [
    "PCID",
    "databaseId"
  ]
}

---

prisma_delete_integrations_by_id

Delete integration

Parameters:

Parameter	Type	Required	Default	Description
id	string	Yes	—	The id value

Show inputSchema

{
  "type": "object",
  "properties": {
    "PCID": {
      "type": "string",
      "description": "Pink Connect ID for the authenticated connection"
    },
    "id": {
      "type": "string",
      "description": "The id value"
    }
  },
  "required": [
    "PCID",
    "id"
  ]
}

---

prisma_delete_projects_by_id

Delete project

Parameters:

Parameter	Type	Required	Default	Description
id	string	Yes	—	The id value

Show inputSchema

{
  "type": "object",
  "properties": {
    "PCID": {
      "type": "string",
      "description": "Pink Connect ID for the authenticated connection"
    },
    "id": {
      "type": "string",
      "description": "The id value"
    }
  },
  "required": [
    "PCID",
    "id"
  ]
}

---

prisma_delete_workspaces_by_workspace_id_integrations_by_client_id

Revoke integration tokens

Parameters:

Parameter	Type	Required	Default	Description
clientId	string	Yes	—	Client Id
workspaceId	string	Yes	—	Workspace Id

Show inputSchema

{
  "type": "object",
  "properties": {
    "PCID": {
      "type": "string",
      "description": "Pink Connect ID for the authenticated connection"
    },
    "clientId": {
      "type": "string",
      "description": "Client Id"
    },
    "workspaceId": {
      "type": "string",
      "description": "Workspace Id"
    }
  },
  "required": [
    "PCID",
    "clientId",
    "workspaceId"
  ]
}

---

prisma_get_connections

List connections

Parameters:

Parameter	Type	Required	Default	Description
cursor	string	No	—	Cursor for pagination
limit	number	No	—	Limit for pagination
databaseId	string	No	—	Database Id

Show inputSchema

{
  "type": "object",
  "properties": {
    "PCID": {
      "type": "string",
      "description": "Pink Connect ID for the authenticated connection"
    },
    "cursor": {
      "type": "string",
      "description": "Cursor for pagination"
    },
    "limit": {
      "type": "number",
      "description": "Limit for pagination"
    },
    "databaseId": {
      "type": "string",
      "description": "Database Id"
    }
  },
  "required": [
    "PCID"
  ]
}

---

prisma_get_connections_by_id

Get connection

Parameters:

Parameter	Type	Required	Default	Description
id	string	Yes	—	The id value

Show inputSchema

{
  "type": "object",
  "properties": {
    "PCID": {
      "type": "string",
      "description": "Pink Connect ID for the authenticated connection"
    },
    "id": {
      "type": "string",
      "description": "The id value"
    }
  },
  "required": [
    "PCID",
    "id"
  ]
}

---

prisma_get_databases

List databases

Parameters:

Parameter	Type	Required	Default	Description
cursor	string	No	—	Cursor for pagination
limit	number	No	—	Limit for pagination
projectId	string	No	—	Filter databases by project ID

Show inputSchema

{
  "type": "object",
  "properties": {
    "PCID": {
      "type": "string",
      "description": "Pink Connect ID for the authenticated connection"
    },
    "cursor": {
      "type": "string",
      "description": "Cursor for pagination"
    },
    "limit": {
      "type": "number",
      "description": "Limit for pagination"
    },
    "projectId": {
      "type": "string",
      "description": "Filter databases by project ID"
    }
  },
  "required": [
    "PCID"
  ]
}

---

prisma_get_databases_by_database_id

Get database

Parameters:

Parameter	Type	Required	Default	Description
databaseId	string	Yes	—	Database Id

Show inputSchema

{
  "type": "object",
  "properties": {
    "PCID": {
      "type": "string",
      "description": "Pink Connect ID for the authenticated connection"
    },
    "databaseId": {
      "type": "string",
      "description": "Database Id"
    }
  },
  "required": [
    "PCID",
    "databaseId"
  ]
}

---

prisma_get_databases_by_database_id_backups

Get list of backups

Parameters:

Parameter	Type	Required	Default	Description
databaseId	string	Yes	—	Database Id
limit	integer	No	—	Maximum number of results to return

Show inputSchema

{
  "type": "object",
  "properties": {
    "PCID": {
      "type": "string",
      "description": "Pink Connect ID for the authenticated connection"
    },
    "databaseId": {
      "type": "string",
      "description": "Database Id"
    },
    "limit": {
      "type": "integer",
      "description": "Maximum number of results to return"
    }
  },
  "required": [
    "PCID",
    "databaseId"
  ]
}

---

prisma_get_databases_by_database_id_connections

Get list of database connections

Parameters:

Parameter	Type	Required	Default	Description
databaseId	string	Yes	—	Database Id
cursor	string	No	—	Cursor for pagination
limit	number	No	—	Limit for pagination

Show inputSchema

{
  "type": "object",
  "properties": {
    "PCID": {
      "type": "string",
      "description": "Pink Connect ID for the authenticated connection"
    },
    "databaseId": {
      "type": "string",
      "description": "Database Id"
    },
    "cursor": {
      "type": "string",
      "description": "Cursor for pagination"
    },
    "limit": {
      "type": "number",
      "description": "Limit for pagination"
    }
  },
  "required": [
    "PCID",
    "databaseId"
  ]
}

---

prisma_get_databases_by_database_id_usage

Get database usage metrics

Parameters:

Parameter	Type	Required	Default	Description
databaseId	string	Yes	—	Database Id
startDate	string	No	—	Start date for metrics query. Defaults to start of current month if not provided.
endDate	string	No	—	End date for metrics query. Will be set to end of day if a future date is provided. Defaults to current date if not provided.

Show inputSchema

{
  "type": "object",
  "properties": {
    "PCID": {
      "type": "string",
      "description": "Pink Connect ID for the authenticated connection"
    },
    "databaseId": {
      "type": "string",
      "description": "Database Id"
    },
    "startDate": {
      "type": "string",
      "description": "Start date for metrics query. Defaults to start of current month if not provided."
    },
    "endDate": {
      "type": "string",
      "description": "End date for metrics query. Will be set to end of day if a future date is provided. Defaults to current date if not provided."
    }
  },
  "required": [
    "PCID",
    "databaseId"
  ]
}

---

prisma_get_integrations

Get list of integrations

Parameters:

Parameter	Type	Required	Default	Description
cursor	string	No	—	Cursor for pagination
limit	number	No	—	Limit for pagination
workspaceId	string	Yes	—	Workspace Id

Show inputSchema

{
  "type": "object",
  "properties": {
    "PCID": {
      "type": "string",
      "description": "Pink Connect ID for the authenticated connection"
    },
    "cursor": {
      "type": "string",
      "description": "Cursor for pagination"
    },
    "limit": {
      "type": "number",
      "description": "Limit for pagination"
    },
    "workspaceId": {
      "type": "string",
      "description": "Workspace Id"
    }
  },
  "required": [
    "PCID",
    "workspaceId"
  ]
}

---

prisma_get_integrations_by_id

Get integration by ID

Parameters:

Parameter	Type	Required	Default	Description
id	string	Yes	—	The id value

Show inputSchema

{
  "type": "object",
  "properties": {
    "PCID": {
      "type": "string",
      "description": "Pink Connect ID for the authenticated connection"
    },
    "id": {
      "type": "string",
      "description": "The id value"
    }
  },
  "required": [
    "PCID",
    "id"
  ]
}

---

prisma_get_projects

Get list of projects

Parameters:

Parameter	Type	Required	Default	Description
cursor	string	No	—	Cursor for pagination
limit	number	No	—	Limit for pagination

Show inputSchema

{
  "type": "object",
  "properties": {
    "PCID": {
      "type": "string",
      "description": "Pink Connect ID for the authenticated connection"
    },
    "cursor": {
      "type": "string",
      "description": "Cursor for pagination"
    },
    "limit": {
      "type": "number",
      "description": "Limit for pagination"
    }
  },
  "required": [
    "PCID"
  ]
}

---

prisma_get_projects_by_id

Get project

Parameters:

Parameter	Type	Required	Default	Description
id	string	Yes	—	The id value

Show inputSchema

{
  "type": "object",
  "properties": {
    "PCID": {
      "type": "string",
      "description": "Pink Connect ID for the authenticated connection"
    },
    "id": {
      "type": "string",
      "description": "The id value"
    }
  },
  "required": [
    "PCID",
    "id"
  ]
}

---

prisma_get_projects_by_project_id_databases

Get list of databases

Parameters:

Parameter	Type	Required	Default	Description
projectId	string	Yes	—	Project Id
cursor	string	No	—	Cursor for pagination
limit	number	No	—	Limit for pagination

Show inputSchema

{
  "type": "object",
  "properties": {
    "PCID": {
      "type": "string",
      "description": "Pink Connect ID for the authenticated connection"
    },
    "projectId": {
      "type": "string",
      "description": "Project Id"
    },
    "cursor": {
      "type": "string",
      "description": "Cursor for pagination"
    },
    "limit": {
      "type": "number",
      "description": "Limit for pagination"
    }
  },
  "required": [
    "PCID",
    "projectId"
  ]
}

---

prisma_get_regions

Get all regions

Parameters:

Parameter	Type	Required	Default	Description
product	string	No	—	The product value

Show inputSchema

{
  "type": "object",
  "properties": {
    "PCID": {
      "type": "string",
      "description": "Pink Connect ID for the authenticated connection"
    },
    "product": {
      "type": "string",
      "description": "The product value",
      "enum": [
        "postgres",
        "accelerate"
      ]
    }
  },
  "required": [
    "PCID"
  ]
}

---

prisma_get_regions_accelerate

Get Prisma Accelerate regions

Show inputSchema

{
  "type": "object",
  "properties": {
    "PCID": {
      "type": "string",
      "description": "Pink Connect ID for the authenticated connection"
    }
  },
  "required": [
    "PCID"
  ]
}

---

prisma_get_regions_postgres

Get Prisma Postgres regions

Show inputSchema

{
  "type": "object",
  "properties": {
    "PCID": {
      "type": "string",
      "description": "Pink Connect ID for the authenticated connection"
    }
  },
  "required": [
    "PCID"
  ]
}

---

prisma_get_workspaces

Get list of workspaces

Parameters:

Parameter	Type	Required	Default	Description
cursor	string	No	—	Cursor for pagination
limit	number	No	—	Limit for pagination

Show inputSchema

{
  "type": "object",
  "properties": {
    "PCID": {
      "type": "string",
      "description": "Pink Connect ID for the authenticated connection"
    },
    "cursor": {
      "type": "string",
      "description": "Cursor for pagination"
    },
    "limit": {
      "type": "number",
      "description": "Limit for pagination"
    }
  },
  "required": [
    "PCID"
  ]
}

---

prisma_get_workspaces_by_id

Get workspace

Parameters:

Parameter	Type	Required	Default	Description
id	string	Yes	—	The id value

Show inputSchema

{
  "type": "object",
  "properties": {
    "PCID": {
      "type": "string",
      "description": "Pink Connect ID for the authenticated connection"
    },
    "id": {
      "type": "string",
      "description": "The id value"
    }
  },
  "required": [
    "PCID",
    "id"
  ]
}

---

prisma_get_workspaces_by_workspace_id_integrations

Get list of integrations

Parameters:

Parameter	Type	Required	Default	Description
workspaceId	string	Yes	—	Workspace Id
cursor	string	No	—	Cursor for pagination
limit	number	No	—	Limit for pagination

Show inputSchema

{
  "type": "object",
  "properties": {
    "PCID": {
      "type": "string",
      "description": "Pink Connect ID for the authenticated connection"
    },
    "workspaceId": {
      "type": "string",
      "description": "Workspace Id"
    },
    "cursor": {
      "type": "string",
      "description": "Cursor for pagination"
    },
    "limit": {
      "type": "number",
      "description": "Limit for pagination"
    }
  },
  "required": [
    "PCID",
    "workspaceId"
  ]
}

---

prisma_patch_databases_by_database_id

Update database

Parameters:

Parameter	Type	Required	Default	Description
databaseId	string	Yes	—	Database Id
name	string	No	—	New display name for the database

Show inputSchema

{
  "type": "object",
  "properties": {
    "PCID": {
      "type": "string",
      "description": "Pink Connect ID for the authenticated connection"
    },
    "databaseId": {
      "type": "string",
      "description": "Database Id"
    },
    "name": {
      "type": "string",
      "description": "New display name for the database"
    }
  },
  "required": [
    "PCID",
    "databaseId"
  ]
}

---

prisma_patch_projects_by_id

Update project

Parameters:

Parameter	Type	Required	Default	Description
id	string	Yes	—	The id value
name	string	No	—	The name value
settings	object	No	—	The settings value

Show inputSchema

{
  "type": "object",
  "properties": {
    "PCID": {
      "type": "string",
      "description": "Pink Connect ID for the authenticated connection"
    },
    "id": {
      "type": "string",
      "description": "The id value"
    },
    "name": {
      "type": "string",
      "description": "The name value"
    },
    "settings": {
      "type": "object",
      "description": "The settings value"
    }
  },
  "required": [
    "PCID",
    "id"
  ]
}

---

prisma_post_connections

Create connection

Parameters:

Parameter	Type	Required	Default	Description
databaseId	string	Yes	—	Database Id
name	string	Yes	—	The name value

Show inputSchema

{
  "type": "object",
  "properties": {
    "PCID": {
      "type": "string",
      "description": "Pink Connect ID for the authenticated connection"
    },
    "databaseId": {
      "type": "string",
      "description": "Database Id"
    },
    "name": {
      "type": "string",
      "description": "The name value"
    }
  },
  "required": [
    "PCID",
    "databaseId",
    "name"
  ]
}

---

prisma_post_connections_by_id_rotate

Rotate connection credentials

Parameters:

Parameter	Type	Required	Default	Description
id	string	Yes	—	The id value

Show inputSchema

{
  "type": "object",
  "properties": {
    "PCID": {
      "type": "string",
      "description": "Pink Connect ID for the authenticated connection"
    },
    "id": {
      "type": "string",
      "description": "The id value"
    }
  },
  "required": [
    "PCID",
    "id"
  ]
}

---

prisma_post_databases

Create database

Parameters:

Parameter	Type	Required	Default	Description
isDefault	boolean	No	—	Whether this is the default database
name	string	No	—	Display name for the database
projectId	string	Yes	—	ID of the project to create the database in
region	string	No	—	Region for the database. Use “inherit” to use the project default database region.
source	object	No	—	Source to create the database from. Omit to create an empty database.

Show inputSchema

{
  "type": "object",
  "properties": {
    "PCID": {
      "type": "string",
      "description": "Pink Connect ID for the authenticated connection"
    },
    "isDefault": {
      "type": "boolean",
      "description": "Whether this is the default database"
    },
    "name": {
      "type": "string",
      "description": "Display name for the database"
    },
    "projectId": {
      "type": "string",
      "description": "ID of the project to create the database in"
    },
    "region": {
      "type": "string",
      "description": "Region for the database. Use \"inherit\" to use the project default database region.",
      "enum": [
        "us-east-1",
        "us-west-1",
        "eu-west-3",
        "eu-central-1",
        "ap-northeast-1",
        "ap-southeast-1",
        "inherit"
      ]
    },
    "source": {
      "description": "Source to create the database from. Omit to create an empty database."
    }
  },
  "required": [
    "PCID",
    "projectId"
  ]
}

---

prisma_post_databases_by_database_id_connections

Create database connection string

Parameters:

Parameter	Type	Required	Default	Description
databaseId	string	Yes	—	Database Id
name	string	Yes	—	The name value

Show inputSchema

{
  "type": "object",
  "properties": {
    "PCID": {
      "type": "string",
      "description": "Pink Connect ID for the authenticated connection"
    },
    "databaseId": {
      "type": "string",
      "description": "Database Id"
    },
    "name": {
      "type": "string",
      "description": "The name value"
    }
  },
  "required": [
    "PCID",
    "databaseId",
    "name"
  ]
}

---

prisma_post_databases_by_target_database_id_restore

Restore database (destructive)

Parameters:

Parameter	Type	Required	Default	Description
targetDatabaseId	string	Yes	—	Target Database Id
source	object	Yes	—	The source value

Show inputSchema

{
  "type": "object",
  "properties": {
    "PCID": {
      "type": "string",
      "description": "Pink Connect ID for the authenticated connection"
    },
    "targetDatabaseId": {
      "type": "string",
      "description": "Target Database Id"
    },
    "source": {
      "type": "object",
      "description": "The source value",
      "properties": {
        "type": {
          "type": "string",
          "description": "The type value"
        },
        "databaseId": {
          "type": "string",
          "description": "ID of the database the backup belongs to"
        },
        "backupId": {
          "type": "string",
          "description": "ID of the backup to restore from"
        }
      },
      "required": [
        "type",
        "databaseId",
        "backupId"
      ]
    }
  },
  "required": [
    "PCID",
    "targetDatabaseId",
    "source"
  ]
}

---

prisma_post_projects

Create project with a postgres database

Parameters:

Parameter	Type	Required	Default	Description
createDatabase	boolean	No	—	Create Database
name	string	No	—	The name value
region	string	No	—	The region value

Show inputSchema

{
  "type": "object",
  "properties": {
    "PCID": {
      "type": "string",
      "description": "Pink Connect ID for the authenticated connection"
    },
    "createDatabase": {
      "type": "boolean",
      "description": "Create Database"
    },
    "name": {
      "type": "string",
      "description": "The name value"
    },
    "region": {
      "type": "string",
      "description": "The region value",
      "enum": [
        "us-east-1",
        "us-west-1",
        "eu-west-3",
        "eu-central-1",
        "ap-northeast-1",
        "ap-southeast-1"
      ]
    }
  },
  "required": [
    "PCID"
  ]
}

---

prisma_post_projects_by_id_transfer

Transfer project

Parameters:

Parameter	Type	Required	Default	Description
id	string	Yes	—	The id value
recipientAccessToken	string	Yes	—	Recipient Access Token

Show inputSchema

{
  "type": "object",
  "properties": {
    "PCID": {
      "type": "string",
      "description": "Pink Connect ID for the authenticated connection"
    },
    "id": {
      "type": "string",
      "description": "The id value"
    },
    "recipientAccessToken": {
      "type": "string",
      "description": "Recipient Access Token"
    }
  },
  "required": [
    "PCID",
    "id",
    "recipientAccessToken"
  ]
}

---

prisma_post_projects_by_project_id_databases

Create database

Parameters:

Parameter	Type	Required	Default	Description
projectId	string	Yes	—	Project Id
fromDatabase	object	No	—	Deprecated: use source instead.
isDefault	boolean	No	—	Is Default
name	string	No	—	The name value
region	string	No	—	The region value
source	object	No	—	The source value

Show inputSchema

{
  "type": "object",
  "properties": {
    "PCID": {
      "type": "string",
      "description": "Pink Connect ID for the authenticated connection"
    },
    "projectId": {
      "type": "string",
      "description": "Project Id"
    },
    "fromDatabase": {
      "type": "object",
      "description": "Deprecated: use `source` instead.",
      "properties": {
        "id": {
          "type": "string",
          "description": "The id value"
        },
        "backupId": {
          "type": "string",
          "description": "The unique identifier for this backup"
        }
      },
      "required": [
        "id"
      ]
    },
    "isDefault": {
      "type": "boolean",
      "description": "Is Default"
    },
    "name": {
      "type": "string",
      "description": "The name value"
    },
    "region": {
      "type": "string",
      "description": "The region value",
      "enum": [
        "us-east-1",
        "us-west-1",
        "eu-west-3",
        "eu-central-1",
        "ap-northeast-1",
        "ap-southeast-1",
        "inherit"
      ]
    },
    "source": {
      "description": "The source value"
    }
  },
  "required": [
    "PCID",
    "projectId"
  ]
}