How do I install the Claim Url Lookup skill?

Run npx skillmds@latest add wodsmith/claim-url-lookup 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 Claim Url Lookup safe to use?

This skill has not completed SkillMD's automated safety review yet. SkillMD never runs a skill's scripts for you; review the SKILL.md before installing.

Which AI agents work with Claim Url Lookup?

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 Claim Url Lookup free to use?

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

Who published Claim Url Lookup?

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

Claim Url Lookup by wodsmith — Agent Skill

Name: Claim Url Lookup
Author: wodsmith

Claim Url Lookup

Look up claim URLs for placeholder users created via manual registration. Use when needing to find the sign-up claim link for a specific email address, debug claim token issues, or verify claim tokens exist in local KV. Triggers on "claim URL", "claim token", "claim link", "placeholder user sign-up link", or requests to find the registration invite link for an email.

wodsmith Updated Sep 17, 2026

File contents

Claim URL Lookup

Look up the claim URL for a placeholder user by email address.

Process

1. Find the user ID via PlanetScale

Query the users table on the appropriate branch (usually dev) using the PlanetScale MCP tool:

SELECT id, email FROM users WHERE email = '<email>'

Use mcp__planetscale__planetscale_execute_read_query with:

organization: wodsmith
database: wodsmith-db
branch: dev (or whichever branch is relevant)

2. Query local KV for claim tokens

The KV SQLite database is at:

apps/wodsmith-start/.alchemy/local/.wrangler/state/v3/kv/miniflare-KVNamespaceObject/f35c41ba47d70351a0716642bf2c0bfea862895102f4c8ac3bc512bfca72c8d4.sqlite

Query for all claim tokens:

sqlite3 "<path-to-kv-sqlite>" "SELECT key, blob_id FROM _mf_entries WHERE key LIKE 'claim-token:%';"

This returns rows like: claim-token:<token>|<blob_id>

3. Read blob files to match userId

Blob files are stored at:

apps/wodsmith-start/.alchemy/local/.wrangler/state/v3/kv/e971afc3bbb149bd93cbd5a4f993869a/blobs/<blob_id>

Each blob contains JSON: {"userId":"usr_...","expiresAt":"..."}.

Read each blob file and find the one whose userId matches the user from step 1.

4. Construct the claim URL

The claim URL format is:

{APP_URL}/sign-up?claim=<token>

Where <token> is the portion after claim-token: in the KV key.

Key files

Token generation: src/utils/auth-utils.ts — createToken (CUID2 length 32), getClaimTokenKey
Token storage: src/server-fns/registration-fns.ts — stores in KV at registration time with 90-day TTL
URL construction: src/server/registration.ts — builds {getSiteUrl()}/sign-up?claim={token}
Sign-up consumption: src/server-fns/auth-fns.ts — validates and consumes claim token during sign-up

---name: claim-url-lookupdescription: Look up claim URLs for placeholder users created via manual registration. Use when needing to find the sign-up claim link for a specific email address, debug claim token issues, or verify claim tokens exist in local KV. Triggers on "claim URL", "claim token", "claim link", "placeholder user sign-up link", or requests to find the registration invite link for an email.---# Claim URL LookupLook up the claim URL for a placeholder user by email address.## Process### 1. Find the user ID via PlanetScaleQuery the `users` table on the appropriate branch (usually `dev`) using the PlanetScale MCP tool:```sqlSELECT id, email FROM users WHERE email = '<email>'```Use `mcp__planetscale__planetscale_execute_read_query` with:- organization: `wodsmith`- database: `wodsmith-db`- branch: `dev` (or whichever branch is relevant)### 2. Query local KV for claim tokensThe KV SQLite database is at:```apps/wodsmith-start/.alchemy/local/.wrangler/state/v3/kv/miniflare-KVNamespaceObject/f35c41ba47d70351a0716642bf2c0bfea862895102f4c8ac3bc512bfca72c8d4.sqlite```Query for all claim tokens:```sqlsqlite3 "<path-to-kv-sqlite>" "SELECT key, blob_id FROM _mf_entries WHERE key LIKE 'claim-token:%';"```This returns rows like: `claim-token:<token>|<blob_id>`### 3. Read blob files to match userIdBlob files are stored at:```apps/wodsmith-start/.alchemy/local/.wrangler/state/v3/kv/e971afc3bbb149bd93cbd5a4f993869a/blobs/<blob_id>```Each blob contains JSON: `{"userId":"usr_...","expiresAt":"..."}`.Read each blob file and find the one whose `userId` matches the user from step 1.### 4. Construct the claim URLThe claim URL format is:```{APP_URL}/sign-up?claim=<token>```Where `<token>` is the portion after `claim-token:` in the KV key.## Key files- Token generation: `src/utils/auth-utils.ts` — `createToken` (CUID2 length 32), `getClaimTokenKey`- Token storage: `src/server-fns/registration-fns.ts` — stores in KV at registration time with 90-day TTL- URL construction: `src/server/registration.ts` — builds `{getSiteUrl()}/sign-up?claim={token}`- Sign-up consumption: `src/server-fns/auth-fns.ts` — validates and consumes claim token during sign-up

Frequently asked questions