# pramsey/pgsql-http

HTTP client for PostgreSQL, retrieve a web page from inside the database.

Repository: https://github.com/pramsey/pgsql-http
Canonical: https://ross.abutalabs.com/products/pgsql-http
Language: C
License: MIT
License Family: permissive
Last push: 2026-07-09T17:17:03+00:00

## Health v2 (maintenance only)
Score: 85/100 (v2, computed 2026-09-03T02:20:16.233290+00:00)
- activity 91, release rhythm 68, longevity 100
- inputs: {"age_days": 5250, "days_push": 55, "days_rel": 55, "gap_med": 96, "n_releases_24m": 6}
- flags: none
- formula: round(0.45*activity + 0.35*rhythm + 0.20*longevity); archived -> min(score, 10)

## Adoption (not part of the score)
Stars 1592, forks 129 (observed 2026-08-28T04:05:08.782579+00:00)

## What it is
A PostgreSQL extension written in C that lets you make HTTP requests (GET, POST, PUT, PATCH, DELETE) directly from SQL queries. It enables database triggers to call web services or fetch web content from inside the database.

## Use cases
- make http requests from sql in postgres
- call a web service from a database trigger
- fetch a web page inside postgresql
- send webhook notifications from the database
- urlencode query parameters in sql
- consume rest apis from postgres

## When to choose
- you need to call external APIs directly from SQL or triggers
- you want to avoid moving data out of the database to make HTTP calls
- you need simple webhook or service-poke behavior on data changes

## When to avoid
- you need async, high-throughput, or streaming HTTP workloads
- you want to keep network I/O out of your database process for reliability or security reasons
- you need a general-purpose HTTP client outside PostgreSQL

## Facets
- artifact type: plugin
- maturity: active
- function: http-client, database, webhook
- domain: databases, web-development, developer-tools
- platform: windows
- tags: postgresql-extension, sql, c-extension, http-requests, triggers, linux, macos, postgresql

## Member repositories
- pramsey/pgsql-http (main) score 85

## Provenance
- Observed fields: from GitHub, fetched 2026-08-28T04:05:08.782579+00:00.
- Health v2: computed from the inputs above; adoption is never an input.
- Inferred fields (summary, facets, guidance): AI-extracted, prompt v1, taxonomy v1, on 2026-08-30T03:54:41.492821+00:00, confidence not recorded.
  - readme: https://github.com/pramsey/pgsql-http (fetched 2026-08-28T04:05:08.782579+00:00, sha 1ad580387442)
- Data as of 2026-08-30T08:39:29.467469+00:00.