Sites

Read the database's current schema

The schema a database actually has, as the SQL that would recreate it. Pass environment to read the development database (what you are building against) or production (what the site is serving). Production's shape is changed only by deploying — it is a diff of development against it — so this is for understanding, not authoring.

get/sites/{id}/db/schema

Request

  • Base URL: https://api.crevio.co/v1
  • URL: https://api.crevio.co/v1/sites/{id}/db/schema
  • Auth: API key in header Authorization

Path parameters

idstring required

The resource ID (e.g., "prod_abc123") or slug (e.g., "my-product")

Response

Current schema

objectstring
environmentstring
schemastring

CREATE statements for every table, index and trigger.

object_countinteger

Changes

No recorded changes to this operation across all 2 revisions of this API.