postgis
Installation
SKILL.md
PostGIS 3.6.1 Spatial Database
Overview
PostGIS 3.6.1 (with GEOS 3.14) brings significant improvements: ST_CoverageClean for topology repair, enhanced SFCGAL 3D operations, bigint topology support for massive datasets, and improved PostgreSQL 18 integration. This skill ensures you leverage these capabilities correctly.
Core principle: Spatial is special. Generic database patterns often fail with geographic data.
Announce at start: "I'm applying postgis to ensure PostGIS 3.6.1 spatial best practices."
When This Skill Applies
This skill is MANDATORY when ANY of these patterns are touched: