Set up PostgreSQL-native auth, authorization, config, metering, and job queues via SQL functions.
npx skills add https://github.com/varunchopra/postkit --skill postkit
Please help me install this Agent Skill. Skill: postkit Source: https://github.com/varunchopra/postkit/tree/main Command: npx skills add https://github.com/varunchopra/postkit --skill postkit
This Skill solves the challenge of building production-ready authentication, authorization, versioned configuration, usage metering, and background job queues without wiring multiple external services.
Run make build to generate dist SQL files, then install the schema with psql $DATABASE_URL -f postkit/dist/postkit.sql, and finally call the relevant functions (for example authz.check for permission checks) using your database connection.
High-intent search queries and answers about installing and using this skill.
You can implement authentication and authorization directly in Postgres by installing deterministic SQL functions that handle user sessions, tokens, and ReBAC relationship-based permission checks natively within your database.
Yes, you can handle usage metering and job queues in Postgres by using native SQL functions for reservation-based quota accounting and retryable background job scheduling without wiring multiple external services.
The best way to manage versioned configuration rollbacks in a multi-tenant SaaS database is using SQL functions that store key-value settings with rollback capabilities, enabling rapid configuration changes and prompt rollbacks.
You set up Postgres-native identity and permissions by building dist SQL artifacts with make, installing them into a PostgreSQL 14+ database, and invoking module functions with the correct tenant context during your app workflow.
No, you do not need external tools for ReBAC permission checks if you have a Postgres database, because native SQL functions can evaluate relationship-based permissions directly using your existing database connection and driver.
A limitation of using Postgres SQL functions for authentication and metering is the requirement to build dist SQL artifacts and install them into a PostgreSQL 14+ database, which requires a build step and specific database version compatibility.
systempromptioAutomate PostgreSQL schema exploration, SQL queries, write operations, and migrations.
Zoppy-crmCreate BullMQ queue processors and services with session propagation and retry behavior.
robotijnImplement Postgres Row-Level Security policies to enforce tenant scoping in multi-tenant SaaS databases.
slantviewDevelop scalable backend services with RESTful and GraphQL APIs and microservices.
