sql

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

When To Use

• Writing, reviewing, or optimizing SQL: queries, joins, CTEs, window functions, upserts
• Designing tables, keys, types, indexes, and constraints, or normalizing an existing model
• Diagnosing a slow query, a deadlock, a lock timeout, wrong totals, or duplicated rows
• Planning migrations and DDL that must not take a live database down
• Operating a database: backups, restores, monitoring, pooling, replication, partitioning
• Moving data in or out: CSV loads, dumps, engine-to-engine migrations
• Not for PostgreSQL server internals (vacuum tuning, work_mem, xid wraparound) — that is pg; not for ORM-level modeling in a framework — that is prisma

Quick Reference