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