What PostgreSQL versions does this skill cover?

This skill specifically adds knowledge for PostgreSQL 17 (released Sept 2024) and PostgreSQL 18 (scheduled Sept 2025), extending Claude's baseline knowledge.

Can Claude now help with temporal data constraints?

Yes, the skill includes support for the WITHOUT OVERLAPS syntax used for temporal primary keys, unique constraints, and foreign keys.

How does it handle PostgreSQL 18's generated columns?

It updates Claude to recognize that generated columns are virtual by default in version 18 and provides the syntax for using the STORED keyword when needed.

Does this skill support the new JSON_TABLE function?

Yes, it provides full patterns and implementation details for using JSON_TABLE to transform JSON data into relational rows.

Does it include the new MERGE statement enhancements?

Absolutely. It covers WHEN NOT MATCHED BY SOURCE logic and the ability to use RETURNING merge_action() to track changes.

PostgreSQL 17-18 Knowledge Patch

Name: PostgreSQL 17-18 Knowledge Patch
Author: Nevaberry

byNevaberry

•

Database Management

Updates Claude with the latest PostgreSQL 17 and 18 features, including SQL/JSON functions, MERGE enhancements, and virtual generated columns.

The postgresql-knowledge-patch bridges the gap in Claude's baseline training by providing specialized guidance on PostgreSQL features released between 2024 and 2026. This skill enables Claude to accurately implement modern database patterns such as the SQL/JSON standard (JSON_TABLE), virtual-by-default generated columns, and temporal constraints. By incorporating these latest updates, developers can ensure their AI-generated SQL is optimized for performance, follows the newest syntax standards, and leverages advanced features like OLD/NEW RETURNING aliases and specialized UUID functions.

Key Features

01PostgreSQL 18 virtual generated column implementation and defaults

02Full SQL/JSON standard support including JSON_TABLE and JSON_VALUE

03Enhanced MERGE syntax with source-based conditions and action tracking

047 GitHub stars

05Advanced RETURNING clauses using OLD and NEW row aliases

06Temporal constraints (WITHOUT OVERLAPS) for primary and foreign keys

Use Cases

01Implementing complex synchronization logic using the enhanced MERGE statement

02Designing time-series or booking systems using native temporal primary keys

03Modernizing legacy JSONB processing with high-performance SQL/JSON functions

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add nevaberry/nevaberry-plugins postgresql-knowledge-patch

For use in Claude.ai and ChatGPT

Download Skill