Design and build database schema — tables, columns, types, indexes, constraints, relationships.

MITAuto-check: notesDatabases

Install Flux Schema

skills CLI
$ npx skills add jeremylongshore/tons-of-skills-marketplace --skill flux-schema -a claude-code

Project install by default; add -g for ~/.claude/skills/.

GitHub CLI
$ gh skill install jeremylongshore/tons-of-skills-marketplace flux-schema --agent claude-code

Project scope by default; add --scope user for a personal install. Needs GitHub CLI 2.90.0 or later (public preview).

Manual copy
$ git clone --depth 1 https://github.com/jeremylongshore/tons-of-skills-marketplace.git skills-src && mkdir -p .claude/skills && cp -r skills-src/plugins/ai-agency/tonone/skills/flux-schema .claude/skills/flux-schema && rm -rf skills-src

Use ~/.claude/skills/ instead of .claude/skills for a personal install. The folder must contain SKILL.md.

Claude Code skills documentation · loads skills from .claude/skills/

Facts

Skill name
flux-schema
GitHub stars
2.8k
Token cost
~1.2k tokens
SKILL.md length
514 words
Files
2
Skills in repo
3,342
Repo updated
First seen
Licence
MIT

At a glance

Design and build database schema — tables, columns, types, indexes, constraints, relationships.

  • Works in 5 steps: Detect the Stack → Understand the Domain → Design the Schema → …
  • Asked to design schema
  • SKILL.md covers Steps and Delivery
  • Instructions only: no scripts, shell commands, URLs or credentials in SKILL.md

What it does

Flux Schema is an agent skill from jeremylongshore/tons-of-skills-marketplace. 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".

Its SKILL.md is about 1.2k tokens, which your agent loads only when the skill is triggered. The skill folder holds 2 other files (for example `.claude-plugin/plugin.json`).

It sits in Databases, covering Database schema design. It works with Prisma. The repository describes itself as: Model-agnostic agent-skills platform with a harness-free canonical layer, verified adapters, and the ccpi package manager. Explore at tonsofskills.com. The licence is MIT.

When your agent uses it

  • Asked to design schema
  • Database design

Example prompts

  • “design schema”
  • “database design”
  • “create tables”
  • “/flux-schema”

Requirements

  • Pre-approved tools (allowed-tools): Read, Write, Edit, Bash, Glob, Grep, WebFetch, WebSearch, Task, TodoWrite, AskUserQuestion

Workflow steps

5 steps, taken from the step headings in SKILL.md.

  1. Detect the Stack
  2. Understand the Domain
  3. Design the Schema
  4. Write the Files
  5. Output the Summary

What it can do on your machine

Read from SKILL.md and the folder at commit cfae287. It shows what the files ask for, not the result of running them.

  • Tool permissions

    Pre-approves these tools, so the agent can use them without asking each time:

    • Read
    • Write
    • Edit
    • Bash
    • Glob
    • Grep
    • WebFetch
    • WebSearch
    • Task
    • TodoWrite

    …and 1 more on the same allowed-tools line.

    From allowed-tools in the SKILL.md frontmatter.

  • Runs code

    No scripts in the folder and no shell commands in SKILL.md (its code samples are sql).

    From the folder's file list and the shell code blocks in SKILL.md.

  • Network

    No URLs in SKILL.md.

    From URLs in SKILL.md, links to its own repository left out.

  • Credentials

    Names no API keys, tokens, secrets or passwords.

    From names ending in _API_KEY, _TOKEN, _SECRET, _KEY or _PASSWORD in SKILL.md.

Context cost

Flux Schema loads about 1.2k tokens when it runs. Until then it costs about 66 tokens; SKILL.md has 514 words of instructions outside code blocks.

Always · name and description, kept in context so the agent knows when to use it
~66
When it runs · the whole SKILL.md, loaded when a task matches
~1.2k

Estimates: characters ÷ 4, the usual rule of thumb; real counts depend on the model's tokenizer. Scripts and assets cost tokens only if the agent reads them.

Safety

Auto-check: notes

