supabase-bootstrap

Development

Bootstrap toolkit for new Supabase projects. Use when: (1) Setting up a new Supabase project, (2) Configuring sqlfluff for SQL formatting, (3) Setting up mise task runner, (4) Configuring MCP server for schema access, (5) Initializing project structure

View on GitHub ↗

QUICK START

How to use this skill

Bring this guide into your coding agent with a prompt tailored to the tool you use.

Open your project in Codex.
Copy and paste the prompt below.
Review files and risks before approving any action.

Prompt to paste

Inspect the Agent Skill at https://github.com/majiayu000/claude-skill-registry/blob/HEAD/skills/data/supabase-bootstrap/SKILL.md and all supporting files. Report provenance, permissions, scripts, dependencies, and security risks. Propose an exact installation into .agents/skills/supabase-bootstrap, but wait for my approval before writing files or running scripts.

Copying this prompt does not install or run the skill. Review third-party files before use.

Supabase Project Bootstrap

Toolkit for setting up new Supabase projects with proper tooling.

Quick Start

Copy template files to your Supabase project:

cp assets/mise.toml assets/.sqlfluff assets/.mcp.json /path/to/supabase/

Then configure .mcp.json with your project reference.

Template Files

File	Purpose
`assets/mise.toml`	Task runner (lint, format, psql install)
`assets/.sqlfluff`	SQL formatting config
`assets/.mcp.json`	MCP server for schema access

Setup Steps

1. Copy Templates

cd your-project/supabase
cp /path/to/skill/assets/* .

2. Configure MCP

Edit .mcp.json and replace PROJECT_REF_PLACEHOLDER with your Supabase project reference:

{
  "mcpServers": {
    "supabase": {
      "type": "http",
      "url": "https://mcp.supabase.com/mcp?project_ref=YOUR_PROJECT_REF?read_only=true"
    }
  }
}

Find your project ref in Supabase Dashboard → Project Settings → General.

3. Install Tools

# Install mise if not already installed
curl https://mise.run | sh

# Install project tools (sqlfluff, psql)
mise install

4. Verify Setup

# Check sqlfluff
mise run lint

# Check MCP connection (requires Claude Code)
# MCP will auto-connect when querying schema

Directory Structure

After bootstrap, your project should have:

supabase/
├── .mcp.json           # MCP server config
├── .sqlfluff           # SQL formatter config
├── mise.toml           # Task runner
├── migrations/         # Schema migrations
└── seed/               # Seed data files

Available Tasks

After setup, use mise to run tasks:

mise run lint           # Lint SQL files
mise run format         # Format SQL files
mise run fix            # Lint and auto-fix
mise run install-psql   # Install PostgreSQL client