mirror of
https://github.com/wesammustafa/opencode-primer.git
synced 2026-11-18 18:04:22 +00:00
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.
777 B
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_indexesfirst - Co-locate non-trivial data migrations with schema migrations
- Run destructive migrations without backup confirmation