v1.0.0 — PostgreSQL Skill Package

Initial release : 38 deterministic Claude skills for PostgreSQL 15, 16, and 17.

Categories

• core/ (6) : architecture (MVCC), api-surface, version-matrix, security-model, rls-policies, schema-design
• syntax/ (8) : dml-ddl, upsert-merge, jsonb, window-functions, cte-recursive, lateral-joins, arrays-ranges, full-text-search
• impl/ (15) : indexing-strategy, postgis-geometry-2d, postgis-3d-raster, pgvector-similarity, partitioning, logical-replication, streaming-replication, vacuum-bloat, query-performance-toolkit, bulk-loading, zero-downtime-migrations, backup-restore, schema-archaeology, listen-notify, advisory-locks
• errors/ (6) : deadlocks, serialization, constraint-violations, connection-auth, replication-lag, statement-timeouts
• agents/ (3) : query-reviewer, migration-reviewer, schema-reviewer

Coverage

PostgreSQL 15 / 16 / 17, plus PostGIS 3.4, pgvector 0.7, pg_cron, postgres_fdw, file_fdw, pg_partman, pg_stat_statements.

Quality

• Every SKILL.md under 500 lines, 3 reference files per skill
• Deterministic ALWAYS/NEVER guidance, English-only, version-annotated
• Compliance audit score : 100%
• Discovery : package.json agents.skills[] manifest + agents/openai.yaml (OpenAI Codex compatible)

Built with the 7-phase research-first methodology (Skill-Package-Workflow-Template).