🗺️
DataPython

PostGIS Spatial Table Design

by timescale

PostGIS Spatial Table Design is a Data skill for Claude Code, published by timescale in pg-aiguide.

1.8K stars104 forkson timescale/pg-aiguideAdded 2026/08/18Repository updated 2026/06/26
View source on GitHubDownload repo ZIP
aiai-agentsai-codingclaude-code-pluginclaude-code-pluginsclaude-code-plugins-marketplaceclaude-marketplaceclaude-pluginclaude-skillsdocsdocumentationmcpmcp-serverpostgrespostgresqlskills
Install in seconds
Install PostGIS Spatial Table Design
Copy PostGIS Spatial Table Design into your Claude Code skills folder. Run the command in your terminal, or review the source on GitHub before installing.
terminal
npx degit https://github.com/timescale/pg-aiguide/tree/main/skills/design-postgis-tables ~/.claude/skills/design-postgis-tables

Requires Node.js. Downloads this skill only — not the rest of the repository — into your Claude Code skills folder.

Without Node.js

git clone https://github.com/timescale/pg-aiguide.git

Clones the whole repository, then copy the skill’s own directory into your skills folder yourself.

In this catalog

Source file
skills/design-postgis-tables/SKILL.md in timescale/pg-aiguide
Installs to
~/.claude/skills/design-postgis-tables
Collection
One of 10 skills cataloged from this repository
Category
Data — 668 skills

What PostGIS Spatial Table Design does

PostGIS Spatial Table Design provides best practices and SQL patterns for designing PostGIS tables, covering geometry types, SRID selection, spatial indexes, and performance considerations for location-based applications.

PostGIS Spatial Table Design is cataloged under Data on DirSkills. PostGIS Spatial Table Design comes from a repository tagged ai, ai-agents, ai-coding, claude-code-plugin and claude-code-plugins.

Documentation

README

PostGIS Spatial Table Design

Before You Start (5 Questions)

  1. What is the geographic scope (single city/region vs global)?
  2. What are your primary query patterns (within-radius, bbox, intersects, nearest-neighbor)?
  3. What units do you need for distance/area (meters vs CRS units), and how accurate must they be?
  4. What is the expected scale (rows, write rate), and is the data mostly append-only?
  5. Do you need 3D (Z) or measures (M), or is 2D enough?

SQL injection note: When turning these patterns into application code, use parameterized queries for user-provided values (WKT/WKB, coordinates, IDs, radii). Avoid string-concatenating untrusted input into SQL; for dynamic identifiers, use safe identifier quoting/whitelisting.

Core Rules

This is the opening of the README. Read the full README on GitHub.

Frequently asked about PostGIS Spatial Table Design

  • What else does timescale publish alongside PostGIS Spatial Table Design?

    PostGIS Spatial Table Design is one of 10 skills that DirSkills catalogs from timescale/pg-aiguide, the repository it ships in. Its siblings there include Find Hypertable Candidates, Ghost Database and PGVector Semantic Search. Each one is a separate skill with its own page in this directory, installs the same way PostGIS Spatial Table Design does, and is maintained by timescale in that same repository. The rest of the collection is listed on the timescale/pg-aiguide page.

  • How does PostGIS Spatial Table Design compare to other Data skills?

    PostGIS Spatial Table Design ranks #356 by stars among the 668 Data skills in this catalog. The most-starred ones next to it are Benchmark Methodology, Jupyter Notebook and Solana. DirSkills ranks by the star count of the repository each skill ships in, so that order reflects how popular those repositories are rather than any review of PostGIS Spatial Table Design against them. Open each page to compare what they document and how they install.

More from timescale/pg-aiguide

PostGIS Spatial Table Design is one of 10 skills cataloged on DirSkills from timescale/pg-aiguide.

See all 10 skills →
🗄️
2w ago

Find Hypertable Candidates

Find Hypertable Candidates analyzes an existing PostgreSQL database to identify which tables should be converted to Timescale/TimescaleDB hypertables. Use it when auditing tables for time-series or insert-heavy workloads and evaluating hypertable candidacy before migration.
DevOps
1.8K104
🐘
2w ago

Ghost Database

Ghost Database creates and manages PostgreSQL databases for agent workflows, with on-demand creation, instant forks for safe testing, and shareable snapshots. Use it when an agent needs persistent storage or wants to pass databases as assets between workflows.
DevOps
1.8K104
🔍
2w ago

PGVector Semantic Search

PGVector Semantic Search stores and searches vector embeddings in PostgreSQL using HNSW or IVFFlat indexes for semantic search, RAG, and nearest-neighbor queries. Use it to set up pgvector, tune recall and performance, or implement binary quantization for large datasets.
AI Engineering
1.8K104
🐘
2w ago

PostgreSQL

PostgreSQL provides expert guidance for PostgreSQL table design, indexing, data types, constraints, extensions, search, and migrations. Use it when designing schemas, working with pgvector/PostGIS/TimescaleDB, or planning safe schema changes.
Data
1.8K104
🐘
2w ago

PostgreSQL Database Migration

PostgreSQL Database Migration helps plan, test, and safely execute PostgreSQL schema migrations on production data. Use it to understand DDL lock levels, perform zero-downtime ALTER TABLE changes, backfill data, and plan rollbacks.
DevOps
1.8K104
🐘
2w ago

PostgreSQL Table Design

PostgreSQL Table Design guides PostgreSQL schema, table, data type, constraint, and index decisions when creating new tables or modifying existing ones.
Data
1.8K104

More Data skills

PostGIS Spatial Table Design is one of 668 Data skills cataloged on DirSkills, ranked #356 by stars among them.

Browse all Data skills →
📊
3w ago

Benchmark Methodology

Benchmark Methodology scores competitors across nine weighted dimensions using explicit 1–5 rubrics and a tension plot. Use it after competitive-platform-analysis to produce comparable, evidence-anchored profile cards for a competitive report.
Data
239.8K36.4K
📓
3w ago

Jupyter Notebook

Jupyter Notebook provides a stateful Python REPL via a live Jupyter kernel (hamelnb) so variables persist across executions. Use it for iterative data exploration, API inspection, and complex code development.
Data
229.7K45.3K
🪙
3w ago

Solana

Solana queries wallets, token holdings, transactions, NFTs, whale transfers, and network stats on the Solana blockchain with USD pricing via CoinGecko. Use it when you need to inspect an address, verify a transaction, check token metadata or prices, or monitor network health.
Data
229.7K45.3K