Requirements
- Target platform
- OpenClaw
- Install method
- Manual import
- Extraction
- Extract archive
- Prerequisites
- OpenClaw
- Primary doc
- SKILL.md
Tencent SkillHub · Data Analysis
Supabase ⚡
Query Supabase projects - count users, list signups, check stats. Use for database queries and user analytics.
skill openclawclawhub Free
Query Supabase projects - count users, list signups, check stats. Use for database queries and user analytics.
⬇ 0 downloads ★ 0 stars Unverified but indexed
Install for OpenClaw
Quick setup
- Download the package from Yavira.
- Extract the archive and review SKILL.md first.
- Import or place the package into your OpenClaw setup.
Package facts
- Download mode
- Yavira redirect
- Package format
- ZIP package
- Source platform
- Tencent SkillHub
- What's included
- SKILL.md, scripts/supabase.py
Validation
- Use the Yavira download entry.
- Review SKILL.md after the package is downloaded.
- Confirm the extracted package contains the expected setup assets.
Install with your agent
Agent handoff
Hand the extracted package to your coding agent with a concrete install brief instead of figuring it out manually.
- Download the package from Yavira.
- Extract it into a folder your agent can access.
- Paste one of the prompts below and point your agent at the extracted folder.
New install
I downloaded a skill package from Yavira. Read SKILL.md from the extracted folder and install it by following the included instructions. Tell me what you changed and call out any manual steps you could not complete.
Upgrade existing
I downloaded an updated skill package from Yavira. Read SKILL.md from the extracted folder, compare it with my current installation, and upgrade it while preserving any custom configuration unless the package docs explicitly say otherwise. Summarize what changed and any follow-up checks I should run.
Trust & source
Release facts
- Source
- Tencent SkillHub
- Verification
- Indexed source record
- Version
- 1.0.0
Provenance
- Publisher
- joelchance
- Source page
- View original listing
- Canonical URL
- Open canonical page
Documentation
Supabase ⚡
Query your Supabase projects directly from chat.
1. Get your credentials
Go to Supabase Dashboard → Project Settings → API You'll see two tabs: "Publishable and secret API keys" - New format (limited functionality) "Legacy anon, service_role API keys" - JWT format (full functionality) ⚠️ Use the Legacy JWT key for full access! The service_role JWT key (starts with eyJ...) gives full admin access including: Listing users with details Counting signups Accessing auth.users The new sb_secret_... keys have limited functionality and can't access the Admin API.
2. Find your keys
Go to: Project Settings → API Click the "Legacy anon, service_role API keys" tab Find service_role (marked with red "secret" badge) Click Reveal and copy the eyJ... token Direct link: https://supabase.com/dashboard/project/YOUR_PROJECT_REF/settings/api
3. Configure
Option A: Interactive setup python3 {baseDir}/scripts/supabase.py auth Option B: Manual config Create ~/.supabase_config.json: { "url": "https://xxxxx.supabase.co", "service_key": "eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9..." } Option C: Environment variables export SUPABASE_URL="https://xxxxx.supabase.co" export SUPABASE_SERVICE_KEY="eyJhbG..."
User Analytics
# Count total users python3 {baseDir}/scripts/supabase.py users # Count new users (24h) python3 {baseDir}/scripts/supabase.py users-today # Count new users (7 days) python3 {baseDir}/scripts/supabase.py users-week # List users with details (name, email, provider, signup date) python3 {baseDir}/scripts/supabase.py list-users # List new users from last 24h python3 {baseDir}/scripts/supabase.py list-users-today # Limit results python3 {baseDir}/scripts/supabase.py list-users --limit 5
Project Info
# Show project info and key type python3 {baseDir}/scripts/supabase.py info # List tables exposed via REST API python3 {baseDir}/scripts/supabase.py tables
JSON Output
python3 {baseDir}/scripts/supabase.py list-users --json
Key Types Explained
Key TypeFormatUser ListingUser CountREST TablesJWT service_roleeyJ...✅ Yes✅ Yes✅ YesNew secretsb_secret_...❌ No❌ No✅ Yes Recommendation: Always use the JWT service_role key for Clawdbot integration.
Daily Reports
Set up automated daily user reports via Clawdbot cron.
Example: Daily 5 PM Report
Ask Clawdbot: Send me a report of how many new users signed up at 5 PM every day, show the last 5 signups with their names This creates a cron job like: { "name": "Daily Supabase User Report", "schedule": { "kind": "cron", "expr": "0 17 * * *", "tz": "America/Los_Angeles" }, "payload": { "message": "Supabase daily report: Count new user signups in the last 24 hours, and list the 5 most recent signups with their name and email." } }
Sample Report Output
📊 Supabase Daily Report New signups (last 24h): 2 Last 5 signups: • Jane Smith <jane@example.com> (google) - 2026-01-25 • Alex Johnson <alex.j@company.com> (google) - 2026-01-25 • Sam Wilson <sam@startup.io> (email) - 2026-01-24 • Chris Lee <chris.lee@email.com> (google) - 2026-01-23 • Jordan Taylor <jordan@acme.co> (github) - 2026-01-22
GraphQL API (pg_graphql)
⚠️ pg_graphql is disabled by default on new Supabase projects (as of late 2025). If you need the GraphQL API:
Enable pg_graphql
-- Run in SQL Editor create extension if not exists pg_graphql;
Endpoint
https://<PROJECT_REF>.supabase.co/graphql/v1
Example Query
curl -X POST https://<PROJECT_REF>.supabase.co/graphql/v1 \ -H 'apiKey: <API_KEY>' \ -H 'Content-Type: application/json' \ --data-raw '{"query": "{ accountCollection(first: 1) { edges { node { id } } } }"}' Note: GraphQL automatically reflects your database schema. Tables/views in public schema become queryable. See Supabase GraphQL docs for configuration.
"list-users requires a JWT service_role key"
You're using an sb_secret_... key. Get the JWT key from: Project Settings → API → Legacy tab → service_role → Reveal
"No API key found in request"
The new sb_secret_ keys don't work with all endpoints. Switch to the JWT key.
Keys not showing
Make sure you're on the "Legacy anon, service_role API keys" tab, not the new API keys tab.
Security & Permissions
The service_role key has full admin access to your database. This skill requires it for the Auth Admin API (listing/counting users). What this skill does: Makes GET requests to your Supabase project's Auth Admin API Reads user metadata (email, name, provider, signup date) All requests stay between your machine and your Supabase instance What this skill does NOT do: Does not write, modify, or delete any data Does not send credentials to any third party Does not access any endpoints outside your Supabase project Cannot be invoked autonomously by the agent (disable-model-invocation: true) Least-privilege alternative: Create a read-only Postgres role scoped to auth.users and use the Supabase SQL API instead of the Admin API. Key safety: Never commit keys to git Don't expose in client-side code Only use on trusted machines Config file is automatically set to mode 600 (owner read/write only) Review scripts/supabase.py before first use
Category context
Data access, storage, extraction, analysis, reporting, and insight generation.
Source: Tencent SkillHub
Largest current source with strong distribution and engagement signals.
Package contents
Included in package
1 Docs1 Scripts
- SKILL.md
- scripts/supabase.py