> ## Documentation Index
> Fetch the complete documentation index at: https://docs.pinkfish.ai/llms.txt
> Use this file to discover all available pages before exploring further.

# prisma

> Prisma Postgres Management

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

## Tools

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

<Expandable title="inputSchema">
  ```json theme={null}
  {
    "type": "object",
    "properties": {
      "PCID": {
        "type": "string",
        "description": "Pink Connect ID for the authenticated connection"
      },
      "id": {
        "type": "string",
        "description": "The id value"
      }
    },
    "required": [
      "PCID",
      "id"
    ]
  }
  ```
</Expandable>

***

## prisma\_delete\_databases\_by\_database\_id

Delete database

**Parameters:**

| Parameter    | Type   | Required | Default | Description |
| ------------ | ------ | -------- | ------- | ----------- |
| `databaseId` | string | Yes      | —       | Database Id |

<Expandable title="inputSchema">
  ```json theme={null}
  {
    "type": "object",
    "properties": {
      "PCID": {
        "type": "string",
        "description": "Pink Connect ID for the authenticated connection"
      },
      "databaseId": {
        "type": "string",
        "description": "Database Id"
      }
    },
    "required": [
      "PCID",
      "databaseId"
    ]
  }
  ```
</Expandable>

***

## prisma\_delete\_integrations\_by\_id

Delete integration

**Parameters:**

| Parameter | Type   | Required | Default | Description  |
| --------- | ------ | -------- | ------- | ------------ |
| `id`      | string | Yes      | —       | The id value |

<Expandable title="inputSchema">
  ```json theme={null}
  {
    "type": "object",
    "properties": {
      "PCID": {
        "type": "string",
        "description": "Pink Connect ID for the authenticated connection"
      },
      "id": {
        "type": "string",
        "description": "The id value"
      }
    },
    "required": [
      "PCID",
      "id"
    ]
  }
  ```
</Expandable>

***

## prisma\_delete\_projects\_by\_id

Delete project

**Parameters:**

| Parameter | Type   | Required | Default | Description  |
| --------- | ------ | -------- | ------- | ------------ |
| `id`      | string | Yes      | —       | The id value |

<Expandable title="inputSchema">
  ```json theme={null}
  {
    "type": "object",
    "properties": {
      "PCID": {
        "type": "string",
        "description": "Pink Connect ID for the authenticated connection"
      },
      "id": {
        "type": "string",
        "description": "The id value"
      }
    },
    "required": [
      "PCID",
      "id"
    ]
  }
  ```
</Expandable>

***

## 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 |

<Expandable title="inputSchema">
  ```json theme={null}
  {
    "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"
    ]
  }
  ```
</Expandable>

***

## 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           |

<Expandable title="inputSchema">
  ```json theme={null}
  {
    "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"
    ]
  }
  ```
</Expandable>

***

## prisma\_get\_connections\_by\_id

Get connection

**Parameters:**

| Parameter | Type   | Required | Default | Description  |
| --------- | ------ | -------- | ------- | ------------ |
| `id`      | string | Yes      | —       | The id value |

<Expandable title="inputSchema">
  ```json theme={null}
  {
    "type": "object",
    "properties": {
      "PCID": {
        "type": "string",
        "description": "Pink Connect ID for the authenticated connection"
      },
      "id": {
        "type": "string",
        "description": "The id value"
      }
    },
    "required": [
      "PCID",
      "id"
    ]
  }
  ```
</Expandable>

***

## 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 |

<Expandable title="inputSchema">
  ```json theme={null}
  {
    "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"
    ]
  }
  ```
</Expandable>

***

## prisma\_get\_databases\_by\_database\_id

Get database

**Parameters:**

| Parameter    | Type   | Required | Default | Description |
| ------------ | ------ | -------- | ------- | ----------- |
| `databaseId` | string | Yes      | —       | Database Id |

<Expandable title="inputSchema">
  ```json theme={null}
  {
    "type": "object",
    "properties": {
      "PCID": {
        "type": "string",
        "description": "Pink Connect ID for the authenticated connection"
      },
      "databaseId": {
        "type": "string",
        "description": "Database Id"
      }
    },
    "required": [
      "PCID",
      "databaseId"
    ]
  }
  ```
</Expandable>

***

## 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 |

<Expandable title="inputSchema">
  ```json theme={null}
  {
    "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"
    ]
  }
  ```
</Expandable>

***

## 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  |

<Expandable title="inputSchema">
  ```json theme={null}
  {
    "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"
    ]
  }
  ```
</Expandable>

***

## 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. |

<Expandable title="inputSchema">
  ```json theme={null}
  {
    "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"
    ]
  }
  ```
</Expandable>

***

## 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          |

<Expandable title="inputSchema">
  ```json theme={null}
  {
    "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"
    ]
  }
  ```
</Expandable>

***

## prisma\_get\_integrations\_by\_id

Get integration by ID

**Parameters:**

| Parameter | Type   | Required | Default | Description  |
| --------- | ------ | -------- | ------- | ------------ |
| `id`      | string | Yes      | —       | The id value |

