Aurekai integration surface for PostgreSQL - robust, transactional, multi-tenant data-ml storage for model memory, SAE dictionaries, semantic cache, manifests, and proof bundles.
Status: active Type: data-ml
aurekai-postgres provides PostgreSQL DDL schemas and operational scripts to persist and query Aurekai artifacts with production-grade guarantees: ACID transactions, row-level security compatibility, indexing, and JSONB-native querying.
| Template | Description |
|---|---|
doctor-deep |
Connection checks, schema integrity, and optional akai doctor --deep |
manifest-verify |
Validate aurekai.deploy.v1 manifest record in Postgres |
model-memory-pack |
Insert .akmodel / .bfmodel / .akfpqx / .bffpqx metadata + payload |
sae-audit |
Audit SAE dictionary records by extension/operator/layer |
semantic-cache-bench |
Benchmark cache write/read throughput on Postgres |
proof-bundle-export |
Export proof bundle rows to out/proof-bundle.json |
release-gate |
Verify populated tables and release constraints before publish |
# 1) Start local postgres (optional)
docker compose -f examples/docker-compose.postgres.yaml up -d
# 2) Export connection string
export DATABASE_URL=postgresql://aurekai:aurekai@localhost:5432/aurekai
# 3) Initialize schema
bash scripts/init-db.sh "$DATABASE_URL"
# 4) Run deep checks
bash scripts/doctor-deep.sh "$DATABASE_URL"
# 5) Run release gate
bash scripts/release-gate.sh "$DATABASE_URL"sql/ PostgreSQL schema files
scripts/ Operational template scripts
examples/ Local compose + sample payloads
tests/ Validation scripts for CI/local
docs/ Quickstart and reference docs
- Platform: https://github.com/aurekai/aurekai
- Native runtime: https://github.com/aurekai/native-runtime
- Integration registry: https://github.com/aurekai/aurekai/blob/main/registry/integrations.json
- Ecosystem map: https://github.com/aurekai/aurekai/blob/main/ECOSYSTEM_NAMES.md