Menu
Route database tasks to the right library skill. Covers migrations, query optimization, ORM, transactions.
Install with Codex or Claude Copy this prompt, paste it into Codex, Claude, or another assistant, and let it review the skill page and install it for you.
Based on SOC occupation classification
Deterministic AI development workflow orchestrator. Manages task boards (.jonggrang/jonggrang-tasks.json), runs 16-phase pipelines (BUGFIX/SMALL/MEDIUM/LARGE), installs lifecycle hooks for Claude Code and OpenCode, and coordinates five specialist roles (Lead/Developer/Reviewer/TestLead/Tester). Use when planning features, executing multi-step development workflows, or orchestrating AI coding agents. Run via npx jonggrang.
16-phase feature orchestration workflow. Runs in the main thread as Kernel Mode. Coordinates the Lead→Developer→Reviewer→TestLead→Tester assembly line.
Protocol for agents to write structured outputs that survive session resets and are findable by the orchestrator.
GitHub workflow automation with the gh CLI — pull requests, issues, releases, the REST/GraphQL API, and safe message escaping. Auth via GH_TOKEN (set in global settings, attached to the sandbox env).
GitLab workflow automation with the glab CLI — merge requests, issues, CI, releases, and safe message escaping. Auth via GITLAB_TOKEN (set in global settings, attached to the sandbox env).
Prevents premature exit and infinite loops. Three mechanisms: Completion Promises, Scratchpads, Loop Detection.
| name | gateway-database |
| description | Route database tasks to the right library skill. Covers migrations, query optimization, ORM, transactions. |
| type | gateway |
| tier | core |
| domains | ["database","sql","orm"] |
| trigger | SQL, PostgreSQL, MySQL, MongoDB, Redis, Prisma, Drizzle, TypeORM, migration, query, schema, transaction |
You are the Database Gateway. Route database tasks to specialized library skills.
| Intent Keywords | Load Skill |
|---|---|
migration, schema change, alter table, column | skills/library/database/safe-migrations/SKILL.md |
index, query optimize, explain, slow query | skills/library/database/query-optimization/SKILL.md |
transaction, acid, rollback, savepoint | skills/library/database/transactions/SKILL.md |
prisma, drizzle, typeorm, orm, sequelize | skills/library/database/orm-patterns/SKILL.md |
seed, fixture, initial data, populate | skills/library/database/data-seeding/SKILL.md |
backup, restore, disaster recovery, dump | skills/library/database/backup-strategies/SKILL.md |
GATEWAY_DATABASE:
Domain: database
Skills to load:
- [absolute/path/to/SKILL.md]
Instructions: Read the above skill files before proceeding with your task.