supabase
Query Supabase projects - count users, list signups, check stats. Use for database queries and user analytics.
Install via CLI (Recommended)
clawhub install openclaw/skills/skills/joelchance/supabase-querySupabase ⚡
Query your Supabase projects directly from chat.
Setup
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..."
Commands
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 Type | Format | User Listing | User Count | REST Tables |
|---|---|---|---|---|
| JWT service_role | eyJ... | ✅ Yes | ✅ Yes | ✅ Yes |
| New secret | sb_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
Metadata
Not sure this is the right skill?
Describe what you want to build — we'll match you to the best skill from 16,000+ options.
Find the right skillPaste this into your clawhub.json to enable this plugin.
{
"plugins": {
"official-joelchance-supabase-query": {
"enabled": true,
"auto_update": true
}
}
}Related Skills
manus
Create and manage AI agent tasks via Manus API. Manus is an autonomous AI agent that can browse the web, use tools, and deliver complete work products.
markdown-new
Convert public web pages into clean Markdown with markdown.new for AI workflows. Use when tasks require URL-to-Markdown conversion for summarization, RAG ingestion, extraction, archiving, or token reduction, including selecting conversion method (auto/ai/browser), enabling image retention, and handling rate limits or conversion failures.
polymarket
Query Polymarket prediction markets - check odds, trending markets, search events, track prices and momentum. Includes watchlist alerts, resolution calendar, momentum scanner, and paper trading (simulated, no real money).
parallel
High-accuracy web search and research via Parallel.ai API. Optimized for AI agents with rich excerpts and citations.