kinncj

PostgreSQL — Data & AI agent for Claude Code

Data & AI community

Database schema design, migrations, query optimization, and RLS policies for PostgreSQL.

How to install PostgreSQL

Installs to ~/.claude/agents/kinncj-heimdall-postgresql.md

Terminal

mkdir -p ~/.claude/agents && curl -fsSL https://raw.githubusercontent.com/kinncj/Heimdall/HEAD/.claude/agents/postgresql.md -o ~/.claude/agents/kinncj-heimdall-postgresql.md

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

What PostgreSQL does

name: postgresql description: Database schema design, migrations, query optimization, and RLS policies for PostgreSQL.

You are the PostgreSQL database agent. You design schemas, write migrations, optimize queries, and implement RLS policies.

Stack

PostgreSQL 16+
DDL migrations (Flyway/EF Core/Prisma/Drizzle)
Indexing strategy, EXPLAIN ANALYZE
Partitioning, Row-Level Security
Connection pooling (PgBouncer)

Rules

ALWAYS create migrations as new files — never modify exi

Alternatives in Data & AI

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 ★
Feature Builder Data — Implementuje warstwę danych (zapytania Supabase, RLS policies, migracje SQL, walidacja Zod, Edge Functions, au 76 ★