supabase-cms

# Supabase CMS Integration for Astro

Complete Supabase CMS integration for Astro websites, including database schema design, RLS policies, content management workflows, and client setup.

## Overview

This skill provides comprehensive Supabase CMS support:
- Database schema design for content types
- Row Level Security (RLS) policies
- Draft/publish workflows
- Content versioning patterns
- Supabase client integration with Astro
- Real-time content updates

## Instructions

### 1. Initial Setup

Run the setup script to initialize Supabase CMS in an Astro project:

```bash
bash scripts/setup-supabase-cms.sh [project-path]
```

This script:
- Creates Supabase client configuration
- Sets up environment variables
- Installs @supabase/supabase-js
- Creates database migration template
- Adds TypeScript types generation

### 2. Design Content Schema

Use schema templates to design content tables:

**Blog/Posts Schema:**
```bash
# Read template for blog content
Read: templates/schemas/blog-schema.sql
Read: templates/schemas/blog-with-categories.sql
```

**Pages Schema:**
```bash
# Read template for static pages
Read: templates/schemas/pages-schema.sql
```

**Media/Assets Schema:**
```bash
# Read template for media management
Read: templates/schemas/media-schema.sql
```

**Multi-tenant Schema:**
```bash
# Read template for multi-tenant content
Read: templates/schemas/multi-tenant-schema.sql
```

### 3. Apply Database Migrations

Apply schema migrations to Supabase:

```bash
bash scripts/apply-migration.sh [migration-file]
```

This script:
- Validates SQL syntax
- Applies migration via Supabase CLI
- Generates TypeScript types
- Updates local schema cache

### 4. Configure RLS Policies

Implement Row Level Security policies:

**Basic RLS Templates:**
```bash
Read: templates/rls/basic-policies.sql
Read: templates/rls/multi-tenant-policies.sql
Read: templates/rls/draft-publish-policies.sql
```

**Apply RLS Policies:**
```bash
bash scripts/apply-rls-policies.sh [table-name] [p