# jkehler/awslambda-psycopg2

Repository: https://github.com/jkehler/awslambda-psycopg2
Canonical: https://ross.abutalabs.com/products/awslambda-psycopg2
Language: Python
License Family: other
Last push: 2024-06-09T06:28:29+00:00

## Health v2 (maintenance only)
Score: 32/100 (v2, computed 2026-09-02T17:46:02.011165+00:00)
- activity 0, release rhythm 35, longevity 100
- inputs: {"age_days": 3968, "days_push": 815, "days_rel": null, "gap_med": null, "n_releases_24m": 0}
- flags: no_releases, no_license
- formula: round(0.45*activity + 0.35*rhythm + 0.20*longevity); archived -> min(score, 10)

## Adoption (not part of the score)
Stars 1140, forks 354 (observed 2026-08-28T04:03:44.359265+00:00)

## What it is
A pre-compiled psycopg2 PostgreSQL driver for Python, built with libpq statically linked so it works inside AWS Lambda's runtime environment. Users copy the provided psycopg2 directory into their Lambda deployment package to connect to PostgreSQL.

## Use cases
- connect to postgres from aws lambda
- use psycopg2 in lambda without missing libpq
- prebuilt psycopg2 package for python 3.11 lambda
- statically link libpq for serverless deployment
- query postgresql database from serverless function

## When to choose
- you need psycopg2 in AWS Lambda and don't want to compile it yourself
- you want a quick drop-in directory for your Lambda zip package

## When to avoid
- you deploy on EC2, ECS, or any environment with standard PostgreSQL libraries
- you need the latest psycopg2 version or active maintenance
- you use Lambda layers or container images where you can build your own

## Facets
- artifact type: library
- maturity: maintenance
- function: database-driver, database
- domain: databases, cloud-computing, backend
- platform: python, cloud, serverless
- tags: aws-lambda, psycopg2, postgresql, statically-linked, prebuilt

## Member repositories
- jkehler/awslambda-psycopg2 (main) score 32

## Provenance
- Observed fields: from GitHub, fetched 2026-08-28T04:03:44.359265+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-30T06:35:31.116268+00:00, confidence not recorded.
  - readme: https://github.com/jkehler/awslambda-psycopg2 (fetched 2026-08-28T04:03:44.359265+00:00, sha 82e04dfeb122)
  - registry_pypi: https://pypi.org/pypi/awslambda-psycopg2/json (fetched 2026-08-29T12:40:40.734070+00:00, sha 2f29fe4a0f86)
- Data as of 2026-08-30T08:39:29.467469+00:00.