database
Use when the user wants to design, migrate, query, or optimize a database. Covers schema design, migrations, query review, indexing, and data integrity.
- License 许可
- MIT
- 最近更新
- 2026-11-15
- Stars
- ★ 0
- Forks
- 1
01 前言 Front Matter
- name
- database
- triggers
- [ "user" ]
- description
- Use when the user wants to design, migrate, query, or optimize a database. Covers schema design, migrations, query review, indexing, and data integrity.
03 SKILL.md 正文
Database
Database design, migrations, and query optimization.
When to use
- New schema or migration is needed.
- Query is slow or returns wrong results.
- Data integrity or constraints must be added.
- Backup/restore or seeding is required.
Core protocol
- Understand the model. Read existing schema, migrations, and ORM config.
- Design or change schema. Use migrations; never edit schema directly in production.
- Review queries. Check indexes, N+1, transactions, and locks.
- Run migrations locally. Verify roll-forward and roll-back.
- Validate data. Seed, constraints, and referential integrity.
- Document. Update migration log and schema docs.
See also
data-analyst— SQL-first data exploration and charts.database— schema design, migrations, and query optimization.
Output rule
- After schema changes, run migration tests and a sample query plan.
- Commit migration files and update CHANGELOG.
04 同仓库更多 Skills
montador-de-ideias
Use when assembling, expanding, or elevating a raw project idea or initial prompt into an ultra-detailed, first-principles dossier and compiled master prompt with journalistic OSINT market research, Tech Lead and Staff Architect justifications, atomic and modular hardening/optimization, and high-impact contact surfaces.
git-github-adaptive-engineering
Use when any task touches git history, GitHub issues/PRs/releases/CI, repo governance, or branch and merge decisions. Runs the Fase Zero situational-awareness battery, picks one of five delivery flows via the adaptive decision engine, and enforces commit/PR information-density standards. Orchestrates the gh, git-workflows, github-actions, pr, and debug/finish skills.
adaptive-agenda-calendar-routine-engine
Use when planning or executing work across hours, days, weeks, or sprints. Turns the calendar into a strict time-blocked agenda (HH:MM-HH:MM blocks carrying a routine profile, expected inputs, and a handoff output artifact), runs the 5-stage cognitive flow (Radar and Hunt -> Triage plus Steve Jobs conception -> workbench manifest -> >=32-cycle loop -> Close plus Open-Minded Scrum), and unfolds macro calendar milestones into micro agenda blocks through extensions/gcal/wrapper.py.
demo
Use when demonstrating a skill in a fixture project.
duplicate-skill
Use when testing duplicate skill name detection.
duplicate-skill
Use when testing duplicate skill name detection.