Automated summary
This skill frames the repair and feature work on a Lovable portal admin panel, covering Supabase migrations and RLS policies, ad campaign management, and manual homepage article ordering.
Strengths
- Enforces end-to-end verification (UI → server function → Supabase → reload → public render) instead of decorative-only interfaces
- Names concrete blocking bugs such as dead buttons, unsaved forms, data lost on refresh, and RLS blocking admin operations
- Sets explicit rules for homepage ordering via homepage_slot_items.position and for full campaign and creative CRUD
- Requires a structured closing report (files changed, migration added, root cause, tests, public render, remaining risks)
Limitations
- Heavily tied to the Psi PatrOl 24 context and the Lovable platform, so it is not directly reusable elsewhere
- Provides rules and checklists rather than concrete code, migration schemas, or SQL examples
- Assumes prior familiarity with Supabase, RLS policies, and migration workflows
Use it for any fix or feature touching the admin panel, ads, Supabase migrations, or homepage article ordering on a Lovable portal.
Avoid it on projects unrelated to Lovable, Supabase, or a news portal admin panel.
Security analysis
SafeThis SKILL.md contains only natural-language engineering guidance for a Supabase/Lovable admin panel. There are no shell commands, no curl|sh, no rm -rf, no obfuscated or base64 payloads, no network calls, and no instructions to read or transmit secrets. On the contrary, it explicitly forbids exposing the service role key in the frontend and directs the agent to use migrations rather than editing production migrations. No allowed-tools are declared, so risk of execution is minimal.
No concerns found
How this analysis is madeExamples
Les articles de la homepage sont triés par published_at au lieu de l'ordre manuel défini dans l'admin. Corrige l'ordonnancement pour utiliser homepage_slot_items.position et confirme le rendu public.La création d'une campagne pub échoue dans l'admin panel. Diagnostique la cause exacte (RLS ou migration manquante), ajoute la migration nécessaire et vérifie que les créations s'affichent via AdSlot public.Fais un audit end-to-end de l'admin panel : repère les boutons inactifs, les formulaires qui ne sauvegardent pas et les erreurs masquées, puis livre un rapport avec fichiers modifiés et risques restants.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
From the file to a first result
The download contains exactly the content displayed on this page. This copy may differ from the latest version in the source repository.
View the source and supporting filesThis download contains SKILL.md only. Any scripts, references, templates and dependencies are not included. Get the required files from the source, preserving their directory structure, before continuing.
1. Download the file
Download SKILL.mdFrom the root of a test project, save the file as .skill-downloads/psi-patrol-admin-repair-mryiqheq/SKILL.md, or use the command below. This folder is for inspecting the skill before installation.
Command for macOS/Linux or WSL: requires a POSIX shell and curl. On Windows without WSL, use the download button and create the folder manually.
mkdir -p '.skill-downloads/psi-patrol-admin-repair-mryiqheq' && curl --fail --show-error --location 'https://skills-guides.com/api/skills/psi-patrol-admin-repair-mryiqheq/download' --output '.skill-downloads/psi-patrol-admin-repair-mryiqheq/SKILL.md.part' && mv '.skill-downloads/psi-patrol-admin-repair-mryiqheq/SKILL.md.part' '.skill-downloads/psi-patrol-admin-repair-mryiqheq/SKILL.md'2. Check prerequisites
Read SKILL.md before using it. If it references scripts or external services, inspect them and prepare the required access in your test environment.
No recognized prerequisites section in this file. This does not mean it is self-contained: libraries, tools and access requirements may be mentioned elsewhere in the content or source repository.
The platforms on this page are catalog indications. The paths below follow tool documentation; they do not prove this skill has been run in those tools. No minimum tool version is confirmed for this listing.
3. Load the skill
After inspection, copy the complete folder into your project using one of the commands below, then open a new tool session. The command stops if a folder with the same name already exists: compare the files before replacing it.
Claude Code
test -f '.skill-downloads/psi-patrol-admin-repair-mryiqheq/SKILL.md' && test -s '.skill-downloads/psi-patrol-admin-repair-mryiqheq/SKILL.md' && mkdir -p '.claude/skills' && test ! -e '.claude/skills/psi-patrol-admin-repair' && cp -R '.skill-downloads/psi-patrol-admin-repair-mryiqheq' '.claude/skills/psi-patrol-admin-repair'Cursor
test -f '.skill-downloads/psi-patrol-admin-repair-mryiqheq/SKILL.md' && test -s '.skill-downloads/psi-patrol-admin-repair-mryiqheq/SKILL.md' && mkdir -p '.cursor/skills' && test ! -e '.cursor/skills/psi-patrol-admin-repair' && cp -R '.skill-downloads/psi-patrol-admin-repair-mryiqheq' '.cursor/skills/psi-patrol-admin-repair'Codex
test -f '.skill-downloads/psi-patrol-admin-repair-mryiqheq/SKILL.md' && test -s '.skill-downloads/psi-patrol-admin-repair-mryiqheq/SKILL.md' && mkdir -p '.agents/skills' && test ! -e '.agents/skills/psi-patrol-admin-repair' && cp -R '.skill-downloads/psi-patrol-admin-repair-mryiqheq' '.agents/skills/psi-patrol-admin-repair'OpenSkills
OpenSkills must already be installed. The local install/read procedure is checked with OpenSkills 1.5.0, which requires Node.js ≥ 20.6.0. Catalog slugs are not resolved automatically.
Official OpenSkills installationopenskills install './.skill-downloads/psi-patrol-admin-repair-mryiqheq'openskills read 'psi-patrol-admin-repair-mryiqheq'Reading should display the installed file content and its base directory. It does not run the skill or install its dependencies.
For an agent that reads AGENTS.md, then sync the index. This command changes AGENTS.md: review the diff before using it.
openskills syncManual method or another tool: attach SKILL.md to a conversation, or open it in an agent that can read files. Include any required supporting resources. No universal folder is recognized by every tool.
4. Try a first task
Use a short, synthetic input: an API endpoint, a small document or an interface brief. In a new conversation, attach the file or give the agent its path, then adapt this request:
Read .skill-downloads/psi-patrol-admin-repair-mryiqheq/SKILL.md and apply its instructions to this example: [describe a test input]. Identify any missing files, dependencies or access. Produce the result requested by the skill without inventing data or running unreviewed scripts.Expected result: output matching the skill instructions, or a precise list of missing prerequisites. A read confirmation alone does not validate a first use. If an external resource is unavailable, that path remains untested.
React Hook Form Best Practices
Development
Master React Hook Form: avoid anti-patterns, manage subscriptions, and handle reset, dirty state, and controlled inputs correctly.
Emotion to Mantine Migration
Development
Migrate Emotion styled-components to Mantine components with style props and CSS modules. Use when converting .styled.tsx files or removing @emotion imports.
Scope Creep Detector
Development
Analyzes git diffs against a stated intent to detect scope creep, unrelated files, broad PRs, and oversized changes, then suggests keep, split, or justify actions.