Databases Endpoint

GET /api/v1/servers/:id/databases

List every database the collector discovered on a server. Scope: read:servers.

{
  "data": [
    {
      "name": "production",
      "monitored": true,
      "size_bytes": 53687091200,
      "table_count": 142,
      "owner": "app_user",
      "last_collected": "2026-04-25T10:14:30Z"
    },
    ...
  ]
}

PATCH /api/v1/servers/:id/databases/:name

Toggle monitoring for a single database without touching the rest. Scope: admin:servers.

{ "monitored": false }

Useful when a database appears in discovery (it's there on the cluster) but you don't want it counted against your plan's database quota.

GET /api/v1/servers/:id/databases/:name/tables

Per-table stats for one database. Same shape as the Tables page in the UI, same defaults. Scope: read:metrics. Useful query params: ?range=24h, ?sort=size|bloat|seq_scans|n_dead_tup, plus pagination.

GET /api/v1/servers/:id/databases/:name/indexes

Per-index stats for one database. Scope: read:metrics. Same filtering as the Tables endpoint.