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

# Database

> Manage product database schemas, tables, and runtime data via the Manufacturer API.

All requests require the [auth headers](/api/authentication) and are relative to
the [base URL](/api/overview#base-url).

## Schemas

```http theme={null}
GET  /products/{productId}/database/schemas
POST /products/{productId}/database/schemas
```

`GET` lists a product's schemas; `POST` creates one.

## Tables

```http theme={null}
POST /database/tables
```

Create a table within a schema.

## Runtime data

Insert, query, update, and delete records:

```http theme={null}
POST   /database/runtime-data
GET    /database/runtime-data
PUT    /database/runtime-data/{id}
DELETE /database/runtime-data/{id}
```

### Insert

```json theme={null}
{
  "product_id": "your-product-id",
  "device_id": "your-device-id",
  "table_name": "readings",
  "data_payload": { "temperature": 27.4 }
}
```

### Update

```json theme={null}
{
  "data_payload": { "temperature": 28.0 }
}
```

<Note>
  The dashboard Script API exposes a lighter [`db`](/script/database-api) interface
  (`db.query` / `db.insert`) for client-side use; this REST API is the
  server-to-server equivalent.
</Note>

<Card title="Onboarding" icon="qrcode" href="/api/onboarding">
  QR scan and device registration.
</Card>