mirror of
https://github.com/wesammustafa/opencode-primer.git
synced 2026-11-20 12:23:15 +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.
27 lines
777 B
Markdown
27 lines
777 B
Markdown
# 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](../system-prompts/database-engineer-prompt.md)
|