The automated check noted patterns worth knowing about, such as sudo or a known installer.

  • NoteMentions a .env fileSKILL.md:23
    - Connection strings: `.env`, `database.yml`, `settings.py`, `config/`
  • NotePre-approves every shell command (allowed-tools: Bash)SKILL.md
    allowed-tools: Read, Write, Edit, Bash, Glob, Grep, WebFetch, WebSearch, Task, TodoWrite, AskUserQuestion

Automated static check — not a guarantee. Review scripts before installing. It scans the text of SKILL.md for risky patterns (piping downloads into a shell, reading credential files, hidden Unicode, destructive commands); files beside SKILL.md are not scanned.

SKILL.md

The full file from jeremylongshore/tons-of-skills-marketplace at commit cfae287, republished under its MIT licence (© jeremylongshore). 514 words, ~1,199 tokens.

Download SKILL.mdSave it as .claude/skills/flux-schema/SKILL.md (or your agent's skills folder). This skill also uses 1 other file; get the full folder from GitHub.
name
flux-schema
description
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".
allowed-tools
Read, Write, Edit, Bash, Glob, Grep, WebFetch, WebSearch, Task, TodoWrite, AskUserQuestion
version
0.6.4
author
tonone-ai <hello@tonone.ai>
license
MIT

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.

Normalization call:

  • Default to 3NF for transactional data — separate entities into their own tables
  • Denormalize (flatten, embed as JSONB, store computed values) only when access patterns make joins genuinely painful and the tradeoff is explicit
  • For lookup/reference data with low cardinality, enums or check constraints beat a join table

Column decisions:

  • NOT NULL by default — nullable columns require a reason
  • TIMESTAMPTZ for all timestamps — never bare TIMESTAMP
  • UUID typed as uuid not text — use gen_random_uuid() as default in Postgres
  • Enum-like columns: TEXT with a CHECK constraint is fine at startup; a proper enum type when values are truly fixed
  • JSONB for genuinely schemaless data; not as a way to avoid modeling

Indexes:

  • Index every foreign key column
  • Index every column that appears in a WHERE, ORDER BY, or JOIN ON for known query patterns
  • Partial indexes where a large fraction of rows will be excluded by a common filter
  • CREATE INDEX CONCURRENTLY on any table with live traffic

Constraints:

  • FOREIGN KEY with explicit ON DELETE behavior — choose RESTRICT, CASCADE, or SET NULL deliberately
  • UNIQUE wherever the business rule requires it
  • CHECK constraints for bounded values and enum-like columns
  • Every table gets created_at TIMESTAMPTZ NOT NULL DEFAULT now() and updated_at TIMESTAMPTZ NOT NULL DEFAULT now()
Show full SKILL.md (131 more words)Show less
Step 3: Write the Files

Write the schema using the project's tooling:

  • Prisma: Update prisma/schema.prisma with full model definitions
  • Drizzle: Update the schema file with table definitions
  • Alembic: Generate a revision file with upgrade() and downgrade()
  • Raw SQL: Write numbered migration files — 001_create_[domain].sql — with both forward and rollback sections

For raw SQL, structure each migration file as:

sql
-- migrate:up

[forward DDL]

-- migrate:down

[rollback DDL]

Write every index, constraint, and default. Don't leave placeholders.

Step 4: Output the Summary

After writing files, output a concise summary:

┌─ Schema: [domain] ──────────────────────────────────────┐
│ Tables: X  │  Indexes: Y  │  Constraints: Z             │
└─────────────────────────────────────────────────────────┘

Tables
  [table_name] — [one-line purpose]
  [table_name] — [one-line purpose]

Key Decisions
  [decision] — [rationale and what was ruled out]
  [decision] — [rationale and what was ruled out]

Indexes
  [idx_name on table(col)] — supports [query pattern]

What Changes Next
  [what will need to evolve as the system grows, and what migration that implies]

40 lines max. Focus on decisions that weren't obvious and what comes next.

Delivery

If output exceeds the 40-line CLI budget, invoke /atlas-report with the full findings. The HTML report is the output. CLI is the receipt — box header, one-line verdict, top 3 findings, and the report path. Never dump analysis to CLI.

© jeremylongshore, MIT. Rendered from Markdown: HTML in the file is shown as text, images as links, and headings moved down two levels. Raw file

Files

SKILL.md and 1 other file in plugins/ai-agency/tonone/skills/flux-schema of jeremylongshore/tons-of-skills-marketplace.

  • SKILL.md
  • .claude-plugin/plugin.json

Open the folder on GitHubat commit cfae287

Compare with similar skills

Flux Schema next to the 5 skills that share the most tags, products or categories with it. Stars are the repository's; “used in” counts other GitHub owners with a copy.

Flux Schema compared with similar skills
SkillStarsUsed inTokensAuto-checkLicenceRepo updated
Flux Schema this skilljeremylongshore/tons-of-skills-marketplace2.8k—~1.2kAutomated safety check: NotesMIT
Datamodellmnimbalyst/nimbalyst1.9k—~713Automated safety check: PassMIT
Prisma Expertdavila7/claude-code-templates33k7 repos~2.6kAutomated safety check: PassMIT
Prisma Helpershepherdjerred/monorepo112—~3.6kAutomated safety check: PassGPL-3.0
Database FundamentalsDanielPodolsky/ownyourcode2901 repos~1.6kAutomated safety check: PassMIT
Database Expertcin12211/orca-q224—~2.8kAutomated safety check: PassMIT

Similar skills

  • Datamodellm

    nimbalyst/nimbalyst

    Create visual data models for database schemas using Nimbalyst's DataModelLM editor.

    1.9k GitHub stars~713 tokensUpdated today
    DatabasesAuto-check passed
  • Prisma Expert

    davila7/claude-code-templates

    Prisma ORM expert for schema design, migrations, query optimization, relations modeling, and database operations.

    33k GitHub starsUsed in 7 repos~2.6k tokens
    DatabasesAuto-check passed
  • Prisma Helper

    shepherdjerred/monorepo

    Prisma ORM for type-safe database access - schema design, migrations, queries, relations, and connection management When user works with Prisma, database schemas, migrations, Prisma Client queries…

    112 GitHub stars~3.6k tokensUpdated yesterday
    DatabasesAuto-check passed
  • Database Fundamentals

    DanielPodolsky/ownyourcode

    Reviews schema design, SQL queries, ORM patterns. An agent skill from DanielPodolsky/ownyourcode.

    290 GitHub starsUsed in 1 repo~1.6k tokens
    DatabasesAuto-check passed
  • Database Expert

    cin12211/orca-q

    Database performance optimization, schema design, query analysis, and connection management across PostgreSQL, MySQL, MongoDB, and SQLite with ORM integration.

    224 GitHub stars~2.8k tokensUpdated 19 days ago
    DatabasesAuto-check passed
  • Database Migration

    agulli/atlas-agents

    Safely run database schema migrations. An agent skill from agulli/atlas-agents.

    579 GitHub stars~702 tokensUpdated 2 mo ago
    DatabasesAuto-check passed

More from jeremylongshore/tons-of-skills-marketplace

All 3,342 skills in this repo
  • Performing Security Code Review

    jeremylongshore/tons-of-skills-marketplace

    Execute this skill enables AI assistant to conduct a security-focused code review using the security-agent plugin.

    2.8k GitHub starsUsed in 2 repos~1.3k tokens
    Auto-check: notes
  • Adapting Transfer Learning Models

    jeremylongshore/tons-of-skills-marketplace

    Build this skill automates the adaptation of pre-trained machine learning models using transfer learning techniques.

    2.8k GitHub stars~1.1k tokensUpdated today
    Auto-check passed
  • Agent Context Loader

    jeremylongshore/tons-of-skills-marketplace

    Execute proactive auto-loading: automatically detects and loads agents.md files.

    2.8k GitHub stars~1.1k tokensUpdated today
    Auto-check passed
  • Aggregating Performance Metrics

    jeremylongshore/tons-of-skills-marketplace

    Aggregate and centralize performance metrics from applications, systems, databases, caches, and services.

    2.8k GitHub stars~1.2k tokensUpdated today
    Auto-check passed
  • Analyzing Capacity Planning

    jeremylongshore/tons-of-skills-marketplace

    Execute this skill enables AI assistant to analyze capacity requirements and plan for future growth.

    2.8k GitHub stars~947 tokensUpdated today
    Auto-check passed
  • Analyzing Database Indexes

    jeremylongshore/tons-of-skills-marketplace

    Process use when you need to work with database indexing. An agent skill from jeremylongshore/tons-of-skills-marketplace.

    2.8k GitHub stars~2k tokensUpdated today
    Auto-check passed

Works with

Categories

Questions about Flux Schema

What does Flux Schema do?

Design and build database schema — tables, columns, types, indexes, constraints, relationships. Flux Schema is an agent skill from jeremylongshore/tons-of-skills-marketplace. Design and build database schema — tables, columns, types, indexes, constraints, relationships.

When should I use Flux Schema?

Flux Schema fits situations like: asked to design schema; database design.

How do I install Flux Schema in Claude Code?

Run `npx skills add jeremylongshore/tons-of-skills-marketplace --skill flux-schema -a claude-code`. Or copy the skill folder (plugins/ai-agency/tonone/skills/flux-schema in jeremylongshore/tons-of-skills-marketplace) into .claude/skills/flux-schema in your project. Claude Code loads it when a task matches its description.

How do I install Flux Schema in Codex?

Run `npx skills add jeremylongshore/tons-of-skills-marketplace --skill flux-schema -a codex`. Or copy the skill folder (plugins/ai-agency/tonone/skills/flux-schema in jeremylongshore/tons-of-skills-marketplace) into .agents/skills/flux-schema in your project. Codex loads it when a task matches its description.

Can I use Flux Schema in Cursor, Gemini CLI or GitHub Copilot?

Cursor, Gemini CLI, GitHub Copilot and OpenCode also load SKILL.md folders. With the skills CLI, run `npx skills add jeremylongshore/tons-of-skills-marketplace --skill flux-schema -a cursor` (or -a gemini-cli, github-copilot or opencode for the others). To copy it by hand, put the folder in .cursor/skills/flux-schema, .gemini/skills/flux-schema, .github/skills/flux-schema and .opencode/skills/flux-schema in your project.

What does Flux Schema need to run?

SKILL.md names no scripts, command-line tools or credentials: Flux Schema is instructions for the agent only. Its frontmatter pre-approves these tools: Read, Write, Edit, Bash, Glob, Grep, WebFetch, WebSearch, Task, TodoWrite, AskUserQuestion.

Does Flux Schema access the network?

SKILL.md contains no URLs. Any network use would come from the scripts or tools the agent runs. This is read from the text; nothing was executed.

Is Flux Schema safe to install?

Our automated static check of SKILL.md found notes only (mentions a .env file; pre-approves every shell command (allowed-tools: bash)), nothing it rates as a warning. It is not a guarantee. Review the folder before installing.

What licence does Flux Schema use?

Flux Schema is published under the MIT licence (declared in SKILL.md). It allows redistribution, so the full SKILL.md is shown on this page.

How many tokens does Flux Schema use?

About 1.2k tokens (SKILL.md is roughly 4.8k characters). Agents keep only the skill's name and description in context until a task matches; then they load SKILL.md in full.

What are the alternatives to Flux Schema?

Skills that share tags, products or a category with Flux Schema: Datamodellm (nimbalyst/nimbalyst, 1.9k stars), Prisma Expert (davila7/claude-code-templates, 33k stars), Prisma Helper (shepherdjerred/monorepo, 112 stars) and Database Fundamentals (DanielPodolsky/ownyourcode, 290 stars). The comparison table on this page puts their stars, adoption, token cost, safety result and licence side by side.

Who maintains Flux Schema?

jeremylongshore (a GitHub user) maintains it in jeremylongshore/tons-of-skills-marketplace, which has 2,827 GitHub stars. The repository holds 3,342 skills in this directory. The repository was last updated on October 10, 2026.

Source: jeremylongshore/tons-of-skills-marketplace on GitHub. Facts on this page come from the repository at the commit we read; the author's words are quoted as theirs.