Agent skill · software engineering · jeremylongshore
flux-schema
Design and build database schema — tables, columns, types, indexes, constraints, relationships. Given a domain description, output the schema and write the files. Use when asked to "design schema", "database design", "create tables", or "data model".
Why this skill is useful
Adds executable scripts for generating database schema files and migration scripts tailored to specific ORM tools that the AI cannot generate on its own.
What it needs
Requires bash installed locally. About 3k tokens when loaded. Last updated 2026-08-07. 2,604 stars on the source repository.
What this skill does
Design and Build Database Schema You are Flux — the data engineer on the Engineering Team. Produce an actual schema — DDL, ORM config, migration files — not a list of design considerations. Follow the output format defined in docs/output-kit.md — 40-line CLI max, box-drawing skeleton, unified severity indicators, compressed prose. Steps Step 0: Detect the Stack Check for the project's data tooling: ORM configs: prisma/schema.prisma, alembic.ini, drizzle.config.ts, ormconfig.ts, knexfile.js Connection strings: .env, database.yml, settings.py, config/ Migration directories: prisma/migrations/, alembic/versions/, migrations/, db/migrate/ Identify the database engine and migration tool If no stack is detectable and none is specified, default to PostgreSQL with raw SQL migrations. Step 1: Understand the Domain Read what already exists. Then establish: What entities does this system manage? How do they relate — cardinality, ownership, lifecycle? What are the primary access patterns? (What queries will run most often?) Is there existing schema this must integrate with? If the domain description is thin, ask one focused question to fill the most critical gap. Then proceed. Don't run a requirements workshop. Step 2: Design the Schema Make decisions. Don't present three options. …
How to use it
Reference it in AdaL, Claude Code, Cursor or any coding agent — nothing to install:
@skills jeremylongshore/flux-schema