Skill System Memory (PostgreSQL)

Persistent shared memory for all AI agents. PostgreSQL 14+ on Linux or Windows. Memory failures look like intelligence failures — this skill ensures the right memory is retrieved at the right time.

Contract notes:

• Module-first: mem.py and MCP tooling are the primary runtime surface.
• Plugin optional: OpenCode plugin integration is an adapter layer, not a required dependency.
• Prefer project-scoped DB naming: <project>-memory (for example skills-memory).

DB Targeting — Project Isolation

Skills are installed globally but memory is project-scoped. Isolation is at the database level: each project gets its own PostgreSQL database named <project>-memory.

Cross-DB recall is an explicit read-side feature, not a default mode. Search and context reads stay on the current memory DB unless the caller opts in with scope=all or cross_db=true. All write paths remain pinned to the local SKILL_PGDATABASE target.

Search Path Role Architecture (SK-C)