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 packagedpgrouting · pgRouting Extension · 4.0.2 · Geospatial · GPL-2.0 · C++ · Packagedmobilitydb · MobilityDB geospatial trajectory data management & analysis platform · 1.3.0 · Geospatial · PostgreSQL · C · Packagedmobilitydb_datagen · MobilityDB random data generator functions · 1.3.0 · Geospatial · PostgreSQL · SQL · Packagedpointcloud · data type for lidar point clouds · 1.2.5 · Geospatial · BSD-3-Clause · C · Packagedpointcloud_postgis · integration for pointcloud LIDAR data and PostGIS geometry data · 1.2.5 · Geospatial · BSD-3-Clause · C · Packagedh3 · H3 bindings for PostgreSQL · 4.5.0 · Geospatial · Apache-2.0 · C · Packagedh3_postgis · H3 PostGIS integration · 4.5.0 · Geospatial · Apache-2.0 · C · Packagedogr_fdw · foreign-data wrapper for GIS data access · 1.1.9 · Geospatial · MIT · C · 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 packagedq3c · q3c sky indexing plugin · 2.0.5 · Geospatial · GPL-2.0 · C · 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 packagedgeoip · IP-based geolocation query · 0.3.0 · Geospatial · BSD-2-Clause · SQL · Packagedpgh_consistency · Pfafstetter consistency checks for PgHydro · 6.6 · Geospatial · GPL-2.0 · SQL · Packagedpgh_hgm · Hydrogeomorphological analysis extension for PgHydro · 2.2.6 · Geospatial · GPL-2.0 · SQL · Packagedpgh_output · Output and reporting objects for PgHydro · 6.6 · Geospatial · GPL-2.0 · SQL · Packagedpgh_output_en_au · Australian English output pack for PgHydro · 6.6 · Geospatial · GPL-2.0 · SQL · Packagedpgh_output_pt_br · Brazilian Portuguese output pack for PgHydro · 6.6 · Geospatial · GPL-2.0 · SQL · Packagedpgh_raster · Raster hydrology extension for PgHydro · 6.6 · Geospatial · GPL-2.0 · SQL · Packagedpghydro · Drainage network analysis core for PostgreSQL and PostGIS · 6.6 · Geospatial · GPL-2.0 · SQL · 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 packagedpg_geohash · Handle geohash based functionality for spatial coordinates · 1.0 · Geospatial · MIT · C · Packagedli3ds · PostgreSQL extension for managing 3D sensor data · 1.0.0 · Geospatial · MIT · Python · Not packagedpg_eviltransform · Coordinate transforms for BD09/GCJ02 via PostGIS ST_Transform · 0.0.4 · Geospatial · MIT · Rust · Packagedaddress_standardizer · Used to parse an address into constituent elements. Generally used to support geocoding address normalization step. · 3.6.4 · Geospatial · GPL-2.0 · C · Packagedaddress_standardizer_data_us · Address Standardizer US dataset example · 3.6.4 · Geospatial · GPL-2.0 · C · Packagedpostgis · PostGIS geometry and geography spatial types and functions · 3.6.4 · Geospatial · GPL-2.0 · C · Packagedpostgis_raster · PostGIS raster types and functions · 3.6.4 · Geospatial · GPL-2.0 · C · Packagedpostgis_sfcgal · PostGIS SFCGAL functions · 3.6.4 · Geospatial · GPL-2.0 · C · Packagedpostgis_tiger_geocoder · PostGIS tiger geocoder and reverse geocoder · 3.6.4 · Geospatial · GPL-2.0 · C · Packagedpostgis_topology · PostGIS topology spatial types and functions · 3.6.4 · Geospatial · GPL-2.0 · C · Packagedpg_tileless · Tools for packaging twkb in sqlite for tileless · 0.1 · Geospatial · GPL-2.0 · C · Not packagedtzf · Fast lookup timezone name by GPS coordinates · 0.3.0 · Geospatial · MIT · Rust · 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_polyline · Fast Google Encoded Polyline encoding & decoding for postgres · 0.0.1 · Geospatial · MIT · Rust · Packagedpg_trajectory · Define PostGIS trajectory types and spatiotemporal analysis functions in SQL and PL/pgSQL · 0.0.1 · Geospatial · Unknown · SQL · Not packagedqdgc · Encode, decode, navigate, and fill Extended Quarter Degree Grid Cell codes in pure SQL. · 0.1.0 · Geospatial · Apache-2.0 · SQL · Packagedqdgc_postgis · Add PostGIS geometry and geography bindings plus area-to-cell fills for QDGC. · 0.1.0 · Geospatial · Apache-2.0 · SQL · 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 packagedearthdistance · calculate great-circle distances on the surface of the Earth · 1.2 · Geospatial · PostgreSQL · C · 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

111 extensions found. Clear filters

NameVersionDescriptionCategoryLicenseLanguagePG VersionStars
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