Postgres Expert — Development agent for Claude Code
Optimizes Postgres schemas, migrations, and queries with a focus on performance, reliability, and maintainability.
How to install Postgres Expert
Installs to ~/.claude/agents/nickcrew-claude-cortex-postgres-expert.md
mkdir -p ~/.claude/agents && curl -fsSL https://raw.githubusercontent.com/NickCrew/Claude-Cortex/HEAD/agents/postgres-expert.md -o ~/.claude/agents/nickcrew-claude-cortex-postgres-expert.md Restart Claude Code, or start a new session, for it to be picked up.
What Postgres Expert does
version: 2.0 name: postgres-expert alias:
- postgresql-expert summary: PostgreSQL specialist for schema design, indexing, and query tuning. description: Optimizes Postgres schemas, migrations, and queries with a focus on performance, reliability, and maintainability. category: data-ai tags:
- postgres
- sql
- database
- performance
tier:
id: extended
conditions:
- '**/*.sql'
- '/migrations/'
- '**/schema.sql' model: preference: sonnet fallbacks:
- haiku
Alternatives in Development
- SLO Implement — You are an SLO (Service Level Objective) expert specializing in implementing reliability standards a... - wsho 31.9k ★
- Civitai Perf Review — Reviews a feature segment in the main Civitai Next.js app (src/) for production performance — N+1 queries, uni 7.2k ★
- Learning Guide — Teach programming concepts and explain code with focus on understanding through progressive learning and pract 1.5k ★
Full documentation available on GitHub
View Source RepositoryRelated Agents
DB Reviewer
Reviews SQLAlchemy models, queries, and Alembic migrations for Postgres performance and safety. Use after mode
Backend Implementor Specialist
Use this agent to implement BACKEND work — routes, controllers, services, schemas, migrations, workers, queues
DB Executor
Internal dynos-work agent. Implements schema changes, migrations, ORM models, and queries. Spawned only by the
Hatch3r Maintainability
Maintainability quality specialist — reviews generated code for duplication index, pattern reuse, cyclomatic c
Perf Optimizer
Optimizes ported code for 68k hardware performance. Knows instruction timing, CHIP/FAST RAM characteristics, c
Performance
Optimizes system performance, speed, and efficiency across all layers of the application
Related Skills
Database Optimizer
Optimize SQL queries, design efficient indexes, and handle database migrations. Solves N+1 problems, slow quer
DB Opt
Identifies and optimizes slow database queries and schema bottlenecks.
Migration Audit
Safety review of pending Supabase / Postgres migrations: destructive ops, locking impact on large tables, miss