How do I install the Postkit skill?

Run npx skillmds@latest add diegosouzapw/postkit in your terminal (requires Node.js), paste this page's agent-chat prompt into Claude, Cursor, or any MCP-connected agent, or download the SKILL.md file and copy it into your agent's skills directory.

Is Postkit safe to use?

This skill has not completed SkillMD's automated safety review yet. Independent scanners report: SkillSpector: PASS, Skill Scanner: PASS. Capability flags: makes network calls. SkillMD never runs a skill's scripts for you; review the SKILL.md before installing.

Which AI agents work with Postkit?

This skill is tagged as working with Claude Code, Claude.ai, OpenAI Codex. SKILL.md is an open format, so most agents that read a skills directory can load it too.

Is Postkit free to use?

Yes. Installing skills from SkillMD is free, and the skill stays under its author's original license.

Who published Postkit?

diegosouzapw (@diegosouzapw) published this skill. Their other Agent Skills are listed on their SkillMD profile.

Postkit by diegosouzapw — Agent Skill

Name: Postkit
Rating: 4.5 (4 reviews)
Author: diegosouzapw

Postkit

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).

diegosouzapw Updated Sep 8, 2026 54 repo stars

File contents

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
# 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 -e "./postkit/sdk[binary]"

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

Read postkit/AGENTS.md for multi-tenancy, hashing, login flows, and module API maps
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`

---name: postkitdescription: 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:```bash[ -d postkit ] || git clone https://github.com/varunchopra/postkit.git```Then build the dist files:```bashcd postkit && make build && cd ..```Install the SQL schema on the user's database:```bashpsql $DATABASE_URL -f postkit/dist/postkit.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:```bashpip install -e "./postkit/sdk[binary]"```## 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+## Instructions1. Read `postkit/AGENTS.md` for multi-tenancy, hashing, login flows, and module API maps2. 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` |

Frequently asked questions