Skip to main content
6 specialized agents covering API architecture, database design, and data layer optimization.

​
Agents

API Architect

REST API architecture, design patterns, and developer guidance
  • Mode: subagent
  • Quality: 4.75/5 (Excellent)
  • Tags: api, rest, architecture, design, http, openapi
npx github:dmicheneau/opencode-template-agent install api-architect

GraphQL Architect

GraphQL schema design, federation, and query performance optimization
  • Mode: subagent
  • Quality: 4.88/5 (Excellent)
  • Tags: graphql, federation, schema, api, query-optimization
npx github:dmicheneau/opencode-template-agent install graphql-architect

Database Architect

Database design, data modeling, scalability, and technology selection
  • Mode: subagent
  • Quality: 4.50/5 (Excellent)
  • Tags: database, data-modeling, scalability, schema, architecture
npx github:dmicheneau/opencode-template-agent install database-architect

PostgreSQL Pro

PostgreSQL performance optimization, replication, and query tuning
  • Mode: subagent
  • Quality: 4.50/5 (Excellent)
  • Tags: postgresql, database, sql, replication, performance, query-tuning
npx github:dmicheneau/opencode-template-agent install postgres-pro

Redis Specialist

Redis caching, data structures, pub/sub, clustering, and performance
  • Mode: subagent
  • Quality: 4.88/5 (Excellent)
  • Tags: redis, caching, pub-sub, clustering, streams, performance
npx github:dmicheneau/opencode-template-agent install redis-specialist

SQL Pro

Vendor-agnostic SQL specialist for query optimization, schema design, migrations, and performance tuning
  • Mode: subagent
  • Quality: 4.50/5 (Excellent)
  • Tags: sql, postgresql, mysql, sqlite, query-optimization, schema-design
npx github:dmicheneau/opencode-template-agent install sql-pro

​
Usage Examples

@data-api/api-architect Review this REST API design

​
Quality Stats

  • Average score: 4.67/5
  • All agents: Excellent rating
  • Total tokens: ~8,500 (avg ~1,410 per agent)
  • Coverage: REST, GraphQL, SQL, NoSQL, caching

​
Common Workflows

Complete backend with database + API + caching:
npx github:dmicheneau/opencode-template-agent install --pack backend
Includes: postgres-pro, redis-specialist, database-architect, api-architect, python-pro, typescript-pro, debugger, test-automator
Full data engineering + analytics:
npx github:dmicheneau/opencode-template-agent install --pack data-stack
Includes: data-engineer, data-analyst, data-scientist, database-architect, postgres-pro, sql-pro
Design and implement robust APIs:
  1. Database Architect — Design schema
  2. API Architect or GraphQL Architect — Design API layer
  3. PostgreSQL Pro or SQL Pro — Optimize queries
  4. Redis Specialist — Add caching layer

​
When to Use

  • Designing RESTful APIs
  • Implementing API versioning
  • Defining OpenAPI specifications
  • Establishing API conventions
  • Building GraphQL APIs
  • Implementing schema federation
  • Optimizing resolver performance
  • Designing type-safe schemas
  • Selecting database technology
  • Designing data models
  • Planning for scale (sharding, partitioning)
  • Multi-tenant architecture
  • Optimizing slow queries
  • Setting up replication
  • Tuning database configuration
  • Implementing advanced PostgreSQL features
  • Implementing caching strategies
  • Using Redis data structures (streams, sorted sets)
  • Building pub/sub systems
  • Setting up Redis clustering
  • Working across multiple SQL databases
  • Writing complex queries
  • Optimizing query performance
  • Database migrations

Build docs developers (and LLMs) love

Get started for freeTalk to us