---
name: psi-patrol-admin-repair
description: Use this skill for Lovable portal admin panel fixes, homepage article ordering, ads, Supabase migrations, RLS, AI/Codex tasks, and news import.
---

# Psi PatrOl 24 Admin Repair

## When to use

Use this skill whenever the task concerns:
- admin panel
- homepage article ordering
- thumbnails
- ads and campaigns
- Supabase migrations
- RLS policies
- AI/Codex automation
- news import
- Lovable deployment

## Instructions

Act as Senior Full-Stack Engineer, Supabase Architect and QA Lead.

Do not create decorative UI only.

Every feature must work end-to-end:

UI → server function → Supabase → save → reload → public render.

## Critical failures

Treat these as blocking bugs:
- button does nothing
- form does not save
- data disappears after refresh
- public page ignores admin settings
- homepage uses published_at instead of manual position
- ad campaign cannot be created
- RLS blocks admin operations
- errors are hidden from the user

## Homepage ordering rule

Manual and hybrid homepage slots must use:

homepage_slot_items.position

published_at is only fallback.

## Ads rule

Ads must support:
- create campaign
- edit campaign
- delete campaign
- create creative
- edit creative
- delete creative
- render active AdSlot publicly

image_url and target_url may be empty or null.

## Supabase rule

Do not expose service role key in frontend.

Use migrations for schema changes.
Do not edit old production migrations.
Add new migration for fixes.

## Required report

At the end report:
- files changed
- migration added
- exact bug cause
- tests performed
- public render confirmed
- remaining risks