Nile · Schema

GetDatabaseResponse

CompanyDatabasePostgreSQLServerlessMulti-TenantAuthenticationB2B SaaS

Properties

Name	Type	Description
id	string
name	string
workspace	object
status	string
region	string
expandable	boolean
created	string
deleted	string
apiHost	stringnull	Public database API URL; Since it is only used for tenants/users management, it is null for un-sharded databases.
dbHost	string
parent	object

View JSON Schema on GitHub

JSON Schema

{
  "$schema": "https://json-schema.org/draft/2020-12/schema",
  "$id": "https://raw.githubusercontent.com/api-evangelist/thenile/main/json-schema/thenile-get-database-response-schema.json",
  "title": "GetDatabaseResponse",
  "x-generated": "2026-10-13",
  "x-method": "derived",
  "x-generator": "derive-json-schema.py",
  "x-source": "openapi/thenile-global-openapi.yml#/components/schemas/GetDatabaseResponse",
  "required": [
    "expandable",
    "id",
    "name",
    "region",
    "status",
    "workspace"
  ],
  "type": "object",
  "properties": {
    "id": {
      "type": "string"
    },
    "name": {
      "minLength": 1,
      "type": "string"
    },
    "workspace": {
      "$ref": "#/$defs/Workspace"
    },
    "status": {
      "type": "string",
      "enum": [
        "PENDING",
        "REQUESTED",
        "BUILT",
        "POOLED",
        "READY"
      ]
    },
    "region": {
      "type": "string",
      "enum": [
        "AWS_US_WEST_2",
        "AWS_US_EAST_1",
        "AWS_EU_CENTRAL_1",
        "AZURE_EASTUS"
      ]
    },
    "expandable": {
      "type": "boolean"
    },
    "created": {
      "type": "string",
      "format": "date-time"
    },
    "deleted": {
      "type": "string",
      "format": "date-time"
    },
    "apiHost": {
      "type": [
        "string",
        "null"
      ],
      "description": "Public database API URL; Since it is only used for tenants/users management, it is null for un-sharded databases.",
      "format": "uri"
    },
    "dbHost": {
      "type": "string",
      "format": "uri"
    },
    "parent": {
      "$ref": "#/$defs/DatabaseParentResponse"
    }
  },
  "$defs": {
    "DatabaseParentResponse": {
      "required": [
        "id",
        "name"
      ],
      "type": "object",
      "properties": {
        "id": {
          "type": "string"
        },
        "name": {
          "minLength": 1,
          "type": "string"
        }
      }
    },
    "Workspace": {
      "required": [
        "name",
        "slug"
      ],
      "type": "object",
      "properties": {
        "id": {
          "type": "string"
        },
        "name": {
          "minLength": 1,
          "type": "string"
        },
        "slug": {
          "minLength": 1,
          "type": "string"
        },
        "stripe_customer_id": {
          "type": "string"
        },
        "created": {
          "type": "string",
          "format": "date-time"
        }
      }
    }
  }
}

Work with this as data

Every JSON Schema here is available over the APIs.io API and to AI agents over MCP.

MCP server

One button, every client — Claude, Cursor, VS Code and the rest.

https://apis.io/mcp

Tools for schemas

4 MCP tools reach this

find_json_schemasBrowse and filter every JSON Schema in the catalog.
apis_io_searchSTART HERE — APIs, providers and tags for one query, each with its total.
resolveTurn a domain, URL or GitHub org into the provider it belongs to.
find_cohortsEvery scored population of providers in the catalog.

All 92 tools →

Call it yourself

curl for this page

This JSON Schema

curl "https://apis.io/api/v1/json-schemas/thenile-get-database-response"

All schemas

curl "https://apis.io/api/v1/json-schemas?limit=25"

Calls without X-API-Key need no key. Calls with it need a paid plan — get a key.

Get an API key

Free tier, no form to fill in. Signing in shares your email address with us — we store it to create your key and to recognise you if you sign in with another provider. See our Privacy Policy and Terms.

GitHub Google LinkedIn

A second provider on the same verified email joins the account you already have.