postgresql-knowledge-patch
PostgreSQL 17+ Knowledge Patch
Claude's baseline knowledge covers PostgreSQL through 16. This skill provides features from 17 (Sep 2024) onwards.
Source: PostgreSQL release notes at https://www.postgresql.org/docs/release/
PostgreSQL 17 (Sep 2024)
SQL/JSON (Major)
| Function | Purpose | Example |
|---|---|---|
JSON_TABLE() |
JSON → table rows | FROM JSON_TABLE(data, '$.items[*]' COLUMNS (id int PATH '$.id')) |
JSON() |
Cast text → json | JSON('{"a":1}') |
JSON_SCALAR() |
Scalar → JSON | JSON_SCALAR(42) |
JSON_SERIALIZE() |
JSON → text | JSON_SERIALIZE(jsonb_col) |
JSON_EXISTS() |
Path exists? boolean | JSON_EXISTS(data, '$.key') |
JSON_VALUE() |
Extract scalar as SQL type | JSON_VALUE(data, '$.key' RETURNING int) |
JSON_QUERY() |
Extract JSON fragment | JSON_QUERY(data, '$.arr') |
More from nevaberry/nevaberry-plugins
dioxus-knowledge-patch
Dioxus changes since training cutoff (latest: 0.7.4) — Signals replacing use_state, RSX macro overhaul, server functions, asset!() system, dx CLI, Element-as-Result. Load before working with Dioxus.
47rust-knowledge-patch
Rust changes since training cutoff (latest: 1.94.0) \u2014 Rust 2024 Edition, async closures, trait upcasting, new std APIs, cargo resolver v3. Load before working with Rust.
20bun-knowledge-patch
Bun changes since training cutoff (latest: 1.3.10) \u2014 S3 client, built-in SQL/Redis, route-based HTTP server, CSS bundler, V8 compatibility. Load before working with Bun.
14nextjs-knowledge-patch
Next.js changes since training cutoff (latest: 16.1) — proxy.ts, \"use cache\", Cache Components, navigation hooks, typed routes, auto PageProps, React 19.2. Load before working with Next.js.
14postgis-knowledge-patch
PostGIS changes since training cutoff (latest: 3.6.1) — SFCGAL CG_* rename, ST_CoverageClean, ST_AsRasterAgg, topology bigint IDs, viewport simplification, 3D SFCGAL ops. Load before working with PostGIS.
13typescript-knowledge-patch
TypeScript changes since training cutoff (latest: 5.9) — import defer, --module node20, ArrayBuffer breaking change, TypeScript 7 native Go port (tsgo). Load before working with TypeScript.
11