Create-knowledge-find-decode/db

Creation Knowledge Database

This directory contains SQL migrations for the formal cloud PostgreSQL state store. Real connection values must stay in local or cloud environment files, not in git.

Current formal database target:

• Database: creation_knowledge_prod
• Schema: creation_knowledge
• Application role: ck_app
• First migration: migrations/001_creation_knowledge_schema.sql

Local development currently connects through an SSH tunnel:

ssh -i /path/to/private-key \
  -L 6543:127.0.0.1:5432 <cloud-user>@<cloud-host>

Then use CK_DB_HOST=127.0.0.1 and CK_DB_PORT=6543 locally. On the cloud machine itself, use CK_DB_HOST=127.0.0.1 and CK_DB_PORT=5432.

Do not use OPEN_AIGC_PG_* for this state store. Those settings are reserved for the upstream Open AIGC category-tree/history database.