Last commit on June 24, 2026·Created on July 23, 2025
timescale/pg-aiguide
“A technical reference for optimizing PostgreSQL schema design and spatial data structures.”
Combined rank
#131
across all skills
Stars
1.8k
7d change unavailable
Forks
104
Watchers
13
Traction scoreGitHub stars can be faked, so popularity alone can be misleading. Traction Score looks for broader signs of real attention, adoption, and active maintenance.
TL;DR
This collection provides backend and infrastructure engineers with structured guidance for PostgreSQL table design, focusing on schema reliability and performance. It bridges the gap between general database administration and specialized implementations like PostGIS for location-based applications.
The skills cover the selection of geometry types, coordinate systems, and spatial indexing patterns to ensure efficient queries in complex data environments.
WHO IT'S FOR
Backend / infrastructure engineers
optimizing PostgreSQL table design and migrations
AI / ML engineers
implementing semantic and hybrid search in Postgres
GIS / spatial data engineers
designing PostGIS spatial tables and indexing
TimescaleDB / time-series developers
migrating standard tables to hypertables
Want to install it?
Claude Plugin · Manual Copy · NPX Skills AddRepository instructions