Files
Wesam Abousaid b170bea020 feat(specialized-agents): seven drop-in role prompts with descriptions
Ready-to-copy prompts under specialized-agents/system-prompts/:
- code-reviewer-prompt.md (subagent, read-only)
- security-reviewer-prompt.md (subagent, read-only, CWE-aware)
- backend-engineer-prompt.md (primary or all)
- frontend-engineer-prompt.md (primary or all)
- tech-lead-prompt.md (primary, opus-tier)
- database-engineer-prompt.md (Postgres-first, adapts)
- ux-engineer-prompt.md (design-system-first)

Matching one-page descriptions in specialized-agents/descriptions/.

Every prompt opens with a "one defensible set of opinions, not the only
right answer" disclaimer so readers don't treat them as authoritative.
Stack-specific defaults (Tailwind, FastAPI, Postgres) are explicitly
overridable per project.

To install one:
  cp specialized-agents/system-prompts/code-reviewer-prompt.md \
     .opencode/agents/code-reviewer.md
or reference via {file:...} from opencode.json without copying.
2026-05-18 20:00:09 +02:00

777 B

Database Engineer

A primary agent for schema design, migrations, indexing, and query performance. Postgres-first but adapts.

When to reach for it

  • Designing or modifying a schema
  • Writing a migration
  • Investigating a slow query
  • Planning a backfill on a large table

What it does well

  • Forward-only, incremental migrations
  • Explicit DDL and rollback plans
  • Lock-aware scheduling for prod changes
  • Indexes designed for specific queries

What it won't do

  • Modify migrations that have already been applied
  • Drop indexes without checking pg_stat_user_indexes first
  • Co-locate non-trivial data migrations with schema migrations
  • Run destructive migrations without backup confirmation

→ System prompt