Postgres Optimizer — Data & AI agent for Claude Code
Use this agent when you need expert PostgreSQL database optimization.
How to install Postgres Optimizer
Installs to ~/.claude/agents/tstapler-dotfiles-postgres-optimizer.md
mkdir -p ~/.claude/agents && curl -fsSL https://raw.githubusercontent.com/tstapler/dotfiles/HEAD/.claude/agents/postgres-optimizer.md -o ~/.claude/agents/tstapler-dotfiles-postgres-optimizer.md Restart Claude Code, or start a new session, for it to be picked up.
What Postgres Optimizer does
name: postgres-optimizer description: Use this agent when you need expert PostgreSQL database optimization, schema design review, or performance analysis. This agent should be invoked when reviewing DDL, analyzing cardinality, designing indexing strategies, evaluating normalization decisions, or optimizing data access patterns based on established database engineering principles.
You are a PostgreSQL optimization specialist with deep expertise in database performance, schema des
Alternatives in Data & AI
- PostgreSQL Pglite Pro — Role: Senior PostgreSQL and PgLite Engineer specializing in robust database architecture, perfor 1.5k ★
- General Backend Developer — Use this agent proactively when you need to design, implement, or optimize backend API systems, including REST 248 ★
- Data Specialist — Senior data specialist covering exploratory analysis, statistical modeling, machine learning, experimentation 227 ★
Full documentation available on GitHub
View Source RepositoryRelated Agents
Ef Postgres Query Expert
Use this agent when you need to write, optimize, or troubleshoot Entity Framework Core queries against a Postg
DB Postgres Expert
Expert PostgreSQL DBA for pure PostgreSQL environments. Use for database design, query optimization, indexing
Database PostgreSQL
PostgreSQL/Supabase database specialist. Schema design, RLS, query optimization, migrations. Runs on "PostgreS
Postgres Pro
PostgreSQL database expert. Query optimization, index design, schema design, performance tuning, Prisma optimi
Engineering Database Optimizer
Expert database specialist focusing on schema design, query optimization, indexing strategies, and performance
Ad Optimizer
Use this agent when you have analyzed advertising performance data and need to generate optimization recommend
Related Skills
Claude Code Postgres
Query a real PostgreSQL database in plain English from the terminal with Claude Code, safely: read-only role f
Postgres Backup Restore Skill
Claude Code skill for PostgreSQL backup, verification, restore, and cutover — database-agnostic
Postgres
Execute safe read-only SQL queries against PostgreSQL databases with multi-connection support and defense-in-d