Angora Data

Data: $ARGUMENTS

Quick operations on the SQLite content layer (src/data/data.sqlite).

Commands

Schema inspection

Glob src/data/schema/tables/*.ts to discover tables, then read individual files for column details. No need to query the database for structure.

Read-only queries

node -e "
  import db from './src/data/db.ts';
  import { media } from './src/data/schema/tables/media.ts';
  const rows = db.select().from(media).all();
  console.table(rows);
"

Use Drizzle's typed API. Import the relevant table from schema/tables/<table>.ts and use db.select(), .where(), etc.

Schema changes (ALTER TABLE, etc.)

All DDL goes through the Drizzle workflow:

1. Edit the table's file in src/data/schema/tables/ — add the column to the table definition
2. Generate migration — pnpm db:generate
3. Apply migration — pnpm db:migrate

Each step requires user approval.

Seeding data

node -e "
  import db from './src/data/db.ts';
  import { <table> } from './src/data/schema/tables/<table>.ts';
  db.insert(<table>).values([
    { /* row 1 */ },
    { /* row 2 */ },
  ]).run();
  console.log('Seeded.');
"

Rules

• All schema changes require user approval before executing.
• Foreign keys are ON — respect referential integrity.
• Use text() for dates (ISO 8601 format).
• Use integer() for booleans (0/1).
• query runs read-only — refuse writes via this command.

For heavier work

This skill is for quick operations. For more involved work, use /angora:

• Schema design (new tables, relational modeling, SEO fields) → /angora-schema
• Data import (CSV, JSON from inbox) → /angora-import
• Media processing (images from inbox) → /angora-media