select open change scope Open full search

PG.CENTER connects PostgreSQL documentation, reference, and ecosystem knowledge. Maintained by Pigsty.

PostgreSQL Extension Catalogue

Explore 2387 PostgreSQL extensions from PGEXT, maintained by Pigsty.

pg_lake_spatial · Adds geospatial file-format and spatial-function support to pg_lake through PostGIS and GDAL-backed workflows. · 3.5 · Geospatial · Apache-2.0 · C · Not packagedpostal · PostgreSQL bindings for libpostal that normalize free-form addresses and parse them into labeled components. · 1.0 · Geospatial · MIT · C · Not packagedcartodb · Archived PostgreSQL extension for turning a database into a CartoDB user database. · 0.37.1 · Geospatial · BSD-3-Clause · Python · Not packagedpgh3 · Expose Uber H3 hierarchical geospatial indexing functions for PostGIS geometries · 0.3.0 · Geospatial · Apache-2.0 · C · Not packagedcrankshaft · Archived CARTO spatial-analysis functions for clustering, segmentation, and spatial statistics. · 0.9.0 · Geospatial · BSD-3-Clause · Python · Not packagedeaggr · The OpenEAGGR software library is an implementation of a Discrete Global Grid System (DGGS) which models the Earth's surface as a network of equal area cells. · 2.0 · Geospatial · LGPL-3.0 · C++ · Not packagedvrprouting · Vehicle Routing Problems on the Database · 0.5.0 · Geospatial · GPL-2.0 · C++ · Not packagedplv8geo · PL/v8 geospatial functions that bundle D3, TopoJSON, JSTS, GeoTIFF and related JavaScript libraries for PostGIS workflows. · 0.0.2 · Geospatial · MIT · JavaScript · Not packagedlostgis · LostGIS spatial helper functions and types · 1.0.2 · Geospatial · BSD-3-Clause · SQL · Not packagedcdb_geocoder · Archived CARTO geocoder extension for administrative, postal, IP, and named-place lookups. · 0.0.2 · Geospatial · Unknown · SQL · Not packageds2 · PL/Python functions for converting latitude/longitude to S2 cell IDs and tokens and navigating the S2 cell hierarchy · 0.0.2 · Geospatial · MIT · Python · Not packagedpgs2 · Postgres extension for S2 spherical geometry · 0.0.1 · Geospatial · Apache-2.0 · C · Not packagedast_postgis · Advanced spatial data types and spatial integrity constraints for PostGIS. · 1.1.1 · Geospatial · MIT · SQL · Not packagedpg_healpix · Provides PostgreSQL functions that convert sky coordinates to and from HEALPix nested and ring pixel identifiers. · 1.0 · Geospatial · GPL-2.0 · C · Not packagedzcurve · Two- and three-dimensional Z-order bit interleaving plus direct range lookup over numeric B-tree indexes. · 1.3 · Geospatial · Unknown · C · Not packagedli3ds · PostgreSQL extension for managing 3D sensor data · 1.0.0 · Geospatial · MIT · Python · Not packagedpg_tileless · Tools for packaging twkb in sqlite for tileless · 0.1 · Geospatial · GPL-2.0 · C · Not packagedpg_landmetrics · A PostgreSQL/PostGIS extension for calculating landscape metrics. · 0.0.1 · Geospatial · GPL-3.0 · SQL · Not packagedpggeojson · A GeoJSON generating extension for PostGIS · 1.0 · Geospatial · Apache-2.0 · SQL · Not packagedpostile · A pgrx PostgreSQL extension for map-tile generation helpers and gzip/Brotli bytea compression. · 0.0.1 · Geospatial · MIT · Rust · Not packagedvasavgeom · Vague geometry handler - VASA · 1.1 · Geospatial · GPL-2.0 · C · Not packagedfestival · FESTIval is a PostgreSQL extension for conducting performance evaluations of spatial indices · 1.1.1 · Geospatial · GPL-3.0 · C · Not packageda5pg · Equal-area A5 spatial index functions for PostgreSQL. · 0.6.1 · Geospatial · Apache-2.0 · Rust · Not packagedhistorical_geocoding · SQL toolkit for geocoding historical addresses by combining textual, temporal, and spatial evidence. · 1.0 · Geospatial · MIT · SQL · Not packagedpostgis_letters · convert text letters into PostGIS geometries using packaged vector fonts · 0.0.5 · Geospatial · MIT · SQL · Not packagedgeohash_extra · Additional geohash functions · 0.0.1 · Geospatial · Unknown · C · Not packagedgeoip2lookup · Look up IP-address info in MaxMind GeoIP2 MMDB files · 0.0.3 · Geospatial · BSD-2-Clause · SQL · Not packagedhexgrid · Configurable hex grid on abstract surface · 1.0.3 · Geospatial · BSD-3-Clause · C · Not packagedpg_trajectory · Define PostGIS trajectory types and spatiotemporal analysis functions in SQL and PL/pgSQL · 0.0.1 · Geospatial · Unknown · SQL · Not packagedcoordconv · Convert between IAU 1958 Galactic coordinates and J2000 FK5 equatorial coordinates · 1.0.0 · Geospatial · GPL-2.0 · C · Not packagedfrapi · In-database wrappers for French public-administration data APIs. · 0.1.2 · Geospatial · MIT · SQL · Not packagedmapcode · Mapcodes in PostgreSQL · 0.0.6 · Geospatial · PostgreSQL · C++ · Not packagedrostgis · Experimental PostGIS-compatible spatial extension written in Rust. · 0.1.0 · Geospatial · MIT · Rust · Not packagedbrin4postgis · BRIN indexes for PostGIS · 0.0.1 · Geospatial · GPL-3.0 · SQL · Not packagedgeohistorical_objects · Geohistorical objects support · 1.0 · Geospatial · MIT · SQL · Not packagedlivewire · power delivery modeling · 0.2.0 · Geospatial · Unknown · SQL · Not packagedpg_geohash_extra · Additional geohash functions for PostGIS · 0.0.1 · Geospatial · GPL-3.0 · C · Not packagedpg_tms · functions to tile rasters in TMS format · 0.0.4 · Geospatial · MIT · SQL · Not packagedrtosm · Real-time simplification of spatial objects in an OpenStreetMap API database. · 0.1 · Geospatial · GPL-2.0 · C · Not packagedsiguanet_quest · Application-specific PL/pgSQL reporting layer for spatial aggregation over SIGUANET/PostGIS campus asset databases. · 1.0 · Geospatial · GPL-3.0 · SQL · Not packagedfirefly · PostGIS-backed Firefly database schema for tracking 3D points and add/delete operations by task. · 0.2.0 · Geospatial · GPL-3.0 · SQL · Not packagedgbuilder · Additional geometry builders · 1.0 · Geospatial · Unknown · C · Not packagedmogipix · PostgreSQL extension exposing HEALPix and MOC Rust functions to SQL. · 0.0.1 · Geospatial · Unknown · Rust · Not packagedosrmint · PostgreSQL route OSRM integration · 0.1 · Geospatial · LGPL-3.0 · C++ · Not packagedpg_twkb · TWKB tools etc · 0.1 · Geospatial · GPL-2.0 · C · Not packagedpostgis_domains · Define reusable PostGIS geometry and geography domains constrained to valid, simple SRID 4326 values · 1.0 · Geospatial · MIT · SQL · Not packagedtriangle_array · Prototype PostgreSQL representation of triangulated irregular networks using compact point and triangle arrays. · 0.1 · Geospatial · Unknown · C · Not packagedastrocat · PostgreSQL extension for indexing astronomical catalogues with spherical point and circle types, GiST indexing, radial queries, and k-nearest-neighbor ordering. · 1.0 · Geospatial · Unknown · C · Not packageddumppoints · C implementation of ST_DumpPoints for PostGIS geometry collections. · 1.0 · Geospatial · Public Domain · C · Not packagedganos_address_standardizer · A placename standardization extension based on the PAGC standard. · 7.0 · Geospatial · Unknown · C · Not packagedganos_address_standardizer_data_us · A placename standardization (United States) data extension based on the PAGC standard. · 7.0 · Geospatial · Unknown · Data · Not packagedganos_geometry · Provides computing and analysis features for spatial geometry types. · 7.0 · Geospatial · Unknown · C · Not packagedganos_geometry_pyramid · Builds sparse vector tile pyramids for fast rendering of large 2D geometry datasets. · 7.0 · Geospatial · Unknown · C · Not packagedganos_geometry_sfcgal · Provides extension features for the spatial geometry SFCGAL plugin. · 7.0 · Geospatial · Unknown · C · Not packagedganos_geometry_topology · Ganos geometry topology spatial types and functions extension for PostgreSQL. · 7.0 · Geospatial · Unknown · C · Not packagedganos_geomgrid · Provides grid partitioning, encoding, indexing, and analysis capabilities for H3, GeoSOT, and other grid systems. · 7.0 · Geospatial · Unknown · C · Not packagedganos_networking · Road and traffic network analysis with cost-based shortest, fastest, and optimal path algorithms. · 7.0 · Geospatial · Unknown · C · Not packagedganos_pointcloud · Provides storage, computing, and analysis features for point clouds. · 7.0 · Geospatial · Unknown · C · Not packagedganos_pointcloud_geometry · Integrates GanosBase PointCloud types with geometry for spatial analysis. · 7.0 · Geospatial · Unknown · C · Not packagedganos_raster · Provides storage, computing, and analysis features for spatial raster data. · 7.0 · Geospatial · Unknown · C · Not packagedganos_spatialref · Provides computing and analysis features for spatial references. · 7.0 · Geospatial · Unknown · Data · Not packagedganos_tiger_geocoder · Ganos tiger geocoder and reverse geocoder with support for USCB TIGER data. · 7.0 · Geospatial · Unknown · C · Not packagedganos_trajectory · Models, queries, and analyzes moving-object trajectories across space and time. · 7.0 · Geospatial · Unknown · C · Not packagedgis_objects · Postgres extension for Point, Polygon, and Point-in-Polygon operations in C · 1.0 · Geospatial · Unknown · C · Not packagedhyperspace · Four-dimensional point, box, and circle types with B-tree and SP-GiST/KD-tree operator classes. · 1.0 · Geospatial · Unknown · C · Not packagedipinfo · IP geolocation lookup functions backed by the ipinfo.io HTTP service. · 1.0.1 · Geospatial · Apache-2.0 · C · Not packagedmastermobilitydb · Schema, types, and utilities for managing moving-object trajectories with MobilityDB. · 1.0.0 · Geospatial · Unknown · SQL · Not packagednfiesta_gisdata · nfi gisdata database · 3.0.7 · Geospatial · Unknown · SQL · Not packagednfiesta_target_data · PostgreSQL extension for manipulation of target data - aggregation of local density contributions at the plot level. · 2.33.2 · Geospatial · Unknown · SQL · Not packagedpg_osgr · Ordnance Survey grid reference handling for biological recording · 1.1.0 · Geospatial · Unknown · SQL · Not packagedpg_s2 · Adds an S2 CellID type, hierarchy and covering functions, distance helpers, casts, operators, and a B-tree operator class. · 0.0.6 · Geospatial · MIT · Rust · Not packagedpg_wui · PostgreSQL extension for wildland urban interface data analysis using SIOSE databases · 0.2 · Geospatial · GPL-3.0 · SQL · Not packagedpghex · Adds a hexagonal-grid coordinate type with tile arithmetic, neighbor, range, line-drawing, and distance functions. · 0.0.0 · Geospatial · Unknown · Rust · Not packagedpgr_dmmsy · DMMSY deterministic directed single-source shortest path algorithm for pgRouting · 0.1.0 · Geospatial · Unknown · C · Not packagedpgtempus · Multimodal transport graph loading, routing, and isochrone functions. · 2.1 · Geospatial · LGPL-2.0-only · C++ · Not packagedpgtfs · PostgreSQL Extension for public transportation routing using GTFS · 0.0.4 · Geospatial · Unknown · C++ · Not packagedpgvroom · VROOM functionality reached from the database · 0.1.0 · Geospatial · GPL-2.0 · C++ · Not packagedpostgrids · pgrx extension for parsing, formatting, and changing the precision of British OSGB and Irish OSI national grid references. · 0.0.0 · Geospatial · MIT · Rust · Not packagedrtiles · Rust/PostGIS extension for serving configurable Mapbox Vector Tile layers for self-hosted interactive maps. · 0.0.0 · Geospatial · Apache-2.0 · Rust · Not packagedsgp4 · C extension that propagates satellite TLEs with SGP4 and returns WGS84 position as WKT. · 0.1 · Geospatial · MIT · C · Not packaged

