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
- Migration Agent — Creates safe, reversible database migrations with proper indexes, constraints, and zero-downtime strategies 652 ★
- Bm Framework Selector — Presents an interactive decision matrix to surface the right AI/LLM framework for the user's specific use case 92 ★
- Feature Builder Data — Implementuje warstwę danych (zapytania Supabase, RLS policies, migracje SQL, walidacja Zod, Edge Functions, au 76 ★
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
Mapbox Esri Layer Builder
Use this agent when the user needs to integrate Esri map data with Mapbox, create map layers, or build mapping
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
Supabase Agent
Owns supabase/ — migrations, schema, constraints, RLS policies, Postgres functions for batch writes, and regen
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
Related Skills
Database Schema
Design database schemas with proper normalization and constraints
Chronicler
Review database schemas, SQL design, migrations, persistence optimization, and constraints.
Embedded Database
SQLite and DuckDB as application-embedded databases at production scale - PRAGMA discipline, schema migrations