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
Known item issue.
This item's current download entry is known to bounce back to a listing or homepage instead of returning a package file.
Quick setup
- Open the source page and confirm the package flow manually.
- Review SKILL.md if you can obtain the files.
- Treat this source as manual setup until the download is verified.
Package facts
- Download mode
- Manual review
- Package format
- ZIP package
- Source platform
- Tencent SkillHub
- What's included
- SKILL.md, scripts/supabase.py
Validation
- Open the source listing and confirm there is a real package or setup artifact available.
- Review SKILL.md before asking your agent to continue.
- Treat this source as manual setup until the upstream download flow is fixed.
Install with your agent
Agent handoff
Use the source page and any available docs to guide the install because the item currently does not return a direct package file.
- Open the source page via Open source listing.
- If you can obtain the package, extract it into a folder your agent can access.
- Paste one of the prompts below and point your agent at the source page and extracted files.
New install
I tried to install a skill package from Yavira, but the item currently does not return a direct package file. Inspect the source page and any extracted docs, then tell me what you can confirm and any manual steps still required.
Upgrade existing
I tried to upgrade a skill package from Yavira, but the item currently does not return a direct package file. Compare the source page and any extracted docs with my current installation, then summarize what changed and what manual follow-up I still need.
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