supabase

supabase is a skill for Claude Code, Codex from Kastalien-Research/thoughtbox. It costs 41 tokens per session (1,473 once invoked), scanned A, original, MIT.

A skill for managing Supabase, a service that provides databases and related backend infrastructure. It handles local and hosted database status, schema changes, migrations, and deployment through the Supabase command-line tool.

In plain words
What is it for?
Use it to check database status, create migrations, compare the schema with migration files, inspect migration history, and push migrations to the hosted project.
Why use it?
It helps keep database changes tracked in migration files and reveals differences between the local database, hosted database, and recorded migrations.

Skill for Claude CodeCodex

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.

agentmods
npx agentmods add skills/kastalien-research/thoughtbox/supabase
Any agent
npx skills add Kastalien-Research/thoughtbox --skill supabase
Clone the repo
git clone --depth 1 https://github.com/Kastalien-Research/thoughtbox

Made for: Claude Code, 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 supabase

README.md
[![agentmods](https://agentmods.dev/badge/skills/kastalien-research/thoughtbox/supabase.svg)](https://agentmods.dev/skills/kastalien-research/thoughtbox/supabase)
Your own site
<a href="https://agentmods.dev/skills/kastalien-research/thoughtbox/supabase"><img src="https://agentmods.dev/badge/skills/kastalien-research/thoughtbox/supabase.svg" alt="Measured on agentmods" height="20"></a>
Per session 41 Skills are progressive disclosure: only the name and description are preloaded; the body loads when the skill is used.
When invoked 1,473 The whole file, excluding the scripts and references it only reads on demand.
Security scan A 0 findings. Scan, not verified.
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 $0.00041 $0.01473
Opus 5 $0.00020 $0.00737
Sonnet 5 $0.00008 $0.00295
Haiku 4.5 $0.00004 $0.00147

Measured 4d ago against content hash f4955e88524a, method: parsed. Prices are Anthropic first-party input rates as of 2026-08-30, from the pricing page.

Security

Grade A, and why

supabase 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 4d 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.

.agents/skills/supabase/SKILL.md · 142 lines

How it starts

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

Manage Supabase: $ARGUMENTS

Project Context

  • Linked project: Thoughtbox (akjccuoncxlvrrtkvtno, West US Oregon)
  • Local DB URL: postgresql://postgres:[email protected]:54322/postgres
  • Migrations dir: supabase/migrations/
  • Config: supabase/config.toml

Commands

Parse the first word of $ARGUMENTS to determine the command:

status — Show local and hosted state

  1. Run supabase status for local container health
  2. Run supabase migration list to show local vs remote migration drift
  3. Report: which migrations are local-only, remote-only, or synced

migrate — Create a new migration

Parse remaining arguments for the migration name.

  1. Run supabase migration new <name> to create the file
  2. Open the created file path for editing
  3. Remind: after writing SQL, run /supabase diff to verify, then /supabase push to deploy

diff — Diff local schema against migrations

  1. Run supabase db diff to show schema changes not captured in migrations
  2. If changes exist, offer to create a migration capturing them
  3. If clean, report "Schema in sync with migrations"

push — Push migrations to hosted project

  1. Run supabase migration list to show what will be pushed
  2. List the pending migrations and their filenames
  3. Ask for confirmation before proceeding — this modifies the hosted database
  4. Run supabase db push to apply
  5. Run supabase migration list again to confirm sync

pull — Pull remote schema to local migrations

  1. Run supabase db pull to generate a migration from remote schema changes
  2. Show the generated migration file
  3. Remind: review the SQL before committing

reset — Reset local database to migrations

  1. Confirm the user wants to destroy local data
  2. Run supabase db reset to drop and re-apply all migrations
  3. Report success and migration count

inspect — Inspect hosted database

Parse remaining arguments for the inspection type. Default to db-stats.

Available inspections:

  • db-stats — Size, cache hit rates, WAL size
  • table-stats — Table sizes and row counts
  • index-stats — Index usage and bloat
  • outliers — Slowest queries
  • locks — Active locks
  • bloat — Table and index bloat estimates
  • role-stats — Role information

Read the full file on GitHub · 142 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.

  1. 4d ago First seen · 142 lines · 41 tokens per session scan A f4955e88524a

Subscribe to this mod's changes

supabase is a skill published in the GitHub repository Kastalien-Research/thoughtbox (64 stars, last pushed 1mo ago), licensed MIT. It adds 41 tokens to every session and 1,473 once invoked, about $0.0002 per session on Opus 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.

Related

Other skills, from other repositories

api-canvas

DataCanvas primitive reference — a Tier 3 SQL/analytical workspace for tabular MCP servers, backed by DuckDB. Use when registering tables from upstream APIs, running ad-hoc SQL across them, and exporting results. Covers the acquire → register → query → export flow, per-table TTL, the token-sharing pattern for…

cyanheads/obsidian-mcp-server · 85 tokens

api-mirror

Stand up a persistent, self-refreshing local mirror of a bulk upstream dataset with the MirrorService (@cyanheads/mcp-ts-core/mirror). Use when a server wraps a large or slow API and should query a synced local index (embedded SQLite + FTS5) instead of paginating the live API per request.

cyanheads/obsidian-mcp-server · 68 tokens

add-provider

Add a new storage or service provider to the core package. Use when implementing a new backend for StorageService (e.g., a new database) or a new service provider (e.g., a new LLM backend).

cyanheads/mcp-ts-core · 47 tokens

gliderecord-patterns

Write efficient ServiceNow GlideRecord queries — addQuery vs addEncodedQuery, setLimit, GlideAggregate for counts, avoiding N+1 in loops, query operators, and safe CRUD with workflow control.

serac-labs/serac · 46 tokens

bulk-update

Update properties or content across many pages in a Notion database with dry-run and error recovery.

n24q02m/better-notion-mcp · 21 tokens

organize-database

Transform unstructured Notion pages into a well-designed database with proper schema and migration.

n24q02m/better-notion-mcp · 21 tokens