impertio-studio/postgresql-claude-skill-package

1

postgres-agents-migration-reviewer Use when reviewing a database migration for production safety before it runs, or auditing a migration file in a pull …

impertio-studio/postgresql-claude-skill-package

3

2

postgres-agents-query-reviewer Use when reviewing SQL queries for correctness and performance before they ship, or auditing existing queries in a co…

impertio-studio/postgresql-claude-skill-package

3

3

postgres-agents-schema-reviewer Use when reviewing a PostgreSQL schema or DDL design before it ships, or auditing an existing schema for structural p…

impertio-studio/postgresql-claude-skill-package

3

4

postgres-core-rls-policies Use when implementing multi-tenant isolation, Supabase auth-based row access, or any per-row authorization in Postgre…

impertio-studio/postgresql-claude-skill-package

3

5

postgres-impl-advisory-locks Use when coordinating across application instances, ensuring a scheduled job runs at most once, or building a distrib…

impertio-studio/postgresql-claude-skill-package

3

6

postgres-impl-bulk-loading Use when importing large datasets, choosing COPY vs INSERT, querying CSV files as tables, or setting up cross-databas…

impertio-studio/postgresql-claude-skill-package

3

7

postgres-impl-indexing-strategy Use when a query is slow, picking which index type to create, or auditing a table for missing and redundant indexes. …

impertio-studio/postgresql-claude-skill-package

3

8

postgres-impl-postgis-geometry-2d Use when querying spatial data, picking geometry vs geography, or speeding up "find points near X" queries with PostG…

impertio-studio/postgresql-claude-skill-package

3

9

postgres-impl-zero-downtime-migrations Use when altering a table on a live production database, adding indexes or constraints without downtime, or backfilli…

impertio-studio/postgresql-claude-skill-package

3

10

postgres-syntax-jsonb Use when querying JSON columns, picking the right GIN opclass, or extracting values from jsonb payloads. Prevents slo…

impertio-studio/postgresql-claude-skill-package

3

11

postgres-core-api-surface Use when navigating PostgreSQL's SQL surface, picking the right system catalog, or learning psql meta-commands. Preve…

impertio-studio/postgresql-claude-skill-package

2

12

postgres-core-architecture Use when designing for PostgreSQL concurrency, understanding why a query sees old rows, or debugging "table is bloate…

impertio-studio/postgresql-claude-skill-package

2

13

postgres-core-schema-design Use when starting a new PostgreSQL database, picking naming conventions, deciding multi-schema layout, or hardening s…

impertio-studio/postgresql-claude-skill-package

2

14

postgres-core-security-model Use when designing PostgreSQL permission models, picking which role attributes to grant, or auditing existing privile…

impertio-studio/postgresql-claude-skill-package

2

15

postgres-core-version-matrix Use when targeting PostgreSQL 15, 16, or 17 and needing to know which feature is available where, or migrating across…

impertio-studio/postgresql-claude-skill-package

2

16

postgres-errors-connection-auth Use when connections fail with authentication errors, no pg_hba.conf entry, SSL handshake problems, or too-many-conne…

impertio-studio/postgresql-claude-skill-package

2

17

postgres-errors-constraint-violations Use when inserts or updates fail with unique, foreign-key, not-null, check, or exclusion constraint errors. Prevents …

impertio-studio/postgresql-claude-skill-package

2

18

postgres-errors-deadlocks Use when transactions fail with deadlock detected, designing locking order, or building a queue with row locks. Preve…

impertio-studio/postgresql-claude-skill-package

2

19

postgres-errors-replication-lag Use when a replica is behind, a replication slot is bloating WAL, or a logical subscription is stuck. Prevents primar…

impertio-studio/postgresql-claude-skill-package

2

20

postgres-errors-serialization Use when choosing a transaction isolation level, handling serialization_failure errors, or preventing write-skew anom…

impertio-studio/postgresql-claude-skill-package

2

21

postgres-errors-statement-timeouts Use when queries are canceled by timeout, sessions hold locks while idle, or you need to bound query and transaction …

impertio-studio/postgresql-claude-skill-package

2

22

postgres-impl-backup-restore Use when setting up backups, choosing logical vs physical, doing point-in-time recovery, or configuring v17 increment…

impertio-studio/postgresql-claude-skill-package

2

23

postgres-impl-listen-notify Use when building cache invalidation, job-queue wakeups, or real-time change notifications between PostgreSQL clients…

impertio-studio/postgresql-claude-skill-package

2

24

postgres-impl-logical-replication Use when replicating selected tables between databases, setting up zero-downtime upgrades, or debugging a stuck subsc…

impertio-studio/postgresql-claude-skill-package

2

25

postgres-impl-partitioning Use when splitting a large table by time or category, automating partition creation, or debugging why a query scans e…

impertio-studio/postgresql-claude-skill-package

2

26

postgres-impl-pgvector-similarity Use when storing embeddings for semantic search, picking hnsw vs ivfflat, or debugging why a vector query does a seqs…

impertio-studio/postgresql-claude-skill-package

2

27

postgres-impl-postgis-3d-raster Use when working with 3D geometry, volumetric calculations, or raster (gridded) data in PostGIS. Prevents calling 3D …

impertio-studio/postgresql-claude-skill-package

2

28

postgres-impl-query-performance-toolkit Use when a query is slow, reading an EXPLAIN plan, finding the worst queries on a server, or diagnosing lock waits. P…

impertio-studio/postgresql-claude-skill-package

2

29

postgres-impl-schema-archaeology Use when exploring an unfamiliar database, finding what references a table, locating unused or redundant indexes, or …

impertio-studio/postgresql-claude-skill-package

2

30

postgres-impl-streaming-replication Use when setting up a hot-standby replica, choosing synchronous_commit durability, or debugging replica lag and query…

impertio-studio/postgresql-claude-skill-package

2

31

postgres-impl-vacuum-bloat Use when a table is bloated, queries slow down over time, autovacuum is not keeping up, or you see transaction-ID wra…

impertio-studio/postgresql-claude-skill-package

2

32

postgres-syntax-arrays-ranges Use when storing list-valued columns, modelling time/number intervals, or preventing overlapping bookings with exclus…

impertio-studio/postgresql-claude-skill-package

2

33

postgres-syntax-cte-recursive Use when writing readable multi-stage queries, traversing parent/child trees, or constructing data-modifying CTEs tha…

impertio-studio/postgresql-claude-skill-package

2

34

postgres-syntax-dml-ddl Use when authoring CREATE TABLE / ALTER TABLE / INSERT / UPDATE / DELETE statements, picking IDENTITY vs SERIAL, or l…

impertio-studio/postgresql-claude-skill-package

2

35

postgres-syntax-full-text-search Use when building search over text columns, ranking results by relevance, or choosing between full-text search and tr…

impertio-studio/postgresql-claude-skill-package

2

36

postgres-syntax-lateral-joins Use when computing per-row dynamic subqueries, top-N-per-group results, or expanding JSON arrays per row in a JOIN cl…

impertio-studio/postgresql-claude-skill-package

2

37

postgres-syntax-upsert-merge Use when writing idempotent inserts, multi-action data sync, or migrating from MySQL INSERT ... ON DUPLICATE KEY UPDA…

impertio-studio/postgresql-claude-skill-package

2

38

postgres-syntax-window-functions Use when computing running totals, rank within partition, top-N-per-group via window, or comparing rows to neighbours…

impertio-studio/postgresql-claude-skill-package

2