Buscar habilidades.../

Postgresql Expert | Skills Pool

Archivo del skill

Postgresql Expert

Use for PostgreSQL schema design, query tuning, indexing, migrations, transactional safety, and operational reliability.

gocanto0 estrellas14 feb 2026

Ocupación
Categorías: Bases de Datos SQL

Contenido de la habilidad

Focused guidance for designing and operating PostgreSQL-backed systems safely at scale.

Scope

This skill is maintained in /Users/gustavo/Sites/partners-api/.agents/skills and is written to be compatible with Claude, Codex, and Gemini.

When to Use

Designing relational schemas and constraints
Writing and tuning SQL queries
Building safe migration plans
Investigating locks, deadlocks, and performance regressions

Compatibility Rules

Use plain Markdown and SQL/shell examples only
Avoid model-specific tool calls or proprietary syntax
Keep guidance portable across Claude, Codex, and Gemini

Workflow

Capture workload shape: read/write ratio, query patterns, cardinality
Design schema with constraints first: primary keys, foreign keys, uniqueness, checks

Skills relacionados

Instalación rápida

Postgresql Expert

npx skills add gocanto/skills

Descargar Skill Abrir repositorio

Autor: gocanto
estrellas: 0
Actualizado: 14 feb 2026
Ocupación

En esta página

Add indexes from real query paths, not assumptions

Plan reversible migrations with clear backward-compatibility steps

Validate with EXPLAIN (ANALYSE, BUFFERS) and representative data

Engineering Standards

Must

Use explicit transaction boundaries
Add foreign keys and required uniqueness constraints
Prefer NUMERIC for monetary values
Review execution plans for critical queries
Include rollback-safe migration steps

Must Not

Use SELECT * in performance-sensitive paths
Create redundant indexes without workload evidence
Perform destructive schema changes without a transition plan
Ignore lock impact during large migrations

Delivery Format

For substantial changes, provide:

Proposed schema or SQL changes
Migration plan with rollback path
Query plan observations and index rationale
Operational risks and mitigation steps

02

When to Use

03Compatibility Rules

05Engineering Standards

08Delivery Format

Arquitectos de bases de datos

Bases de Datos SQL

Postgres Patterns

PostgreSQL database patterns for query optimization, schema design, indexing, and security. Based on Supabase best practices.

Bases de Datos SQL

Postgres Patterns

PostgreSQL database patterns for query optimization, schema design, indexing, and security. Quick reference for common patterns, index types, data types, and anti-pattern detection. Based on Supabase best practices.

Bases de Datos SQL

Database Migrations

Database migration best practices for schema changes, data migrations, rollbacks, and zero-downtime deployments across PostgreSQL, MySQL, and common ORMs (Prisma, Drizzle, Django, TypeORM, golang-migrate). Use when planning or implementing database schema changes.

Bases de Datos SQL

Postgres Patterns

쿼리 최적화, 스키마 설계, 인덱싱, 보안을 위한 PostgreSQL 데이터베이스 패턴. Supabase 모범 사례 기반.

Ingeniería de Datos

Postgres Patterns

PostgreSQL database patterns for query optimization, schema design, indexing, and security. Based on Supabase best practices.

Bases de Datos SQL

Jpa Patterns

Spring Boot中的JPA/Hibernate模式，用于实体设计、关系处理、查询优化、事务管理、审计、索引、分页和连接池。

Arquitectos de bases de datos