supabase-queries

What problem does it solve?

This Skill provides quick, hands-on access to SBHQ-Mobile data via Supabase, enabling fast debugging and verification of contests, users, participants, questions, answers, and notification history. It also includes guidance for testing the notification edge function.

Core Features & Use Cases

• SQL Queries via mcp__supabase__execute_sql: run SELECT queries against key tables to inspect state, relationships, and activity.
• Data Exploration: quickly check active contests, users with expo_push_token, and notification history.
• Edge Function Testing: retrieve and test the send-notification function, simulate payloads, and verify deduplication logic.

Quick Start

Run a sample query to list active contests, e.g., SELECT id, name, state FROM contests WHERE state != 'FINISHED'.