PostgreSQL natif: identité, config, compteurs, files d'attente

---

name: postkit description: PostgreSQL-native identity, configuration, metering, and job queues. SQL functions that work with any language or driver. Use when working with user management, sessions, permissions, access control, login/logout, MFA, password resets, relationship-based access, versioned configuration, prompts, usage tracking, quotas, billing periods, or background jobs in PostgreSQL. Covers authn (user/session management), authz (ReBAC permissions), config (versioned key-value storage), meter (usage tracking with reservations), and queue (job scheduling with retries and dead letters).

Setup (REQUIRED FIRST STEP)

Clone the repository if not already present:

[ -d postkit ] || git clone https://github.com/varunchopra/postkit.git

Then build the dist files:

cd postkit && make build && cd ..

Install the SQL schema on the user's database:

psql $DATABASE_URL -f postkit/dist/postkit.sql
# memory is separate and needs pgvector: psql $DATABASE_URL -f postkit/dist/memory.sql
# Or individual modules: postkit/dist/authn.sql, postkit/dist/authz.sql, postkit/dist/config.sql, postkit/dist/meter.sql, postkit/dist/queue.sql

For the optional Python SDK:

pip install postkit

Requirements

All languages (SQL functions):

• PostgreSQL 14+
• Schema installed from dist/ files

Python SDK only (optional wrapper):

• psycopg>=3.1.0 (not psycopg2)
• Python 3.11+

Instructions

1. Read postkit/AGENTS.md for multi-tenancy, hashing, login flows, and module API maps
2. Read the relevant module docs based on what the user needs:
   • Authentication (users/sessions): postkit/docs/authn/
   • Authorization (permissions): postkit/docs/authz/
   • Configuration (versioned key-value): postkit/docs/config/
   • Metering (usage tracking, quotas): postkit/docs/meter/
   • Job Queues (scheduling, retries): postkit/docs/queue/

Documentation Map

| What you need | Where to look | |---------------|---------------| | Integration guide | postkit/AGENTS.md | | authn SQL reference | postkit/docs/authn/sql.md | | authn Python SDK | postkit/docs/authn/sdk.md | | authz SQL reference | postkit/docs/authz/sql.md | | authz Python SDK | postkit/docs/authz/sdk.md | | config SQL reference | postkit/docs/config/sql.md | | config Python SDK | postkit/docs/config/sdk.md | | meter SQL reference | postkit/docs/meter/sql.md | | meter Python SDK | postkit/docs/meter/sdk.md | | queue SQL reference | postkit/docs/queue/sql.md | | queue Python SDK | postkit/docs/queue/sdk.md |