go-authcrunch: Skill for Codex

.codex/skills/sqlite-registration/SKILL.md

sqlite-registration is a skill for Codex from greenpau/go-authcrunch. It costs 48 tokens per session (2,327 once invoked), scanned A, original, Apache-2.0.

A SQLite-backed registration workflow for creating accounts after a user confirms an email. It includes configuration parsing, optional portal confirmation handling, protected pending credentials, account recovery, and registration-to-login end-to-end tests.

In plain words
What is it for?
Use it to maintain SQLite registration routes, validate their settings, connect an email provider and identity store, handle confirmation links, and test the complete registration and login flow.
Why use it?
It keeps email confirmation and account creation coordinated without an administrative approval step. It also preserves an existing account's later settings, such as being disabled, when an enrollment is recovered.

Skill for Codex

Written for Codex: agents/openai.yaml present.

This is greenpau/go-authcrunch's own configuration. It tells Codex how to work on go-authcrunch itself, so it is not a mod to install elsewhere. Copy it as a starting point and replace the rules that are about this project. Everything go-authcrunch configures →

Needs its repository: it runs a file that does not travel with it, so clone the repository first. The line is make test TEST_DIR='./plugins/registration-workflows/sqlite/... ./pkg/registry ./internal/tag'.

Reuse

Borrowing it

Nothing to install: this file belongs to greenpau/go-authcrunch. Take a copy, put it at the same path in your own repository, and replace the rules that are about this project with yours.

Copy the file
curl -O https://raw.githubusercontent.com/greenpau/go-authcrunch/main/.codex/skills/sqlite-registration/SKILL.md
Clone the repo
git clone --depth 1 https://github.com/greenpau/go-authcrunch

Made for: Codex.

Wrote this? Show the measurements

A badge with what this costs and how it scanned, read live from this page, so it follows the numbers instead of freezing them. Markdown for a README, HTML for a documentation site or a project page.

agentmods badge for sqlite-registration

