skills.rest
siondw
siondwCOMMUNITY
Explore all skills by this author →
GitHub

supabase-queries

Run SQL queries against Supabase tables to inspect contest and user data.

Updated Nov 26, 2025
Search Tags:#database#queries#supabase#notifications#sql#edge-function
One-click install
npx skills add https://github.com/siondw/sbhq-mobile --skill supabase-queries
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: supabase-queries
Source: https://github.com/siondw/sbhq-mobile/tree/main/.claude/skills/supabase-queries
Command: npx skills add https://github.com/siondw/sbhq-mobile --skill supabase-queries

SYSTEM DOCUMENTATION & REQUIREMENTS

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'.