supabase-queryQuery Supabase projects - count users, list signups, check stats. Use for database queries and user analytics.
Install via ClawdBot CLI:
clawdbot install joelchance/supabase-queryGrade Fair — based on market validation, documentation quality, package completeness, maintenance status, and authenticity signals.
Calls external URL not in known-safe list
https://supabase.com/dashboard/project/YOUR_PROJECT_REF/settings/api`Audited Apr 17, 2026 · audit v1.0
Generated Mar 22, 2026
A subscription-based software company uses this skill to monitor daily and weekly user signups, enabling quick assessment of marketing campaign effectiveness. The team can generate automated daily reports via cron jobs to track growth trends and identify peak signup times without manual database queries.
An online retail platform leverages the skill to analyze new customer registrations and user demographics from authentication data. This helps in understanding customer acquisition sources (e.g., Google, email signups) and optimizing onboarding flows based on signup patterns over the past week.
A tech startup uses the skill to provide investors with real-time user metrics, such as total user counts and recent signup details. By running commands like 'list-users --json', they can export structured data for presentations or dashboards to demonstrate traction and growth milestones.
A community or forum platform employs this skill to monitor new user signups for moderation purposes, checking details like provider and signup dates. This aids in detecting suspicious activity or spam accounts by reviewing the most recent registrations listed via the tool.
A mobile app development team uses the skill to track user acquisition after app launches or updates. By counting new users in the last 24 hours and listing signups with details, they can correlate spikes with marketing efforts and refine user engagement strategies.
Companies charge monthly or annual fees for access to software, using this skill to monitor user growth and retention. Revenue is generated from recurring subscriptions, with analytics from Supabase helping to forecast churn and optimize pricing tiers based on signup trends.
Businesses offer a free basic service with premium upgrades, utilizing the skill to track conversion rates from free to paid users. Revenue comes from upselling premium features, with user count data informing targeted marketing campaigns to boost conversions.
Platforms provide free access to content or tools, monetizing through advertisements. This skill helps analyze user base growth to attract advertisers by demonstrating audience size and engagement, with revenue based on ad impressions and clicks.
💬 Integration Tip
Ensure the JWT service_role key is used for full functionality, and set up environment variables for secure credential management to avoid exposing keys in code.
Scored Apr 19, 2026
Use the @steipete/oracle CLI to bundle a prompt plus the right files and get a second-model review (API or browser) for debugging, refactors, design checks, or cross-validation.
Local search/indexing CLI (BM25 + vectors + rerank) with MCP mode.
Use when designing database schemas, writing migrations, optimizing SQL queries, fixing N+1 problems, creating indexes, setting up PostgreSQL, configuring EF Core, implementing caching, partitioning tables, or any database performance question.
Connect to Supabase for database operations, vector search, and storage. Use for storing data, running SQL queries, similarity search with pgvector, and managing tables. Triggers on requests involving databases, vector stores, embeddings, or Supabase specifically.
Use SQLite correctly with proper concurrency, pragmas, and type handling.
Write correct MySQL queries avoiding common pitfalls with character sets, indexes, and locking.