supabase-schema-generator

supabase-schema-generator is a skill for Claude Code, Codex from aragaobruno/toolbelt. It costs 0 tokens per session (335 once invoked), scanned A, original, MIT.

A generator that reads a Supabase SQL database schema and creates TypeScript database types and Row Level Security policies. Supabase is a hosted database platform, and Row Level Security controls which users can access which rows.

In plain words
What is it for?
Use it to generate TypeScript interfaces for frontend code and SQL policies for Supabase tables. It takes a schema file and writes the generated files to paths you choose.
Why use it?
It keeps frontend types aligned with database tables and provides database access rules from the same schema. This reduces manual copying and missed security policies.

Skill for Claude CodeCodex

Written for no agent in particular: nothing here depends on one.

Good fit Use it to generate TypeScript interfaces for frontend code and SQL policies for Supabase tables. It takes a schema file and writes the generated files to paths you choose.

Compare 6 skills from other repositories ↓
Install with agentmods
npx agentmods add skills/aragaobruno/toolbelt/supabase-schema-generator
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 aragaobruno/toolbelt --skill supabase-schema-generator
Clone the repo
git clone --depth 1 https://github.com/aragaobruno/toolbelt

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-schema-generator

README.md
[![agentmods](https://agentmods.dev/badge/skills/aragaobruno/toolbelt/supabase-schema-generator/github.svg)](https://agentmods.dev/skills/aragaobruno/toolbelt/supabase-schema-generator)
Your own site
<a href="https://agentmods.dev/skills/aragaobruno/toolbelt/supabase-schema-generator"><img src="https://agentmods.dev/badge/skills/aragaobruno/toolbelt/supabase-schema-generator/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 supabase-schema-generator

Your own site · 80×15
<a href="https://agentmods.dev/skills/aragaobruno/toolbelt/supabase-schema-generator"><img src="https://agentmods.dev/badge/skills/aragaobruno/toolbelt/supabase-schema-generator.svg" alt="Reviewed on agentmods" width="80" height="20"></a>
Per session 0 Skills are progressive disclosure: only the name and description are preloaded; the body loads when the skill is used.
When invoked 335 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.00000 $0.00335
Opus 5 $0.00000 $0.00168
Sonnet 5 $0.00000 $0.00067
Haiku 4.5 $0.00000 $0.00034

Measured 9d ago against content hash fab1b365a511, method: parsed. Prices are Anthropic first-party input rates as of 2026-09-09, from the pricing page.

Security

Grade A, and why

supabase-schema-generator 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 9d ago.

The scan reads SKILL.md. This mod also ships 2 executable files (scripts/generator.py, scripts/test_generator.py), listed below but not scanned — reading those needs a real analyzer, not pattern matching.

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.

skills/automation/supabase-schema-generator/SKILL.md · 39 lines

What it actually says

🗄️ Skill: supabase-schema-generator

An SRE-grade automation skill to parse SQL schemas and auto-generate safe TypeScript interfaces for the frontend and Row Level Security (RLS) policies for Supabase.


🛠️ Triggers

This skill is triggered when an agent or developer needs to translate database tables into frontend types, secure Supabase tables, or generate RLS scripts.

  • "generate supabase rls"
  • "build typescript database types"
  • "run supabase-schema-generator"
  • "create db types"

🚀 Usage Guide

Requirements

  • Python (3.10+)
  • google-genai package installed (via uv)
  • A valid GEMINI_API_KEY defined in the environment or in the global .hermes/.env file.

Command Execution

Run the script using uv run from the repository root:

# Generate types and RLS policies from schema.sql
uv run --with google-genai skills/automation/supabase-schema-generator/scripts/generator.py \
  --schema database_schema.sql \
  --output-types src/types/database.ts \
  --output-rls supabase/migrations/policies.sql

Options

  • -s, --schema: Path to the input SQL schema file (required).
  • -t, --output-types: Path to save the generated TypeScript types (default: types.ts).
  • -r, --output-rls: Path to save the generated RLS SQL script (default: policies.sql).
Files

What ships with it

2 files 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. 9d ago First seen · 39 lines · 0 tokens per session scan A fab1b365a511

Subscribe to this mod's changes

supabase-schema-generator is a skill published in the GitHub repository aragaobruno/toolbelt (2 stars, last pushed 1mo ago), licensed MIT. It costs nothing until one of its globs matches a file; then it loads 335 tokens. 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-31.

Related

Other skills, from other repositories

drizzle-orm-expert

Expert in Drizzle ORM for TypeScript — schema design, relational queries, migrations, serverless DB integration. Use when building type-safe database layers with Drizzle, migrating from Prisma, or optimizing edge runtime DB access.

RaNDoM6913/claude-code-superkit · 50 tokens

database-orm-expert

Expert guide for database schema design, ORM tools (Prisma 6, Drizzle ORM, TypeORM), migrations, query optimization, and type-safe SQL patterns in TypeScript / Panduan ahli untuk desain skema database, ORM tools (Prisma 6, Drizzle ORM, TypeORM), migrasi, optimasi query, dan pola SQL type-safe di TypeScript.

roedyrustam/vibes-plug · 82 tokens

fluent-development

This skill should be used when the user asks to "build a fluent app", "create a servicenow app in typescript", or mentions "servicenow sdk", "now-sdk", "fluent", "scoped app as code", or "pro-code development" — or when the working directory contains a now.config.json or .now.ts files.

serac-labs/serac · 77 tokens

drizzle-knowledge-patch

Use this skill when work touches Drizzle SQL identifiers or aliases, Drizzle Kit module loading, or Zod schemas generated from Drizzle tables.

Nevaberry/nevaberry-plugins · 10 tokens

drizzle-orm

Drizzle ORM best practices. Use when configuring databases, designing schemas, writing queries, or handling migrations with Drizzle ORM, particularly with Cloudflare D1 or SQLite. NOT for database setup without an explicit engine. Require engine specification (Postgres/MySQL/SQLite). Use for ORM-managed migrations.

neverinfamous/memory-journal-mcp · 65 tokens

azure-postgres-ts

Connect to Azure Database for PostgreSQL Flexible Server from Node.js/TypeScript using the pg (node-postgres) package.

tmolavi/mcp-agent-skills-hub · 30 tokens