A workflow for using Supabase Postgres, a hosted PostgreSQL database service, in a project. It covers connections, local tools, schema migrations, generated types, row-level security, and file storage buckets.

Use it to create or connect a Supabase database, run migrations, generate types, configure row-level security policies, and set up storage.

It helps avoid using the wrong database connection for a task and documents setup details that can cause migration or runtime failures.

supabase-db — Skill for Claude Code by textura-agency

Install

Getting it into your agent

One page per mod, every tool's command on it. A separate URL per tool would split the same page into five that compete with each other.

Any agent

npx skills add textura-agency/next16-claude-starter --skill supabase-db

Clone the repo

git clone --depth 1 https://github.com/textura-agency/next16-claude-starter

Made for: Claude Code.

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.

README.md

[![agentmods](https://agentmods.dev/badge/skills/textura-agency/next16-claude-starter/supabase-db/github.svg)](https://agentmods.dev/skills/textura-agency/next16-claude-starter/supabase-db)

Your own site

<a href="https://agentmods.dev/skills/textura-agency/next16-claude-starter/supabase-db"><img src="https://agentmods.dev/badge/skills/textura-agency/next16-claude-starter/supabase-db/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.

Your own site · 80×15

<a href="https://agentmods.dev/skills/textura-agency/next16-claude-starter/supabase-db"><img src="https://agentmods.dev/badge/skills/textura-agency/next16-claude-starter/supabase-db.svg" alt="Reviewed on agentmods" width="80" height="20"></a>

Per session 89 Skills are progressive disclosure: only the name and description are preloaded; the body loads when the skill is used.

When invoked 1,308 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. Third-party audits

NVIDIA SkillSpector warn 7 Sept 2026

SkillSpector: 1 finding, up to medium

These are SkillSpector’s own severities. On a checked sample its high-severity flags on skills were ~96% false positives — a documented command, a public API, a “never do X” rule — so we show them as a caution to read, not a verdict. Why →

medium MCP Rug Pull · line 50
npx commands without a version suffix (e.g. @1.0.0) create a rug-pull risk if the upstream server is compromised and publishes a malicious update.

Fix: Pin the version: npx @scope/[email protected]

How audits are shown

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.

Model	Per session	Once invoked
Fable 5.1	$0.00089	$0.01308
Opus 5.5	$0.00036	$0.00523
Sonnet 5.5	$0.00018	$0.00262
Haiku 4.5	$0.00009	$0.00131

Measured 2mo ago against content hash 051c7427ea94, method: parsed. Prices are Anthropic first-party input rates as of 2026-10-07, from the pricing page.

Security

Grade A, and why

supabase-db 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 2mo 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.

.claude/skills/supabase-db/SKILL.md · 116 lines

How it starts

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

Supabase Postgres

Supabase is the database for this project. In a Payload build it is Payload's Postgres; in a bespoke build it is queried directly. Either way the connection rules below are what break first.

Verified 2026-08 against @supabase/supabase-js 2.112, @supabase/ssr 0.12.

1. Connection strings — pick per job, not per project

Supabase hands you several strings. They are not interchangeable.

Job	Connection	Port	Why
App runtime on serverless / Fluid Compute	Supavisor transaction	6543	many short-lived connections
Migrations, `payload migrate`, `psql`, `pg_dump`	Direct	5432	needs session state + DDL
Long-lived Node server, IPv4-only network	Supavisor session	5432	pooled but session-safe

Two traps:

Transaction mode (6543) does not support prepared statements. Symptoms: prepared statement "s0" already exists, or intermittent failures under load. Disable prepared statements in the client for that URL.
Direct connections are IPv6 by default. On an IPv4-only network (many CI runners) they fail to resolve — use the session pooler, or add the IPv4 add-on.

Store both: DATABASE_URL (6543, runtime) and DATABASE_URL_DIRECT (5432, migrations). Wire both into src/env.ts as server-only zod-validated vars.

2. Keys — use the new ones

Legacy anon / service_role JWTs are being retired (end of 2026). Use:

Publishable sb_publishable_… → NEXT_PUBLIC_SUPABASE_PUBLISHABLE_KEY. Browser-safe only because RLS is enforced. It is not a secret, but it is also not protection.
Secret sb_secret_… → server-only, via getServerEnv(). Bypasses RLS entirely. Never NEXT_PUBLIC_, never import into a client component, never log it. Supabase now 401s a secret key sent from a browser user-agent, but do not rely on that as your control.

3. Local workflow

brew install supabase/tap/supabase        # or npx supabase
supabase init                             # creates supabase/
supabase link --project-ref <ref>
supabase start                            # local Postgres + Studio in Docker
supabase db pull                          # snapshot remote schema into a migration
supabase migration new <name>             # hand-written SQL migration
supabase db push                          # apply migrations to the linked project
supabase gen types typescript --linked > src/types/database.ts

Read the full file on GitHub · 116 lines

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.

2mo ago First seen · 116 lines · 89 tokens per session scan A 051c7427ea94

Subscribe to this mod's changes

supabase-db is a skill published in the GitHub repository textura-agency/next16-claude-starter (145 stars, last pushed 23d ago), licensed Unlicense. It adds 89 tokens to every session and 1,308 once invoked, about $0.0004 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-08-30.

Backend and APIs Databases PostgreSQL

supabase-db next to 6 skills from other repositories
Mod	Type	Stars	Last push	Licence	Scan	Tokens	Works with
supabase-dbtextura-agency/next16-claude-starter	Skill	145	23d ago	Unlicense	A	89	Claude Code
azure-postgres-tsmicrosoft/skills	Skill	3.2k	yesterday	MIT	A	94	Claude Code
supabasesupabase/agent-skills	Skill	3.0k	yesterday	MIT	A	185	Claude Code, Codex
butterbasebutterbase-ai/butterbase	Skill	3.0k	yesterday	Apache-2.0	A	34	Claude Code, Codex
supabase-clifcakyon/claude-codex-settings	Skill	1.2k	yesterday	Apache-2.0	A	60	Claude Code
supabase-jsfcakyon/claude-codex-settings	Skill	1.2k	yesterday	Apache-2.0	A	64	Claude Code
firebase-data-connectfirebase/agent-skills	Skill	503	2d ago	Apache-2.0	A	74	Claude Code