h3-pg (H3 PostgreSQL Extension)

Name: h3-pg (H3 PostgreSQL Extension)
Rating: 86 (1 reviews)
Author: postgis

Trust Score 86/100

from h3-pg366

PostgreSQL/PostGIS extension exposing H3 hexagonal grid functions for indexing, polygon fill, raster summaries, and spatial operators inside Postgres.

triggers:h3postgispolygon to cellsh3 polygonh3 raster summaryh3_postgish3 extension

GitHub SKILL.md

What it does

h3-pg provides Postgres bindings for Uber's H3 hexagonal geospatial index. It exposes core H3 functions plus PostGIS integrations: direct casts to geometry/geography, polygon-to-cells (polyfill), raster summary helpers, and grid operators for distance and tiling. The repo documents extension setup and Postgres-specific operators.

When to use it

Use when you need H3 indexing and analytics inside Postgres/PostGIS — spatial indexing, grid-based aggregations, converting geometries to H3 cells, efficient raster summaries per cell, or when you need Postgres-native H3 operators for queries.

What's included

Scripts: none in SKILL.md; documentation and API references are included in docs/ (api.md).
References: links to API docs and migration notes, plus examples for v3→v4 renames and common pattern fixes.
Instructions: guidance on extension creation, operator usage, and recommended patterns for centroids, boundaries, and raster integration.

Compatible agents

Useful for agents that can run SQL against Postgres/PostGIS instances or help engineers craft SQL queries (DB-focused agents, SQL-savvy automation tools).

Audit Summary

Pure documentation skill for h3-pg, a PostgreSQL/PostGIS extension providing H3 hexagonal grid functions. No scripts included. The SKILL.md is a well-written reference card covering extension architecture, Postgres-specific features, common pattern fixes, and a critical v3→v4 migration table. Very useful for PostGIS developers but niche audience. No security concerns whatsoever — no executable content.

Watch Out

SKILL.md was at docs/h3-pg-skill/SKILL.md, not docs/SKILL.md as indexed
No scripts to run — pure reference skill
Antimeridian handling and v3→v4 function renames are critical gotchas documented in the skill itself

Notes

Source path in DB (docs/SKILL.md) returned 404; actual path is docs/h3-pg-skill/SKILL.md. Skill is a well-crafted reference card with no executable content. Clean from a security perspective.

Information

Repository: h3-pg
Stars: 366

Trust Score

Overall86

Security100

Code Quality82

Architecture55

Usefulness52

Related Skills

Sync Production Database to Development

Run a safe, scripted workflow to download production database dumps and restore them into a development environment (download-only and restore options).

ZotPilot

Zotero-focused research assistant: index, search, and organise academic papers and libraries; supports ingestion, tagging, collections and citation lookups.

Nuxt Users

Add and configure user authentication, authorization, database and CLI tools for Nuxt 3/4 apps using the nuxt-users module.

AntV L7 Geospatial

Guides building high-performance WebGL geospatial visualizations (maps, heatmaps, layers) with AntV L7 and related map providers.

Supabase Expert

Comprehensive Supabase expert with access to 2,616 official documentation files covering PostgreSQL database, authentication, real-time subscriptions, storag...

Gsd:sketch

Sketch UI/design ideas with throwaway HTML mockups, or propose what to sketch next (frontier mode) - Read - Write - Edit - Bash - Grep - Glob - AskUserQuesti...

Parchi Relay — Browser Relay & Automation

Run a local relay daemon and browser extension to control real browsers via JSON-RPC/WebSocket; includes CLI for listing agents, calling tools, and running task

MUD Store Indexing (Nethereum)

Index MUD Store events to rebuild off-chain MUD World state and persist it in PostgreSQL or EF Core-compatible schemas; supports continuous sync and normalized

Back to Skills