<Expandable title="inputSchema">
  ```json theme={null}
  {
    "type": "object",
    "properties": {
      "PCID": {
        "type": "string",
        "description": "Pink Connect ID for the authenticated connection"
      },
      "id": {
        "type": "string",
        "description": "The id value"
      }
    },
    "required": [
      "PCID",
      "id"
    ]
  }
  ```
</Expandable>

***

## 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  |

<Expandable title="inputSchema">
  ```json theme={null}
  {
    "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"
    ]
  }
  ```
</Expandable>

***

## prisma\_get\_projects\_by\_id

Get project

**Parameters:**

| Parameter | Type   | Required | Default | Description  |
| --------- | ------ | -------- | ------- | ------------ |
| `id`      | string | Yes      | —       | The id value |

<Expandable title="inputSchema">
  ```json theme={null}
  {
    "type": "object",
    "properties": {
      "PCID": {
        "type": "string",
        "description": "Pink Connect ID for the authenticated connection"
      },
      "id": {
        "type": "string",
        "description": "The id value"
      }
    },
    "required": [
      "PCID",
      "id"
    ]
  }
  ```
</Expandable>

***

## 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  |

<Expandable title="inputSchema">
  ```json theme={null}
  {
    "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"
    ]
  }
  ```
</Expandable>

***

## prisma\_get\_regions

Get all regions

**Parameters:**

| Parameter | Type   | Required | Default | Description       |
| --------- | ------ | -------- | ------- | ----------------- |
| `product` | string | No       | —       | The product value |

<Expandable title="inputSchema">
  ```json theme={null}
  {
    "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"
    ]
  }
  ```
</Expandable>

***

## prisma\_get\_regions\_accelerate

Get Prisma Accelerate regions

<Expandable title="inputSchema">
  ```json theme={null}
  {
    "type": "object",
    "properties": {
      "PCID": {
        "type": "string",
        "description": "Pink Connect ID for the authenticated connection"
      }
    },
    "required": [
      "PCID"
    ]
  }
  ```
</Expandable>

***

## prisma\_get\_regions\_postgres

Get Prisma Postgres regions

<Expandable title="inputSchema">
  ```json theme={null}
  {
    "type": "object",
    "properties": {
      "PCID": {
        "type": "string",
        "description": "Pink Connect ID for the authenticated connection"
      }
    },
    "required": [
      "PCID"
    ]
  }
  ```
</Expandable>

***

## 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  |

<Expandable title="inputSchema">
  ```json theme={null}
  {
    "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"
    ]
  }
  ```
</Expandable>

***

## prisma\_get\_workspaces\_by\_id

Get workspace

**Parameters:**

| Parameter | Type   | Required | Default | Description  |
| --------- | ------ | -------- | ------- | ------------ |
| `id`      | string | Yes      | —       | The id value |

<Expandable title="inputSchema">
  ```json theme={null}
  {
    "type": "object",
    "properties": {
      "PCID": {
        "type": "string",
        "description": "Pink Connect ID for the authenticated connection"
      },
      "id": {
        "type": "string",
        "description": "The id value"
      }
    },
    "required": [
      "PCID",
      "id"
    ]
  }
  ```
</Expandable>

***

## 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  |

<Expandable title="inputSchema">
  ```json theme={null}
  {
    "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"
    ]
  }
  ```
</Expandable>

***

## 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 |

<Expandable title="inputSchema">
  ```json theme={null}
  {
    "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"
    ]
  }
  ```
</Expandable>

***

## 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 |

<Expandable title="inputSchema">
  ```json theme={null}
  {
    "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"
    ]
  }
  ```
</Expandable>

***

## prisma\_post\_connections

Create connection

**Parameters:**

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

<Expandable title="inputSchema">
  ```json theme={null}
  {
    "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"
    ]
  }
  ```
</Expandable>

***

## prisma\_post\_connections\_by\_id\_rotate

Rotate connection credentials

**Parameters:**

| Parameter | Type   | Required | Default | Description  |
| --------- | ------ | -------- | ------- | ------------ |
| `id`      | string | Yes      | —       | The id value |

<Expandable title="inputSchema">
  ```json theme={null}
  {
    "type": "object",
    "properties": {
      "PCID": {
        "type": "string",
        "description": "Pink Connect ID for the authenticated connection"
      },
      "id": {
        "type": "string",
        "description": "The id value"
      }
    },
    "required": [
      "PCID",
      "id"
    ]
  }
  ```
</Expandable>

***

## 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.              |

<Expandable title="inputSchema">
  ```json theme={null}
  {
    "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"
    ]
  }
  ```
</Expandable>

***

## 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 |

<Expandable title="inputSchema">
  ```json theme={null}
  {
    "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"
    ]
  }
  ```
</Expandable>

***

## 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   |

<Expandable title="inputSchema">
  ```json theme={null}
  {
    "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"
    ]
  }
  ```
</Expandable>

***

## 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 |

<Expandable title="inputSchema">
  ```json theme={null}
  {
    "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"
    ]
  }
  ```
</Expandable>

***

## 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 |

<Expandable title="inputSchema">
  ```json theme={null}
  {
    "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"
    ]
  }
  ```
</Expandable>

***

## 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                  |

<Expandable title="inputSchema">
  ```json theme={null}
  {
    "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"
    ]
  }
  ```
</Expandable>