pypgstac

What it is and what it does

pypgstac is a Python library for interacting with STAC (Spatio-Temporal Asset Catalog) data stored in PostgreSQL. It provides schema management, search utilities, and integration with PostgreSQL's spatial capabilities to build performant catalogs of geospatial and temporal metadata. The package is part of a larger ecosystem that includes SQL schema definitions, a Rust CLI, and migration tools—but pypgstac itself focuses on the Python read/write layer.

The library is designed to work alongside PostgreSQL drivers and is typically used in production deployments where STAC catalogs need to scale to hundreds of millions of items. It does not expose an HTTP API directly; instead, it serves as a backend for frameworks like STAC FastAPI or other applications that need programmatic access to STAC collections and items stored in a PostgreSQL database.

Use it for:

• Query and filter STAC collections and items from a PostgreSQL database using CQL2 search syntax
• Manage indexing and partitioning of large STAC catalogs in production environments
• Build custom STAC API backends by integrating pypgstac with web frameworks
• Migrate or maintain STAC data stored in PostgreSQL with schema utilities
• Integrate geospatial asset metadata into Python applications backed by PostgreSQL

Worth the install?

AI-flagged interpretation of the facts on this page — verify before relying

pypgstac provides Python bindings and utilities for managing Spatio-Temporal Asset Catalog (STAC) data in PostgreSQL, including search, filtering, and schema management functions.

Yes, if you are building or maintaining a STAC catalog in PostgreSQL and need Python access to query and manage it. The package is actively maintained, has no known vulnerabilities, and low install friction. Not necessary if you only need HTTP-level STAC API access or are not using PostgreSQL as your backend.

Install

pypgstac on PyPI

pip install pypgstac

uv add pypgstac

poetry add pypgstac

Installing pypgstac

Before you install

Low friction installation with a pure-Python wheel. Active maintenance: released 15 days ago with a last commit on 2026-08-10. Depends on 10 runtime packages including pydantic, orjson, and tenacity—all common, stable dependencies.

License in practice

MIT license (permissive) allows use in commercial and proprietary projects with minimal restrictions beyond attribution.

Quickstart

pip install pypgstac

import pypgstac
from pydantic import BaseModel

# Use pypgstac with PostgreSQL connection to query STAC items

Requires a PostgreSQL database with PgSTAC schema installed; pypgstac is a Python client library, not a standalone database.

Verify before relying

• Specific API surface and method signatures available in version 0.9.12
• Whether pypgstac-rs (Rust-backed extension) is included or requires separate installation
• Performance characteristics when querying hundreds of millions of STAC items

Package facts

Evidence: pypgstac-0.9.12-py3-none-any.whl

Keywords: PgSTAC, Postgresql, STAC

Tags

More Database packages