← All skills

postgis-spatial-sql

100 / 100 · Low risk

Fine to try.

By muend/geoai-skills (GitHub) · data · 45 stars · scanned at commit 19937ce

Invoke whenever spatial SQL or its execution backend is the decision: PostGIS, DuckDB Spatial, SpatiaLite, ST_* functions, recurring spatial joins, concurrent/growing workloads, or large GeoParquet queries. Covers backend selection, schemas, GiST/BRIN indexes, KNN, geometry versus geography, correctness benchmarks, and EXPLAIN optimization. Use PostGIS for managed concurrent services and embedded engines for bounded local analytics when evidence supports that choice. Use geo-data-engineering fo…

Works with any agent that supports SKILL.md skills.

What this skill can do

We found nothing in the files we read that matches our rules. That does not prove the skill is safe: see the limits of static scanning.

Install

Paste this into your terminal. It downloads exactly the version we scanned, not whatever is newest.

if [ -e ~/.agents/skills/'postgis-spatial-sql' ] || [ -L ~/.agents/skills/'postgis-spatial-sql' ]; then echo 'A skill folder named postgis-spatial-sql already exists — not replacing it' >&2; false; else d=$(mktemp -d) && git clone --quiet --filter=blob:none --no-checkout 'https://github.com/muend/geoai-skills' "$d" && git -C "$d" checkout --quiet '19937ce14c7d60d764732cc2688c6a3dd92f6d0e' -- 'skills/postgis-spatial-sql' && mkdir -p ~/.agents/skills && cp -R "$d"/'skills/postgis-spatial-sql' ~/.agents/skills/'postgis-spatial-sql' && rm -rf "$d"; fi

Codex reads ~/.agents/skills directly. For Claude Code, Cursor, Copilot, Gemini CLI, Antigravity or OpenCode, also link it. For Claude Code: ln -s ~/.agents/skills/'postgis-spatial-sql' ~/.claude/skills/'postgis-spatial-sql' (other agents: ~/.cursor/skills, ~/.copilot/skills, ~/.gemini/skills, ~/.gemini/config/skills, ~/.config/opencode/skills). Or install through the finder skill, which does both.

Badge for your README

The badge for muend/geoai-skills shows the score of its lowest-scoring skill.

[![SkillTrust](https://zalavijaysinh.github.io/skilltrust/badges/muend/geoai-skills.svg)](https://zalavijaysinh.github.io/skilltrust/repos/muend/geoai-skills/)

Score history