Postgres Architect — Data & AI agent for Claude Code
Postgres data specialist — schema design, normalization, indexing, constraints, migrations, and performant SQL.
How to install Postgres Architect
Installs to ~/.claude/agents/ap-justin-team-justin-postgres-architect.md
mkdir -p ~/.claude/agents && curl -fsSL https://raw.githubusercontent.com/ap-justin/team-justin/HEAD/agents/postgres-architect.md -o ~/.claude/agents/ap-justin-team-justin-postgres-architect.md Restart Claude Code, or start a new session, for it to be picked up.
What Postgres Architect does
name: postgres-architect description: Postgres data specialist — schema design, normalization, indexing, constraints, migrations, and performant SQL. Hands a typed query surface to the framework builder. Use when a feature needs persistence, a data model, query optimization, or migration work. Postgres-the-server only — an embedded SQLite `.db` file is `sqlite-architect`'s lane, Cloudflare D1 is `cloudflare-builder`'s. model: claude-opus-5
You are a Postgres specialist. You own the data
Alternatives in Data & AI
- Gaia Agent Builder — GAIA agent creation specialist 1.5k ★
- Migration Agent — Creates safe, reversible database migrations with proper indexes, constraints, and zero-downtime strategies 652 ★
- Patina Detector — Triggers when Claude needs to find AI-writing patterns or suspect zones in KO/EN/ZH/JA text 352 ★
Full documentation available on GitHub
View Source RepositoryRelated Agents
Supabase Substrate Explorer
Specialist research agent for discovering creative, non-obvious applications of the Supabase SUBSTRATE dimensi
Zanix Remote API App Builder
Stands up a brand-new @zanix/space consumer app that owns no database of its own and presents a UI over a remo
DB Postgres Expert
Expert PostgreSQL DBA for pure PostgreSQL environments. Use for database design, query optimization, indexing
Data SQL
Use PROACTIVELY and automatically — do not wait to be asked — for SQL/data-pipeline work on the operator's loc
Viz Frontend
Use when experiment data needs a custom dashboard, comparison surface, or trajectory viewer.
Pipeline Builder
Designs end-to-end football data pipelines. Use when the user describes a goal ('I want to analyse pressing in
Related Skills
Agent Database Architect
Dispatch hub:database-architect — Expert database architect for schema design, query optimization, migrations,
Database Schema
Design database schemas with proper normalization and constraints
Chronicler
Review database schemas, SQL design, migrations, persistence optimization, and constraints.