README.md
[![agentmods](https://agentmods.dev/badge/skills/greenpau/go-authcrunch/sqlite-registration/github.svg)](https://agentmods.dev/skills/greenpau/go-authcrunch/sqlite-registration)
Your own site
<a href="https://agentmods.dev/skills/greenpau/go-authcrunch/sqlite-registration"><img src="https://agentmods.dev/badge/skills/greenpau/go-authcrunch/sqlite-registration/github.svg" alt="Measured on agentmods" height="20"></a>

Or the 80×15 button, for a site that already has a row of RSS and ATOM ones. Only the verdict fits; the numbers stay here.

agentmods 80×15 button for sqlite-registration

Your own site · 80×15
<a href="https://agentmods.dev/skills/greenpau/go-authcrunch/sqlite-registration"><img src="https://agentmods.dev/badge/skills/greenpau/go-authcrunch/sqlite-registration.svg" alt="Reviewed on agentmods" width="80" height="20"></a>
Per session 48 Skills are progressive disclosure: only the name and description are preloaded; the body loads when the skill is used.
When invoked 2,327 The whole file, excluding the scripts and references it only reads on demand.
Security scan A 0 findings. A grade says what 26 rules found in the file — not that it is safe.
Origin original No closer match found in the catalogue.
Token cost

What it costs to keep this loaded

Counted locally with the o200k_base tokenizer, which is exact for GPT models; Claude uses its own tokenizer and its counts differ. Treat this as one consistent yardstick across the catalogue rather than a bill. Prices are per million input tokens.

ModelPer sessionOnce invoked
Fable 5.1 $0.00048 $0.02327
Opus 5.5 $0.00019 $0.00931
Sonnet 5.5 $0.00010 $0.00465
Haiku 4.5 $0.00005 $0.00233

Measured 12d ago against content hash f14f321fbdc2, method: parsed. Prices are Anthropic first-party input rates as of 2026-10-07, from the pricing page.

Security

Grade A, and why

sqlite-registration scanned grade A with 0 findings against 26 rules in 11 categories — prompt injection, anti-refusal, data exfiltration, privilege escalation, supply chain, agent snooping, system-prompt leakage, SSRF and excessive agency — measured 12d ago.

A static scan of the body, not an audit. Every finding is printed with the line that produced it so you can judge whether it matters here. A mod is markdown that instructs an agent; that is exactly why what it instructs is worth reading.

Nothing flagged

None of the 26 patterns this scan looks for appear in this file: no shell pipes, no recursive deletes, no credential paths, no hidden text, no instruction-override or anti-refusal phrasing, no agent-config snooping. That is not a guarantee, it is the absence of the things that are checkable.

.codex/skills/sqlite-registration/SKILL.md · 188 lines

How it starts

The opening of the file, as written. The whole thing — 188 lines — stays where its author put it; the contents beside it link to each section on GitHub.

SQLite Registration

plugins/registration-workflows/sqlite composes the SQLite identity store and message outbox. Its Workflow implements registry.Provider and the optional registry.ConfirmationProvider. Fresh confirmation creates an enabled account with only authp/user; there is no administrative approval step. Recovery of an already-created enrollment preserves subsequent account management changes, including disabled state.

Configuration and attachment

Use parser.NewSQLiteRegistrationConfigFromDirectives([]string). Required: name, absolute path, identity_store, realm, email_provider, and public_origin (a canonical HTTPS origin without path, userinfo, query or fragment; explicit ports must be 1–65535). Optional base_path defaults to /auth; it accepts / or slash-separated ASCII letters/digits/underscore/hyphen segments without a trailing slash, at most 512 bytes. Typed and parser validation also apply portalpath.Validate and the shared reserved mount rules: whole namespace segments (including connected-accounts) and legacy prefixes such as register cannot appear in any mount segment. Unicode and semicolons cannot preserve browser cookie Path scope; SQLite's narrower segment rule stays in force. Realm values remain data. Align the declared host mount with this backend path so confirmation links reach the selected portal; validation does not create routes. Optional timeout defaults to 1s and permits 1ms..30s. Each setting takes one value once. Realm is 1–64 ASCII letters/digits/underscore/hyphen. Parser validation is pure.

Construct New(ctx, config, *accounts.Store, *notifications.Outbox) using the public SQLite identity-store and messaging packages. The store's name/realm must match configuration. The constructor creates an internal messaging binding under email_provider; no host-global lookup occurs. Backend configuration is snapshotted. The workflow owns only its pending database. Supplied account/outbox lifetimes remain with the host. Read the shared private SQLite contract. All three files must be distinct. This plugin uses pure Go and no background job.

Read the full file on GitHub · 188 lines

Files

What ships with it

1 file beside SKILL.md in the same directory: the scripts, references and assets a skill reads on demand. Not counted in the per-session cost; read them before you install if any of them is executable.

Changes

What this file has done since we first saw it

Hashed on every crawl. A supply-chain change to an agent config is a question of when, not whether, so the history is kept rather than the latest state alone.

  1. 12d ago Changed · +35 lines f14f321fbdc2
  2. 26d ago Changed · +24 lines f3197f7e53ed
  3. 29d ago First seen · 129 lines · 48 tokens per session scan A 2a2644499cdf

Subscribe to this mod's changes

sqlite-registration is a skill published in the GitHub repository greenpau/go-authcrunch (60 stars, last pushed 10d ago), licensed Apache-2.0. It adds 48 tokens to every session and 2,327 once invoked, about $0.0002 per session on Opus 5.5. A static security scan graded it A with 0 findings. No closer match exists in the catalogue, so it is treated as the original; first seen 2026-10-08.

Related

sqlite-registration compared with skills from other repositories

sqlite-registration next to 6 skills from other repositories
ModTypeStarsLast pushLicenceScanTokensWorks with
sqlite-registrationgreenpau/go-authcrunchSkill6010d agoApache-2.0A48Codex
reproduce-buggoogleapis/mcp-toolboxSkill17kyesterdayApache-2.0A130Claude Code, Codex
shaft-automated-test-authoringShaftHQ/SHAFT_ENGINESkill418yesterdayMITA40Claude Code, Codex
shaft-database-testingShaftHQ/SHAFT_ENGINESkill418yesterdayMITA32Claude Code, Codex
shaft-test-data-designShaftHQ/SHAFT_ENGINESkill418yesterdayMITA35Claude Code, Codex
etl-validatesfc-gh-dflippo/snowflake-dbt-demoSkill332d agoApache-2.0A59Claude Code
etl-seedsfc-gh-dflippo/snowflake-dbt-demoSkill332d agoApache-2.0A53Claude Code