GBrain Postgres Schema (src/schema.sql)

Defines PostgreSQL tables, extensions, and source tenancy schema for GBrain, enabling vector search and trigram indexing.

-- Source: https://github.com/mperkins0155/gbrain | License: MIT | Copyright 2026 Garry Tan
-- Provided via justclaw.it.com; keep this notice with the code.
-- GBrain Postgres + pgvector schema

CREATE EXTENSION IF NOT EXISTS vector;
CREATE EXTENSION IF NOT EXISTS pg_trgm;
-- gen_random_uuid() is core in Postgres 13+; enable pgcrypto as fallback for older versions
CREATE EXTENSION IF NOT EXISTS pgcrypto;

-- ============================================================
-- sources: multi-repo / multi-brain tenancy (v0.18.0)
-- ============================================================
-- A source is a logical brain-within-the-DB: wiki, gstack, yc-media, etc.
-- Every page/file/ingest_log row carries source_id.
--
-- id:         immutable citation key. [a-z0-9-]{1,32} enforced at app layer.

... (truncated -- full source via MCP)