Angora data

Skill Aysnc-Labs/angora/.claude/skills/angora-data

Quick operations on `src/data/data.sqlite` — inspect the current schema, add a single column to an existing table via Drizzle migration, seed 2-5 test rows, or run a read-only SELECT/COUNT query. Trigger whenever the user wants a small, single-step database operation. Phrases like 'add a company column to testimonials', 'seed 5 rows into pricing_tiers', 'show me the schema', 'count draft vs published posts grouped by author', 'what's in the media table', 'add a phone column to team_members' all trigger this. For designing new tables or rethinking relationships use angora-schema; for bulk imports from inbox files use angora-import.From its SKILL.md

Install

npx -y skills add Aysnc-Labs/angora --skill angora-data

Assembled from the repository path, not quoted from the project. Check it against their README if it does not work.

2 things to look at

6 stars6 stars. Stars are a popularity signal and not a quality one, but at this level it is likely that nobody has read this closely except its author, and you would be relying on your own review.
runs commandsInstructs the agent to run 2 commands, including `pnpm db:generate` and 1 more.

SKILL.md

2.8 KB, 556 tokens by cl100k_base, as published. Nobody here has run it

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 <table> <column>`	Add a column to the Drizzle schema, generate and apply migration (confirm first)
`seed <table>`	Generate 2-5 realistic sample rows
`query <description>`	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/<table>.ts and use db.select(), .where(), etc.

Schema changes (ALTER TABLE, etc.)

All DDL goes through the Drizzle workflow:

Edit the table's file in src/data/schema/tables/ — add the column to the table definition
Generate migration — pnpm db:generate
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

What ships with it: 1 file

1.8 KB alongside SKILL.md

evals/

trigger-eval.json1.8 KB