pg

User preferences and memory live in ~/Clawic/data/pg/ (see setup.md on first use, memory-template.md for the file format). If you have data at an old location (~/pg/ or ~/clawic/pg/), move it to ~/Clawic/data/pg/.

When To Use

• A query is slow, a plan needs interpretation, or an index is being ignored
• Designing a schema: types, keys, constraints, partitions, JSONB vs columns
• Running DDL, a migration, or a backfill against a live production table
• Operating Postgres: connections, timeouts, vacuum, bloat, locks, replication, backups, upgrades
• A production incident: disk full, wraparound warnings, connection storm, runaway query, suspected corruption
• Building queue, upsert, search, or vector patterns that Postgres solves natively
• Not for cross-engine SQL portability or ORM-level modeling (see Related Skills)

Quick Reference