bus-api-provider-database

Database API Provider

bus-api-provider-database is the running-Bus HTTP surface for database setup and verification. It keeps REST controllers provider-neutral and delegates database work through bus-integration-database.

Run this provider on loopback or a protected internal network behind bus-api. The supported deployment boundary is bus-api routing with an internal operator token or internal service credential, plus reverse-proxy rules that do not expose /api/internal/database/* directly to the public internet. The current provider handler is an internal component and does not perform public-client authentication by itself.

Available endpoints return 200 with JSON on success:

  • GET /healthz returns {"ok":true,"service":"bus-api-provider-database"}.
  • GET /api/internal/database/capabilities returns provider-neutral capability metadata with PostgreSQL provider discovery, event names, and direct-bootstrap support.
  • GET /api/internal/database/plan returns {"ok":true,"actions":[...]} for the current database plan view.

Before starting it, install bus-api-provider-database, bus-integration-database, and the selected provider integration from the same BusDK release set. For PostgreSQL-backed deployments, set BUS_DATABASE_PROVIDER=postgres in the service environment; the capability endpoint then advertises PostgreSQL and database event names.

BUS_DATABASE_PROVIDER=postgres bus-api-provider-database --addr 127.0.0.1:8092

In a second shell, verify the provider:

curl -fsS http://127.0.0.1:8092/healthz
curl -fsS http://127.0.0.1:8092/api/internal/database/capabilities

The first check succeeds with ok: true; the second includes database event names such as bus.database.plan.request.

For protected access through bus-api, enable the built-in provider by name and enable the matching module mount. Store the Bus API capability token in an untracked operator secret file before starting the service, then validate it is non-empty:

cd /path/to/deployment-repository
install -m 700 -d ./local
git check-ignore -q ./local/bus-api-capability-token || printf '%s\n' '/local/' >> .git/info/exclude
git check-ignore -q ./local/bus-api-capability-token
test -s ./local/bus-api-capability-token || openssl rand -hex 32 > ./local/bus-api-capability-token
chmod 600 ./local/bus-api-capability-token
test -s ./local/bus-api-capability-token
BUS_API_CAPABILITY_TOKEN="$(tr -d '\r\n' < ./local/bus-api-capability-token)"
test -n "$BUS_API_CAPABILITY_TOKEN"
bus-api serve --token "$BUS_API_CAPABILITY_TOKEN" --port 8080 \
  --provider database \
  --enable-module database

Keep bus-api serve running in that shell. In a second shell, set $BUS_API_BASE_URL to the local capability URL printed by bus-api, then verify the protected route:

cd /path/to/deployment-repository
BUS_API_CAPABILITY_TOKEN="$(tr -d '\r\n' < ./local/bus-api-capability-token)"
test -n "$BUS_API_CAPABILITY_TOKEN"
export BUS_API_BASE_URL="http://127.0.0.1:8080/${BUS_API_CAPABILITY_TOKEN}/v1"
curl -fsS "$BUS_API_BASE_URL/api/internal/database/capabilities"

PostgreSQL-specific behavior belongs to bus-integration-postgres; this provider exposes the stable Bus API surface used by operators and deployment automation.

Using from .bus files

Inside a .bus file, start the provider on loopback and let bus-api or the supervisor own public routing:

# same as: BUS_DATABASE_PROVIDER=postgres bus-api-provider-database --addr 127.0.0.1:8092
run command -- sh -c 'BUS_DATABASE_PROVIDER=postgres exec bus-api-provider-database --addr 127.0.0.1:8092'