Why do I need the PostGIS Knowledge Patch?

Claude's baseline knowledge typically covers PostGIS through version 3.4. This skill provides the necessary context for versions 3.5 and 3.6, including functions and breaking changes released between 2024 and 2026.

Does this skill support 3D spatial analysis?

Yes, it includes documentation for advanced 3D features introduced in SFCGAL 2.2, such as 3D buffering, 3D alpha wrapping, and 3D affine transformations.

What happened to the ST_ prefix for SFCGAL functions?

In PostGIS 3.5, SFCGAL functions were renamed with a 'CG_' prefix (e.g., CG_Visibility) and the old 'ST_' names were deprecated. This skill helps Claude use the correct modern naming.

How does this help with Raster data?

It provides updated logic for ST_Clip using the new 'touched' parameter and introduces new raster aggregation and reclassification functions like ST_AsRasterAgg and ST_ReclassExact.

PostGIS 3.5+ Knowledge Patch

Name: PostGIS 3.5+ Knowledge Patch
Author: Nevaberry

byNevaberry

•

数据库管理

Bridges the gap in Claude’s spatial database knowledge by providing the latest PostGIS 3.5 and 3.6 features, functions, and breaking changes.

This skill updates Claude Code with specialized knowledge for PostGIS versions 3.5 (released late 2024) and 3.6 (2025), addressing AI training data cutoffs. It enables accurate implementation of new spatial functions, manages breaking changes like the SFCGAL 'CG_' prefix transition, and facilitates the use of advanced features such as polygonal coverage cleaning, 3D affine transformations, and viewport-based geometry simplification. This patch is essential for geospatial developers and data scientists who require precise SQL generation and troubleshooting for modern PostgreSQL spatial extensions beyond the version 3.4 baseline.

主要功能

01Introduces ST_CoverageClean for polygonal edge matching and gap removal

02Documents Topology ID transitions from integer to bigint for large-scale data

03Updates SFCGAL function naming conventions from 'ST_' to 'CG_' prefixes

04Provides updated signatures for raster functions like ST_Clip and ST_AsRasterAgg

05Supports new viewport-based simplification with ST_RemoveIrrelevantPointsForView

067 GitHub stars

使用场景

01Implementing high-performance 3D geometry operations using the latest SFCGAL 2.2+ features

02Developing modern web-mapping backends that utilize advanced viewport simplification and raster aggregation

03Migrating legacy spatial queries to be compatible with PostGIS 3.5/3.6 breaking changes

What are Skills?·How to Install

Install with 🐟 Skill.Fish

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

For use in Claude.ai and ChatGPT

Download Skill