AGENT SKILL

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

  1. Understand the model. Read existing schema, migrations, and ORM config.
  2. Design or change schema. Use migrations; never edit schema directly in production.
  3. Review queries. Check indexes, N+1, transactions, and locks.
  4. Run migrations locally. Verify roll-forward and roll-back.
  5. Validate data. Seed, constraints, and referential integrity.
  6. 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

Leostruka
Leostruka/devin-bundle

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.

★ 0
Leostruka
Leostruka/devin-bundle

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.

★ 0
Leostruka
Leostruka/devin-bundle

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.

★ 0
Leostruka
Leostruka/devin-bundle

demo

Use when demonstrating a skill in a fixture project.

★ 0
Leostruka
Leostruka/devin-bundle

duplicate-skill

Use when testing duplicate skill name detection.

★ 0
Leostruka
Leostruka/devin-bundle

duplicate-skill

Use when testing duplicate skill name detection.

★ 0