Automated summary
Governs changes to the schema, migrations, and PostgreSQL repositories of the re-RAG review project, requiring bootstrap schema and migrations to stay in sync.
Strengths
- Requires idempotent migrations kept consistent with the bootstrap schema (review_schema.sql)
- Keeps SQL mapping logic inside repositories and mappers rather than API or MCP layers
- Mandates unit tests for schema text, migration ordering, and repository edge cases
- Adds PostgreSQL integration coverage when database semantics cannot be proven by unit tests alone
- Finishes with focused database tests and make ci-local before handoff
Limitations
- Tightly coupled to one repository layout (pubtator_link, make ci-local, AGENTS.md) and not directly reusable elsewhere
- Does not cover rollback/downgrade migrations, zero-downtime strategies, or data backfills
Use it whenever a task touches the database schema, a migration, or PostgreSQL repository behavior in this project.
Skip it for purely application-level or front-end changes that do not affect schema, migrations, or data access.
Security analysis
SafeThe skill provides guidance for database migration tasks without instructing any destructive, exfiltrating, or obfuscated actions. It only references inspecting files, running tests, and using make ci-local, which are standard development practices.
No concerns found
How this analysis is madeExamples
Add a migration that introduces a new `review_run` table to the re-RAG schema, make it idempotent, keep it consistent with review_schema.sql, and add unit tests for schema text and migration ordering.The review repository mapper returns wrong field values for nullable columns — move the SQL mapping into the repository/mapper layer and add edge-case unit tests plus PostgreSQL integration coverage.Run the focused database tests for the migration changes I just made, then run make ci-local and report any failures.name: database-migration description: Use when changing review re-RAG schema, repositories, migrations, or PostgreSQL integration behavior.
Database Migration
Follow AGENTS.md first.
Workflow
- Inspect
pubtator_link/db/review_schema.sql, existing migrations, and repository tests before editing schema code. - Make migrations idempotent and keep bootstrap schema and migrations consistent.
- Keep SQL mapping logic in repository/mappers, not API or MCP layers.
- Add or update unit tests for schema text, migration ordering, mapper behavior, and repository edge cases.
- Add PostgreSQL integration coverage when the behavior depends on database semantics that unit tests cannot prove.
- Run focused database tests, then
make ci-localbefore handoff.
From the file to a first result
The download contains exactly the content displayed on this page. This copy may differ from the latest version in the source repository.
View the source and supporting filesThis download contains SKILL.md only. Any scripts, references, templates and dependencies are not included. Get the required files from the source, preserving their directory structure, before continuing.
1. Download the file
Download SKILL.mdFrom the root of a test project, save the file as .skill-downloads/database-migration-mrwak9zu/SKILL.md, or use the command below. This folder is for inspecting the skill before installation.
Command for macOS/Linux or WSL: requires a POSIX shell and curl. On Windows without WSL, use the download button and create the folder manually.
mkdir -p '.skill-downloads/database-migration-mrwak9zu' && curl --fail --show-error --location 'https://skills-guides.com/api/skills/database-migration-mrwak9zu/download' --output '.skill-downloads/database-migration-mrwak9zu/SKILL.md.part' && mv '.skill-downloads/database-migration-mrwak9zu/SKILL.md.part' '.skill-downloads/database-migration-mrwak9zu/SKILL.md'2. Check prerequisites
Read SKILL.md before using it. If it references scripts or external services, inspect them and prepare the required access in your test environment.
No recognized prerequisites section in this file. This does not mean it is self-contained: libraries, tools and access requirements may be mentioned elsewhere in the content or source repository.
The platforms on this page are catalog indications. The paths below follow tool documentation; they do not prove this skill has been run in those tools. No minimum tool version is confirmed for this listing.
3. Load the skill
After inspection, copy the complete folder into your project using one of the commands below, then open a new tool session. The command stops if a folder with the same name already exists: compare the files before replacing it.
Claude Code
test -f '.skill-downloads/database-migration-mrwak9zu/SKILL.md' && test -s '.skill-downloads/database-migration-mrwak9zu/SKILL.md' && mkdir -p '.claude/skills' && test ! -e '.claude/skills/database-migration' && cp -R '.skill-downloads/database-migration-mrwak9zu' '.claude/skills/database-migration'Cursor
test -f '.skill-downloads/database-migration-mrwak9zu/SKILL.md' && test -s '.skill-downloads/database-migration-mrwak9zu/SKILL.md' && mkdir -p '.cursor/skills' && test ! -e '.cursor/skills/database-migration' && cp -R '.skill-downloads/database-migration-mrwak9zu' '.cursor/skills/database-migration'Codex
test -f '.skill-downloads/database-migration-mrwak9zu/SKILL.md' && test -s '.skill-downloads/database-migration-mrwak9zu/SKILL.md' && mkdir -p '.agents/skills' && test ! -e '.agents/skills/database-migration' && cp -R '.skill-downloads/database-migration-mrwak9zu' '.agents/skills/database-migration'OpenSkills
OpenSkills must already be installed. The local install/read procedure is checked with OpenSkills 1.5.0, which requires Node.js ≥ 20.6.0. Catalog slugs are not resolved automatically.
Official OpenSkills installationopenskills install './.skill-downloads/database-migration-mrwak9zu'openskills read 'database-migration-mrwak9zu'Reading should display the installed file content and its base directory. It does not run the skill or install its dependencies.
For an agent that reads AGENTS.md, then sync the index. This command changes AGENTS.md: review the diff before using it.
openskills syncManual method or another tool: attach SKILL.md to a conversation, or open it in an agent that can read files. Include any required supporting resources. No universal folder is recognized by every tool.
4. Try a first task
Use a short, synthetic input: an API endpoint, a small document or an interface brief. In a new conversation, attach the file or give the agent its path, then adapt this request:
Read .skill-downloads/database-migration-mrwak9zu/SKILL.md and apply its instructions to this example: [describe a test input]. Identify any missing files, dependencies or access. Produce the result requested by the skill without inventing data or running unreviewed scripts.Expected result: output matching the skill instructions, or a precise list of missing prerequisites. A read confirmation alone does not validate a first use. If an external resource is unavailable, that path remains untested.
React Hook Form Best Practices
Development
Master React Hook Form: avoid anti-patterns, manage subscriptions, and handle reset, dirty state, and controlled inputs correctly.
Emotion to Mantine Migration
Development
Migrate Emotion styled-components to Mantine components with style props and CSS modules. Use when converting .styled.tsx files or removing @emotion imports.
Scope Creep Detector
Development
Analyzes git diffs against a stated intent to detect scope creep, unrelated files, broad PRs, and oversized changes, then suggests keep, split, or justify actions.