80 extensions found. Clear filters

NameVersionDescriptionCategoryLicenseLanguagePG VersionStars
ganos_address_standardizer_data_us 7.0 A placename standardization (United States) data extension based on the PAGC standard. GIS Data 10–17
ganos_geometry 7.0 Provides computing and analysis features for spatial geometry types. GIS C 10–17
ganos_geometry_pyramid 7.0 Builds sparse vector tile pyramids for fast rendering of large 2D geometry datasets. GIS C 10–17
ganos_geometry_sfcgal 7.0 Provides extension features for the spatial geometry SFCGAL plugin. GIS C 10–17
ganos_geometry_topology 7.0 Ganos geometry topology spatial types and functions extension for PostgreSQL. GIS C 10–17
ganos_geomgrid 7.0 Provides grid partitioning, encoding, indexing, and analysis capabilities for H3, GeoSOT, and other grid systems. GIS C 10–17
ganos_networking 7.0 Road and traffic network analysis with cost-based shortest, fastest, and optimal path algorithms. GIS C 10–17
ganos_pointcloud 7.0 Provides storage, computing, and analysis features for point clouds. GIS C 10–17
ganos_pointcloud_geometry 7.0 Integrates GanosBase PointCloud types with geometry for spatial analysis. GIS C 10–17
ganos_raster 7.0 Provides storage, computing, and analysis features for spatial raster data. GIS C 10–17
ganos_spatialref 7.0 Provides computing and analysis features for spatial references. GIS Data 10–17
ganos_tiger_geocoder 7.0 Ganos tiger geocoder and reverse geocoder with support for USCB TIGER data. GIS C 10–17
ganos_trajectory 7.0 Models, queries, and analyzes moving-object trajectories across space and time. GIS C 10–17
gis_objects 1.0 Postgres extension for Point, Polygon, and Point-in-Polygon operations in C GIS C
hyperspace 1.0 Four-dimensional point, box, and circle types with B-tree and SP-GiST/KD-tree operator classes. GIS C 15
ipinfo 1.0.1 IP geolocation lookup functions backed by the ipinfo.io HTTP service. GIS Apache-2.0 C
mastermobilitydb 1.0.0 Schema, types, and utilities for managing moving-object trajectories with MobilityDB. GIS SQL
nfiesta_gisdata 3.0.7 nfi gisdata database GIS SQL
nfiesta_target_data 2.33.2 PostgreSQL extension for manipulation of target data - aggregation of local density contributions at the plot level. GIS SQL
pg_osgr 1.1.0 Ordnance Survey grid reference handling for biological recording GIS SQL
pg_s2 0.0.6 Adds an S2 CellID type, hierarchy and covering functions, distance helpers, casts, operators, and a B-tree operator class. GIS MIT Rust 14–17
pg_wui 0.2 PostgreSQL extension for wildland urban interface data analysis using SIOSE databases GIS GPL-3.0 SQL
pghex 0.0.0 Adds a hexagonal-grid coordinate type with tile arithmetic, neighbor, range, line-drawing, and distance functions. GIS Rust 12–17
pgr_dmmsy 0.1.0 DMMSY deterministic directed single-source shortest path algorithm for pgRouting GIS C 14–16
pgtempus 2.1 Multimodal transport graph loading, routing, and isochrone functions. GIS LGPL-2.0-only C++
pgtfs 0.0.4 PostgreSQL Extension for public transportation routing using GTFS GIS C++
pgvroom 0.1.0 VROOM functionality reached from the database GIS GPL-2.0 C++
postgrids 0.0.0 pgrx extension for parsing, formatting, and changing the precision of British OSGB and Irish OSI national grid references. GIS MIT Rust 12–17
rtiles 0.0.0 Rust/PostGIS extension for serving configurable Mapbox Vector Tile layers for self-hosted interactive maps. GIS Apache-2.0 Rust 16
sgp4 0.1 C extension that propagates satellite TLEs with SGP4 and returns WGS84 position as WKT. GIS MIT C