domengabrovsek

PostgreSQL Expert — Data & AI agent for Claude Code

Data & AI community

Designs and optimizes PostgreSQL schemas, queries, indexes, and migrations, reasoning from EXPLAIN plans and pg_stat data.

How to install PostgreSQL Expert

Installs to ~/.claude/agents/domengabrovsek-claude-postgresql-expert.md

Terminal
mkdir -p ~/.claude/agents && curl -fsSL https://raw.githubusercontent.com/domengabrovsek/claude/HEAD/agents/postgresql-expert.md -o ~/.claude/agents/domengabrovsek-claude-postgresql-expert.md

Restart Claude Code, or start a new session, for it to be picked up.

What PostgreSQL Expert does

name: PostgreSQL Expert description: Designs and optimizes PostgreSQL schemas, queries, indexes, and migrations, reasoning from EXPLAIN plans and pg_stat data. Use for slow queries, migration safety, index strategy, or lock contention. Pairs with Backend Staff Engineer, who owns the application layer.

PostgreSQL Expert

Role

You reason about PostgreSQL from its internals: the query planner, MVCC, WAL, vacuum, and lock queues. Data integrity and measured query behavior drive every

Alternatives in Data & AI

  • PostgreSQL Pglite Pro — Role: Senior PostgreSQL and PgLite Engineer specializing in robust database architecture, perfor 1.5k ★
  • Migration Agent — Creates safe, reversible database migrations with proper indexes, constraints, and zero-downtime strategies 652 ★
  • Module Migration — Use this agent to create, review, or fix database migrations for LaraDashboard modules — handles table creatio 407 ★

Full documentation available on GitHub

View Source Repository

Related Agents

DB Performance Tuner — Data & AI agent for Claude Code

DB Performance Tuner

Database bottleneck specialist for the Hydraia pipeline. Evidence-first tuning across PostgreSQL, MySQL/MariaD

Data & AI community
DB Designer — Data & AI agent for Claude Code

DB Designer

Use when designing or changing MongoDB schemas - new collections, embedding vs referencing decisions, index st

Data & AI community
DB Schema Expert — Data & AI agent for Claude Code

DB Schema Expert

Use PROACTIVELY for anything touching prisma/schema.prisma, database migrations, raw SQL, slow query optimizat

Data & AI community
SQL Performance Reviewer — Data & AI agent for Claude Code

SQL Performance Reviewer

Use this agent after any change to EF Core queries, repositories, or indexes — before the change ships. Focuse

Data & AI community
Supabase Optimizer — Data & AI agent for Claude Code

Supabase Optimizer

Proactively optimizes Supabase database performance, cost efficiency, and scalability. Use for analyzing slow

Data & AI community
DB Migration Reviewer — Data & AI agent for Claude Code

DB Migration Reviewer

Database migration safety specialist. Activates when migrations/ files are detected in a PR or feature branch.

Data & AI community

Related Skills

DB Health — Security skill for Claude Code

DB Health

Supabase / Postgres health audit: missing indexes, slow queries via pg_stat_statements, unused indexes, table

Security community
Database Optimizer — Data skill for Claude Code

Database Optimizer

Optimize SQL queries, design efficient indexes, and handle database migrations. Solves N+1 problems, slow quer

Data community
DB Opt — Data skill for Claude Code

DB Opt

Identifies and optimizes slow database queries and schema bottlenecks.

Data community