angora-data
Performs fast SQLite tasks like schema viewing, row seeding, and data querying without complex setups.
Install
mkdir -p .claude/skills/angora-data && curl -L -o skill.zip "https://agentskills.codes/api/skills/download/12006" && unzip -o skill.zip -d .claude/skills/angora-data && rm skill.zipInstalls to .claude/skills/angora-data
Activation
This is the description your AI agent reads to decide when to run this skill — the better it matches your request, the more reliably it fires.
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.Key capabilities
- →Inspect the current database schema
- →Add a single column to an existing table via Drizzle migration
- →Seed 2-5 test rows into a table
- →Run read-only SELECT/COUNT queries
- →Generate Drizzle migrations for schema changes
How it works
This skill performs quick operations on the `src/data/data.sqlite` database. It can display the schema, add columns via Drizzle migrations, seed sample data, or execute read-only queries using Drizzle's typed API.
Inputs & outputs
When to use angora-data
- →View database schema
- →Seed test data into tables
- →Run quick SQL count or select queries
About this skill
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). queryruns 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
When not to use it
- →When designing new tables or rethinking relationships
- →When performing bulk imports from inbox files
- →When processing media from inbox
Limitations
- →All schema changes require user approval before executing
- →Foreign keys are ON
- →The `query` command runs read-only
How it compares
This skill provides a simplify way to perform small, single-step database operations with user approval for schema changes, unlike manual SQL commands that might lack validation or Drizzle integration.
Compared to similar skills
angora-data side by side with the closest alternatives in the catalog.
| Skill | Installs | Updated | Safety | Difficulty |
|---|---|---|---|---|
| angora-data (this skill) | 0 | 3mo | Review | Intermediate |
| agentdb-advanced-features | 7 | 9mo | Review | Advanced |
| senior-backend | 14 | 7mo | Review | Advanced |
| redis-inspect | 6 | 6mo | Review | Beginner |
Try saying
Example prompts that trigger this skill in your AI assistant.
You might also like
agentdb-advanced-features
ruvnet
Master advanced AgentDB features including QUIC synchronization, multi-database management, custom distance metrics, hybrid search, and distributed systems integration. Use when building distributed AI systems, multi-agent coordination, or advanced vector search applications.
senior-backend
davila7
Comprehensive backend development skill for building scalable backend systems using NodeJS, Express, Go, Python, Postgres, GraphQL, REST APIs. Includes API scaffolding, database optimization, security implementation, and performance tuning. Use when designing APIs, optimizing database queries, implementing business logic, handling authentication/authorization, or reviewing backend code.
redis-inspect
civitai
Inspect Redis cache keys, values, and TTLs for debugging. Supports both main cache and system cache. Use for debugging cache issues, checking cached values, and monitoring cache state. Read-only by default.
database-migration
wshobson
Execute database migrations across ORMs and platforms with zero-downtime strategies, data transformation, and rollback procedures. Use when migrating databases, changing schemas, performing data transformations, or implementing zero-downtime deployment strategies.
prisma-connection-pool-exhaustion
blader
Fix Prisma "Too many connections" and connection pool exhaustion errors in serverless environments (Vercel, AWS Lambda, Netlify). Use when: (1) Error "P2024: Timed out fetching a new connection from the pool", (2) PostgreSQL "too many connections for role", (3) Database works locally but fails in production serverless, (4) Intermittent database timeouts under load.
add-module
fullstackhero
Create a new module (bounded context) with proper project structure, permissions, DbContext, and registration. Use when adding a new business domain that needs its own entities and endpoints.