Skills
.Work. You
Rest

postgresql-knowledge-patch

Official

Prevent outdated PostgreSQL usage with current patches

Software Engineering#database#postgresql#migrations#json#sql#uuidv7#knowledge-patch
AuthorNevaberry
Version1.0.0
Installs0

System Documentation

What problem does it solve?

This knowledge patch prevents code and queries from using outdated PostgreSQL behaviors and deprecated APIs by summarizing changes introduced in PostgreSQL 17 and 18 and highlighting breaking changes and new features.

Core Features & Use Cases

  • Up-to-date SQL references: concise summaries of SQL/JSON functions, MERGE enhancements, COPY/ON_ERROR and REJECT_LIMIT options, EXPLAIN additions, and DDL changes.
  • Migration guidance: concrete notes for virtual generated columns, OLD/NEW RETURNING semantics, temporal constraints and NOT ENFORCED constraints to avoid regressions during upgrades.
  • Developer workflows: use when writing queries, crafting migrations, reviewing schema changes, or validating third-party SQL for compatibility with PostgreSQL 17 and 18.

Quick Start

Load the postgresql-knowledge-patch before writing or reviewing PostgreSQL code to apply the documented changes and avoid outdated patterns.

Dependency Matrix

Required Modules

None required

Components

references

💻 Claude Code Installation

Recommended: Let Claude install automatically. Simply copy and paste the text below to Claude Code.

Please help me install this Skill:
Name: postgresql-knowledge-patch
Download link: https://github.com/Nevaberry/nevaberry-plugins/archive/main.zip#postgresql-knowledge-patch

Please download this .zip file, extract it, and install it in the .claude/skills/ directory.
View Source Repository

Agent Skills Search Helper

Install a tiny helper to your Agent, search and equip skill from 471,000+ vetted skills library on demand.