Angora Data

Data: $ARGUMENTS

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

Commands

| Command | Action | |---------|--------| | schema (or no arguments) | Show full database schema (glob src/data/schema/tables/*.ts) | | add column | Add a column to the Drizzle schema, generate and apply migration (confirm first) | | seed | Generate 2-5 realistic sample rows | | query | Run a read-only query and display results |

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/.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 {  } from './src/data/schema/tables/.ts';
  db.insert().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

Source & license

This open-source skill is cataloged on AgentStack and links to its original source — we do not rehost the code.

• Author: Aysnc-Labs
• Source: Aysnc-Labs/angora
• License: MIT
• Homepage: https://getangora.org

Install and usage instructions live in the source repository linked above.