capysquash analyze supabase/migrations/

capysquash squash supabase/migrations/ \
  --output=clean/ \
  --safety=standard

# Test with Supabase CLI

supabase db reset

# Or use Docker validation

capysquash validate \
  --original supabase/migrations/ \
  --squashed clean/

# Replace old migrations

mv supabase/migrations supabase/migrations_backup
mv clean supabase/migrations

# Deploy to Supabase

supabase db push

[plugins] ✓ Supabase project detected
[plugins] ✓ Found auth schema with 7 tables
[plugins] ✓ Found 23 RLS policies to preserve
[plugins] ✓ Found 3 storage buckets
[plugins] ✓ Ready for Supabase-optimized consolidation

-- 001_create_users.sql
CREATE TABLE auth.users (id uuid, email text);

-- 002_add_email.sql
ALTER TABLE auth.users ADD COLUMN created_at timestamptz;

-- 003_add_timestamps.sql
ALTER TABLE auth.users ADD COLUMN updated_at timestamptz;

-- Before: Scattered policy migrations
CREATE POLICY "Users can view own data" ON profiles FOR SELECT USING (auth.uid() = id);
CREATE POLICY "Users can update own data" ON profiles FOR UPDATE USING (auth.uid() = id);
ALTER POLICY "Users can view own data" ON profiles USING (auth.uid() = id OR is_admin());

-- After: Consolidated with proper ordering
CREATE POLICY "Users can view own data" ON profiles
    FOR SELECT USING (auth.uid() = id OR is_admin());

CREATE POLICY "Users can update own data" ON profiles
    FOR UPDATE USING (auth.uid() = id);

-- Optimized storage schema
CREATE TABLE storage.buckets (
    id uuid PRIMARY KEY DEFAULT gen_random_uuid(),
    name text NOT NULL UNIQUE,
    public boolean DEFAULT false,
    created_at timestamptz DEFAULT now()
);

CREATE TABLE storage.objects (
    id uuid PRIMARY KEY DEFAULT gen_random_uuid(),
    bucket_id uuid REFERENCES storage.buckets(id) ON DELETE CASCADE,
    name text NOT NULL,
    metadata jsonb
);

-- Realtime-optimized messaging system
CREATE TABLE public.messages (
    id uuid DEFAULT gen_random_uuid() PRIMARY KEY,
    room_id uuid NOT NULL REFERENCES public.rooms(id),
    user_id uuid NOT NULL REFERENCES auth.users(id),
    content text NOT NULL,
    created_at timestamptz DEFAULT now()
);

-- Realtime publication
ALTER PUBLICATION supabase_realtime ADD TABLE public.messages;

-- Optimized indexes
CREATE INDEX idx_messages_room_created ON public.messages(room_id, created_at DESC);

name: Optimize Migrations
on:
  pull_request:
    paths:
      'supabase/migrations/**'

jobs:
optimize:
runs-on: ubuntu-latest
steps:
\- uses: actions/checkout@v3

      name: Install capysquash
        run: go install github.com/CAPYSQUASH/capysquash-cli/cmd/capysquash@latest

      name: Analyze
        run: capysquash analyze supabase/migrations/

      name: Squash
        run: capysquash squash supabase/migrations/ --output clean/ --safety=conservative

      name: Validate
        run: capysquash validate --original supabase/migrations/ --squashed clean/

</Tab>

<Tab value="GitLab CI">

````yaml optimize-migrations: stage: test script: - go install
Github.com/CAPYSQUASH/capysquash-cli/cmd/capysquash@latest - capysquash analyze.
Supabase/migrations/ - capysquash squash supabase/migrations/ - output clean/.
--safety=conservative - capysquash validate --original supabase/migrations/ --squashed clean/
Only: changes: - supabase/migrations/** ```



```bash
# Analyze

capysquash analyze supabase/migrations/

# Squash with validation

capysquash squash supabase/migrations/ \
--output=clean/ \
--safety=conservative \
--validate

# Test with Supabase CLI

supabase db reset

# Deploy

supabase db push

relation "auth.users" does not exist

# Ensure Supabase is running locally

supabase start

# Use paranoid mode for auth-heavy projects

capysquash squash supabase/migrations/*.sql \
--safety=paranoid \

###   Output=clean

policy "storage.objects" does not apply to table

# Check that storage schema exists

supabase db diff

# Use conservative mode

capysquash squash supabase/migrations/*.sql \
--safety=conservative

extension "vector" is not available

# Enable extension in Supabase

supabase db execute "CREATE EXTENSION IF NOT EXISTS vector;"

# Or add to config

echo '{"custom_extensions": {"vector": "pgvector/pgvector:latest"}}' > pgsquash.config.json

-- Multi-tenant user management
CREATE TABLE public.tenant_users (.
id uuid REFERENCES auth.users(id) PRIMARY KEY,
tenant_id uuid NOT NULL REFERENCES public.tenants(id),
role text NOT NULL DEFAULT 'member',
permissions jsonb DEFAULT '[]',
joined_at timestamptz DEFAULT now()
);

-- RLS for tenant isolation
ALTER TABLE public.tenant_users ENABLE ROW LEVEL SECURITY;

CREATE POLICY "Tenant isolation" ON public.tenant_users FOR SELECT.
USING (.
tenant_id IN (
SELECT tenant_id FROM public.tenant_users
WHERE id = auth.uid()
)
);

-- Check tenant membership
CREATE OR REPLACE FUNCTION public.is_tenant_member(tenant_uuid uuid)
RETURNS boolean AS $$.
BEGIN.
RETURN EXISTS (
SELECT 1 FROM public.tenant_users
WHERE tenant_id = tenant_uuid
AND id = auth.uid()
);
END;
$$ LANGUAGE plpgsql SECURITY DEFINER STABLE;

-- Check admin role
CREATE OR REPLACE FUNCTION public.is_admin(user_uuid uuid)
RETURNS boolean AS $$.
BEGIN.
RETURN EXISTS (
SELECT 1 FROM public.profiles
WHERE id = user_uuid AND role = 'admin'
);
END;
$$ LANGUAGE plpgsql STABLE;

-- Optimized search with indexes
CREATE INDEX idx_documents_search ON public.documents.
USING gin(to_tsvector('english', content));

CREATE INDEX idx_messages_room_created ON public.messages(room_id, created_at DESC);

-- Optimized RLS policy
CREATE POLICY "document_access" ON public.documents FOR SELECT.
USING (.
user_id = auth.uid()
OR is_public = true
OR team_id IN (SELECT team_id FROM public.team_members WHERE user_id = auth.uid())
);