Apply DDL schema and column comments

POST

/schema

• Production
• Development

Creates tables (if not exists) and applies COMMENT ON statements to all warehouse_* databases on MotherDuck. Fast, no MongoDB connection needed. Safe to call repeatedly — never touches data.

Authorizations

• ApiKeyAuth

Responses

200

Schema applied successfully

object

status

required

string

Allowed values: success

Example

success

message

required

string

Example

Schema applied to 177 tenant databases

databases

required

List of database names where schema was applied.

Array<string>

Example

[
  "warehouse_example",
  "warehouse_sheepy_owners_club"
]

401

Authentication required

object

error

required

object

code

required

Machine-readable error code.

string

Example

unauthorized

message

required

Human-readable error message.

string

Example

Authentication required

Example

{
  "error": {
    "code": "unauthorized",
    "message": "Authentication required"
  }
}

500

Internal server error

object

error

required

object

code

required

Machine-readable error code.

string

Example

unauthorized

message

required

Human-readable error message.

string

Example

Authentication required

Example

{
  "error": {
    "code": "schema_error",
    "message": "Schema application failed"
  }
}