Prisma/docs
Getting StartedORMPostgresCLIGuides
Databases

Create database

Creates a new database in the specified project.

Creates a new database in the specified project.

POST/v1/databases

Authorization

AuthorizationBearer <token>

OAuth2 authentication

In: header

Scope: workspace:admin, offline_access

Request Body

application/json

TypeScript Definitions

Use the request body type in TypeScript.

Response Body

application/json

application/json

application/json

application/json

application/json

curl -X POST "https://api.prisma.io/v1/databases" \  -H "Content-Type: application/json" \  -d '{    "projectId": "string"  }'
{
  "data": {
    "id": "string",
    "type": "database",
    "url": "http://example.com",
    "name": "string",
    "status": "failure",
    "createdAt": "2019-08-24T14:15:22Z",
    "isDefault": true,
    "defaultConnectionId": "string",
    "connections": [
      {
        "id": "string",
        "type": "connection",
        "url": "http://example.com",
        "name": "string",
        "createdAt": "2019-08-24T14:15:22Z",
        "kind": "postgres",
        "endpoints": {
          "direct": {
            "host": "string",
            "port": 0,
            "connectionString": "string"
          },
          "pooled": {
            "host": "string",
            "port": 0,
            "connectionString": "string"
          },
          "accelerate": {
            "host": "string",
            "port": 0,
            "connectionString": "string"
          }
        },
        "directConnection": {
          "host": "string",
          "pass": "string",
          "user": "string"
        },
        "database": {
          "id": "string",
          "url": "http://example.com",
          "name": "string"
        }
      }
    ],
    "project": {
      "id": "string",
      "url": "http://example.com",
      "name": "string"
    },
    "region": {
      "id": "string",
      "name": "string"
    },
    "source": {
      "type": "empty"
    }
  }
}
Edit on GitHub

Restore database (destructive) POST

**Destructive operation** — this immediately and irreversibly overwrites all data in the target database with the contents of the specified backup. Any data written since the backup was taken will be lost. Ensure you have a recent backup of the target database before proceeding. Replaces the data in an existing database from a backup. Connections and credentials are preserved — only the data layer is replaced.

Create database POST

Creates a new database for the given project.