New: 98,000+ skills indexed from GitHub repos with 100+ stars · every skill safety-checkedBrowse top skillsTop skills
Esc to closeBrowse all skills
Submit a skillBrowse skills
Submit a skillBrowse skills

Agent skill

Fantasia Flatten Database Schemas

by vishiri in vishiri/fantasia-archive

Collapses .faproject SQLite PRAGMA userversion ladders into a single bootstrap schema (procedure sets max to 1) during pre-release dev resets.

GPL-3.0Auto-check passedDatabases

Install Fantasia Flatten Database Schemas

skills CLI
$ npx skills add vishiri/fantasia-archive --skill fantasia-flatten-database-schemas -a claude-code

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

GitHub CLI
$ gh skill install vishiri/fantasia-archive fantasia-flatten-database-schemas --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/vishiri/fantasia-archive.git skills-src && mkdir -p .claude/skills && cp -r skills-src/.cursor/skills/fantasia-flatten-database-schemas .claude/skills/fantasia-flatten-database-schemas && 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
fantasia-flatten-database-schemas
GitHub stars
409
Token cost
~653 tokens
SKILL.md length
203 words
Files
1
Skills in repo
35
Repo updated
First seen
Licence
GPL-3.0

At a glance

Collapses .faproject SQLite PRAGMA userversion ladders into a single bootstrap schema (procedure sets max to 1) during pre-release dev resets.

  • Works in 8 steps: Read docs/database/projectDB.md; list… → Merge DDL into faProjectDbSchemaDdl.ts… → Simplify faProjectDbMigrateWiring.ts —… → …
  • The user asks to flatten database schemas
  • SKILL.md covers When to use, Live repo today, Target after flatten… and Flatten procedure (checklist), plus 3 more sections
  • Calls yarn

What it does

Fantasia Flatten Database Schemas is an agent skill from vishiri/fantasia-archive. Collapses .faproject SQLite PRAGMA userversion ladders into a single bootstrap schema (procedure sets max to 1) during pre-release dev resets. Use when the user asks to flatten database schemas, reset migrations, or squash schema versions before wider release.

Its SKILL.md is about 650 tokens, which your agent loads only when the skill is triggered. It is a single SKILL.md file with no bundled scripts.

It sits in Databases, covering Database schema design. It works with SQLite. The repository describes itself as: A world-builder's best friend! The licence is GPL-3.0.

When your agent uses it

  • The user asks to flatten database schemas
  • Reset migrations
  • Squash schema versions before wider release

