data-postgres-main

Primary Postgres 16 cluster on Beacon loopback 5432, authoritative for routing

Endpoint

127.0.0.1:5432

Packaging

systemd

Owner

operator

Version

Updated

2026-06-26

Health check

sudo -u postgres psql -c 'select 1'

Purpose

Primary Postgres 16 cluster on Beacon. Hosts multiple databases including beacon, uai-switchboard, aux, devine, and episodic memory. The beacon database sites table is authoritative for united-ai dot ca subdomain routing.

Capabilities 3

sites-table

Authoritative subdomain routing table

switchboard-db

Node, state, and audit tables for switchboard

app-databases

Multiple app databases including aux and devine

History 1

Createdai2026-06-26

Card created by AI session (audit 2784).

Required tags

Raw card data (JSON)

click to expand

{
  "id": "data-postgres-main",
  "kind": "data-source",
  "summary": "Primary Postgres 16 cluster on Beacon loopback 5432, authoritative for routing",
  "purpose": "Primary Postgres 16 cluster on Beacon. Hosts multiple databases including beacon, uai-switchboard, aux, devine, and episodic memory. The beacon database sites table is authoritative for united-ai dot ca subdomain routing.",
  "endpoint": "127.0.0.1:5432",
  "exposure": "local-only",
  "capabilities_json": "[{\"name\": \"sites-table\", \"description\": \"Authoritative subdomain routing table\"}, {\"name\": \"switchboard-db\", \"description\": \"Node, state, and audit tables for switchboard\"}, {\"name\": \"app-databases\", \"description\": \"Multiple app databases including aux and devine\"}]",
  "dependencies_json": "[\"node-beacon-vps\"]",
  "instructions_slug": "",
  "health_check": "sudo -u postgres psql -c 'select 1'",
  "credential_alias": "",
  "packaging": "systemd",
  "owner": "operator",
  "status": "active",
  "required_tags_json": "[\"ai-authored\", \"capability-card\", \"data-source\", \"docs\", \"uai-explorer\"]",
  "ai_visible": 1,
  "human_visible": 1,
  "embedding_dim": 0,
  "version_id": 1,
  "created_at": "2026-06-26T23:53:32.318422+00:00",
  "updated_at": "2026-06-26T23:53:32.318422+00:00"
}

API examples

curl, Python, JavaScript

# curl
curl -H "Authorization: Bearer $UAI_EXPLORER_AI_API_KEY" \
     https://explorer.united-ai.ca/api/ai/capability/data-postgres-main

# python (requests)
import requests
r = requests.get(
    "https://explorer.united-ai.ca/api/ai/capability/data-postgres-main",
    headers={"Authorization": f"Bearer {token}"},
)
card = r.json()

// JavaScript (fetch)
const r = await fetch(
  "https://explorer.united-ai.ca/api/ai/capability/data-postgres-main",
  { headers: { Authorization: `Bearer ${token}` } }
);
const card = await r.json();