Claimable Postgres

What it does

When your agent uses it

• Quick Postgres environments and throwaway DATABASEURL for prototyping
• Tasks that involve Prototyping

Example prompts

• “/claimable-postgres”

Requirements

• Node.js

Workflow steps

3 steps, taken from the first numbered list in SKILL.md.

1. 1Remove or comment out the existing line, then rerun.
2. 2Use --env to write to a different file (e.g. --env .env.local).
3. 3Use --key to write under a different variable name.

What it can do on your machine

Read from SKILL.md and the folder at commit 568d7a5. It shows what the files ask for, not the result of running them.

• Tool permissions

  Pre-approves nothing: there is no allowed-tools line, so your agent's usual permission prompts apply.

  From allowed-tools in the SKILL.md frontmatter.

• Runs code

  Shell commands in SKILL.md call:

  • npx
  • curl
  • psql
  • yarn
  • pnpm
  • bunx
  • deno
  • npm

  From the folder's file list and the shell code blocks in SKILL.md.

• Network

  Hosts in commands or code, which the agent is likely to contact:

  • pg.new

  Also links to:

  • neon.com

  From URLs in SKILL.md, links to its own repository left out.

• Credentials

  Names no API keys, tokens, secrets or passwords.

  From names ending in _API_KEY, _TOKEN, _SECRET, _KEY or _PASSWORD in SKILL.md.

Context cost

Claimable Postgres loads about 2.4k tokens when it runs. Until then it costs about 55 tokens; SKILL.md has 1,110 words of instructions outside code blocks.

Always · name and description, kept in context so the agent knows when to use it

~55

When it runs · the whole SKILL.md, loaded when a task matches

~2.4k

Estimates: characters ÷ 4, the usual rule of thumb; real counts depend on the model's tokenizer. Scripts and assets cost tokens only if the agent reads them.

Safety

• NoteMentions a .env fileSKILL.md:20

  te `connection_string` to the project's `.env` as `DATABASE_URL`.

• NoteMentions a .env fileSKILL.md:27

  b@latest --yes`): Provisions and writes `.env` in one command. Convenient when Node.js is available and the user wants a

• NoteMentions a .env fileSKILL.md:88

  ase and writes the connection string to `.env` in one step. Always use `@latest` and `--yes` (skips interactive prompts

• NoteMentions a .env fileSKILL.md:92

  hosen key) already exists in the target `.env`. The CLI exits without provisioning if it finds the key.

• NoteMentions a .env fileSKILL.md:97

  o write to a different file (e.g. `--env .env.local`).

• NoteMentions a .env fileSKILL.md:107

  | `--env` | `-e` | .env file path | `./.env` |

• NoteMentions a .env fileSKILL.md:118

  The CLI writes to the target `.env`:

• NoteMentions a .env fileSKILL.md:152

  4. **Write .env:** Write `DATABASE_URL=<connection_string>` to the project's `.env` (or the user's preferred file and ke

• NoteMentions a .env fileSKILL.md:162

  1. **Check .env:** Check the target `.env` for an existing `DATABASE_URL` (or chosen key). If present, do not run. Offer

• NoteMentions a .env fileSKILL.md:167

  db@latest --yes --ref agent-skills --env .env.local --seed ./schema.sql

Automated static check — not a guarantee. Review scripts before installing. It scans the text of SKILL.md for risky patterns (piping downloads into a shell, reading credential files, hidden Unicode, destructive commands); files beside SKILL.md are not scanned.

SKILL.md

The full file from henryalouf/ruflow at commit 568d7a5, republished under its MIT licence (© henryalouf). 1,110 words, ~2,443 tokens.

name

claimable-postgres

description

Provision instant temporary Postgres databases via Claimable Postgres by Neon (pg.new). No login or credit card required. Use for quick Postgres environments and throwaway DATABASE_URL for prototyping.

risk

unknown

source

community

curl -s -X POST "https://pg.new/api/v1/database" \
  -H "Content-Type: application/json" \
  -d '{"ref": "agent-skills"}'

curl -s -X POST "https://pg.new/api/v1/database" \
  -H "Content-Type: application/json" \
  -d '{"ref": "agent-skills"}'

{
  "id": "019beb39-37fb-709d-87ac-7ad6198b89f7",
  "status": "UNCLAIMED",
  "neon_project_id": "gentle-scene-06438508",
  "connection_string": "postgresql://...",
  "claim_url": "https://pg.new/claim/019beb39-...",
  "expires_at": "2026-01-26T14:19:14.580Z",
  "created_at": "2026-01-23T14:19:14.580Z",
  "updated_at": "2026-01-23T14:19:14.580Z"
}

curl -s "https://pg.new/api/v1/database/{id}"

npx get-db@latest --yes

DATABASE_URL=postgresql://...              # pooled (use for application queries)
DATABASE_URL_DIRECT=postgresql://...       # direct (use for migrations, e.g. Prisma)
PUBLIC_POSTGRES_CLAIM_URL=https://pg.new/claim/...

import { instantPostgres } from 'get-db';

const { databaseUrl, databaseUrlDirect, claimUrl, claimExpiresAt } = await instantPostgres({
  referrer: 'agent-skills',
  seed: { type: 'sql-script', path: './init.sql' },
});

© henryalouf, MIT. Rendered from Markdown: HTML in the file is shown as text, images as links, and headings moved down two levels. Raw file

Files

Just SKILL.md in .agents/skills/claimable-postgres of henryalouf/ruflow.

Open the folder on GitHubat commit 568d7a5