Example prompts

  • “Use the fantasia-flatten-database-schemas skill to collapse .faproject SQLite PRAGMA userversion ladders into a single bootstrap schema (procedure…”
  • “/fantasia-flatten-database-schemas”

Workflow steps

8 steps, taken from the first numbered list in SKILL.md.

  1. Read docs/database/projectDB.md; list tables/columns/indexes to keep
  2. Merge DDL into faProjectDbSchemaDdl.ts (applyFaProjectProjectDataSchemaV1, applyFaProjectContentSchemaV1)
  3. Simplify faProjectDbMigrateWiring.ts — max version 1, remove legacy steps
  4. Delete obsolete migration-only helpers
  5. Rewrite _tests/faProjectDbMigrate.vitest.test.ts; update DDL tests
  6. Docs: projectDB.md, templateCustomFields.md, AGENTS.md, README.md if needed
  7. Changelog: older dev .faproject must be recreated (current package.json version only)
  8. Full yarn testbatch:verify before commit (schema squash touches electron + docs + broad tests)

What it can do on your machine

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

  • Tool permissions

    Pre-approves nothing: there is no allowed-tools line, so your agent's usual permission prompts apply.

    From allowed-tools in the SKILL.md frontmatter.

  • Runs code

    Shell commands in SKILL.md call:

    • yarn

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

  • Network

    No URLs in SKILL.md. Its commands use yarn, which can reach the network depending on how they are called.

    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

Fantasia Flatten Database Schemas loads about 653 tokens when it runs. Until then it costs about 74 tokens; SKILL.md has 203 words of instructions outside code blocks.

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

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 passed

The automated check found no risky patterns in SKILL.md.

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 vishiri/fantasia-archive at commit 26d4648, republished under its GPL-3.0 licence (© vishiri). 203 words, ~653 tokens.

Download SKILL.mdSave it as .claude/skills/fantasia-flatten-database-schemas/SKILL.md (or your agent's skills folder).
name
fantasia-flatten-database-schemas
description
Collapses .faproject SQLite PRAGMA user_version ladders into a single bootstrap schema (procedure sets max to 1) during pre-release dev resets. Use when the user asks to flatten database schemas, reset migrations, or squash schema versions before wider release.

Flatten database schemas (.faproject)

When to use

  • Pre-release / dev-only resets when incremental migrations not worth keeping
  • User explicitly asks to flatten or squash migrations
  • Do not flatten after public release without migration strategy for user data

Live repo today

  • Supported max FA_PROJECT_USER_VERSION_SUPPORTED_MAX = 6 — projectDB.md
  • Flatten = dev procedure that resets ladder to bootstrap 1 (below), not current shipped state

Target after flatten (procedure outcome)

  • PRAGMA user_version 1 only shipped revision
  • FA_PROJECT_USER_VERSION_SUPPORTED_MAX = 1 in faProjectDbMigrateWiring.ts
  • Fresh: 0 → bootstrap → 1 + default world seed
  • At 1: applyFaProjectMigrations no-op (or idempotent patches only)
  • Other versions: unsupported (throws)

Flatten procedure (checklist)

  1. Read docs/database/projectDB.md; list tables/columns/indexes to keep
  2. Merge DDL into faProjectDbSchemaDdl.ts (applyFaProjectProjectDataSchemaV1, applyFaProjectContentSchemaV1)
  3. Simplify faProjectDbMigrateWiring.ts — max version 1, remove legacy steps
  4. Delete obsolete migration-only helpers
  5. Rewrite _tests/faProjectDbMigrate.vitest.test.ts; update DDL tests
  6. Docs: projectDB.md, templateCustomFields.md, AGENTS.md, README.md if needed
  7. Changelog: older dev .faproject must be recreated (current package.json version only)
  8. Full yarn testbatch:verify before commit (schema squash touches electron + docs + broad tests)

Adding migrations again (after flatten)

  1. Bump FA_PROJECT_USER_VERSION_SUPPORTED_MAX
  2. Add applyFaProjectContentSchemaV2 or migrateProjectDataV1ToV2
  3. Chain in applyFaProjectMigrations
  4. Update projectDB.md + tests

No long historical ladder unless real user upgrades require it.

Types

Shared types → types/. See types-folder.mdc.

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

Files

Just SKILL.md in .cursor/skills/fantasia-flatten-database-schemas of vishiri/fantasia-archive.

Open the folder on GitHubat commit 26d4648

Compare with similar skills

Fantasia Flatten Database Schemas 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.

Fantasia Flatten Database Schemas compared with similar skills
SkillStarsUsed inTokensAuto-checkLicenceRepo updated
Fantasia Flatten Database Schemas this skillvishiri/fantasia-archive409—~653Automated safety check: PassGPL-3.0
Sqlite Schema Designfastrepl/anarlog9.5k—~1.9kAutomated safety check: PassMIT
Sqlite Map Parserbenchflow-ai/skillsbench1.8k—~1kAutomated safety check: PassApache-2.0
Add Memory KindEverMind-AI/EverOS13k—~2.6kAutomated safety check: PassApache-2.0
Cursor BYOK Database Schemaleookun/cursor-byok3.2k—~1.3kAutomated safety check: PassMIT
Golang Databaseunxed/f42442 repos~2.9kAutomated safety check: PassMIT

Similar skills

  • Sqlite Schema Design

    fastrepl/anarlog

    Design or review schemas for crates/cloudsync using SQLite Sync constraints, not generic SQLite advice.

    9.5k GitHub stars~1.9k tokensUpdated today
    DatabasesAuto-check passed

  • Sqlite Map Parser

    benchflow-ai/skillsbench

    Parse SQLite databases into structured JSON data. An agent skill from benchflow-ai/skillsbench.

    1.8k GitHub stars~1k tokensUpdated 2 mo ago
    DatabasesAuto-check passed

  • Add Memory Kind

    EverMind-AI/EverOS

    Walks through adding a new persisted memory kind to EverOS: choose storage among Markdown, SQLite and LanceDB, pick a Markdown strategy, then wire schemas, repos and writers.

    13k GitHub stars~2.6k tokensUpdated yesterday
    DatabasesAuto-check passed

  • Cursor BYOK Database Schema

    leookun/cursor-byok

    Guides SQLite schema changes in the Cursor BYOK server, keeping SQLx migrations, the Rust store, API contracts and fixtures aligned.

    3.2k GitHub stars~1.3k tokensUpdated 2 days ago
    DatabasesAuto-check passed

  • Golang Database

    unxed/f4

    Comprehensive guide for Go database access — parameterized queries, struct scanning, NULLable columns, transactions, isolation levels, SELECT FOR UPDATE, connection pool, batch processing, context…

    244 GitHub starsUsed in 2 repos~2.9k 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

More from vishiri/fantasia-archive

All 35 skills in this repo

  • Caveman Commit

    vishiri/fantasia-archive

    Ultra-compressed commit message generator. An agent skill from vishiri/fantasia-archive.

    409 GitHub starsUsed in 13 repos~642 tokens
    Auto-check passed

  • Caveman Review

    vishiri/fantasia-archive

    Ultra-compressed code review comments. An agent skill from vishiri/fantasia-archive.

    409 GitHub starsUsed in 12 repos~674 tokens
    Auto-check passed

  • Caveman Compress

    vishiri/fantasia-archive

    Compress natural language memory files (CLAUDE.md, todos, preferences) into caveman format to save input tokens.

    409 GitHub starsUsed in 9 repos~1.1k tokens
    Auto-check: notes

  • Cavecrew

    vishiri/fantasia-archive

    Decision guide for delegating to caveman-style subagents. An agent skill from vishiri/fantasia-archive.

    409 GitHub starsUsed in 7 repos~1k tokens
    Auto-check passed

  • Caveman Help

    vishiri/fantasia-archive

    Quick-reference card for all caveman modes, skills, and commands.

    409 GitHub starsUsed in 6 repos~572 tokens
    Auto-check passed

  • Fantasia Context Menu Dividers

    vishiri/fantasia-archive

    Context menu divider policy: full primary-bright group separators vs low-opacity separatorAlt between consecutive items in the same group.

    409 GitHub stars~741 tokensUpdated 3 days ago
    Auto-check passed

Works with

Categories

Questions about Fantasia Flatten Database Schemas

What does Fantasia Flatten Database Schemas do?

Collapses .faproject SQLite PRAGMA userversion ladders into a single bootstrap schema (procedure sets max to 1) during pre-release dev resets. Fantasia Flatten Database Schemas is an agent skill from vishiri/fantasia-archive.faproject SQLite PRAGMA userversion ladders into a single bootstrap schema (procedure sets max to 1) during pre-release dev resets.

When should I use Fantasia Flatten Database Schemas?

Fantasia Flatten Database Schemas fits situations like: the user asks to flatten database schemas; reset migrations; squash schema versions before wider release.

How do I install Fantasia Flatten Database Schemas in Claude Code?

Run `npx skills add vishiri/fantasia-archive --skill fantasia-flatten-database-schemas -a claude-code`. Or copy the skill folder (.cursor/skills/fantasia-flatten-database-schemas in vishiri/fantasia-archive) into .claude/skills/fantasia-flatten-database-schemas in your project. Claude Code loads it when a task matches its description.

How do I install Fantasia Flatten Database Schemas in Codex?

Run `npx skills add vishiri/fantasia-archive --skill fantasia-flatten-database-schemas -a codex`. Or copy the skill folder (.cursor/skills/fantasia-flatten-database-schemas in vishiri/fantasia-archive) into .agents/skills/fantasia-flatten-database-schemas in your project. Codex loads it when a task matches its description.

Can I use Fantasia Flatten Database Schemas 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 vishiri/fantasia-archive --skill fantasia-flatten-database-schemas -a cursor` (or -a gemini-cli, github-copilot or opencode for the others). To copy it by hand, put the folder in .cursor/skills/fantasia-flatten-database-schemas, .gemini/skills/fantasia-flatten-database-schemas, .github/skills/fantasia-flatten-database-schemas and .opencode/skills/fantasia-flatten-database-schemas in your project.

What does Fantasia Flatten Database Schemas need to run?

Going by SKILL.md and its folder, Fantasia Flatten Database Schemas needs the command-line tools its instructions call (yarn).

Does Fantasia Flatten Database Schemas 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 Fantasia Flatten Database Schemas safe to install?

Our automated static check of SKILL.md found no risky patterns, such as piping downloads into a shell, reading credential files or hidden Unicode. It is not a guarantee. Review the folder before installing.

What licence does Fantasia Flatten Database Schemas use?

Fantasia Flatten Database Schemas is published under the GPL-3.0 licence (the repository's licence). It allows redistribution, so the full SKILL.md is shown on this page.

How many tokens does Fantasia Flatten Database Schemas use?

About 653 tokens (SKILL.md is roughly 2.6k 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 Fantasia Flatten Database Schemas?

Skills that share tags, products or a category with Fantasia Flatten Database Schemas: Sqlite Schema Design (fastrepl/anarlog, 9.5k stars), Sqlite Map Parser (benchflow-ai/skillsbench, 1.8k stars), Add Memory Kind (EverMind-AI/EverOS, 13k stars) and Cursor BYOK Database Schema (leookun/cursor-byok, 3.2k stars). The comparison table on this page puts their stars, adoption, token cost, safety result and licence side by side.

Who maintains Fantasia Flatten Database Schemas?

vishiri (a GitHub user) maintains it in vishiri/fantasia-archive, which has 409 GitHub stars. The repository holds 35 skills in this directory. The repository was last updated on October 7, 2026.

Source: vishiri/fantasia-archive on GitHub. Facts on this page come from the repository at the commit we read; the author's words are quoted as theirs.