A dedicated skill for querying Supabase project analytics, user signups, and database metadata directly through your AI agent.
Install & Download
1. ClawHub CLI
The fastest way to install a skill directly from the registry.
npx clawhub@latest install supabase-users
2. Manual Installation
Copy the skill folder to one of these locations
~/.openclaw/skills/ <project>/skills/ Priority: Workspace > Local > Bundled
3. Prompt Installation
Copy this prompt to OpenClaw to install it automatically.
Help me install supabase-users using Clawhub. If Clawhub is not installed, install it first (npm i -g clawhub).
Prefer to download?
Get the raw skill files in a ZIP archive.
What is Supabase?
The Supabase integration for Openclaw Skills provides a streamlined way to monitor your backend infrastructure. By connecting directly to your Supabase project's Auth Admin API, this skill empowers developers to perform user audits and growth tracking without leaving their development environment. It bridges the gap between raw database data and actionable insights by providing clear, formatted reports on user acquisition and project health.
This tool is designed specifically for administrative oversight, allowing you to bypass the manual dashboard navigation for routine checks. Whether you need to verify the number of new signups in the last 24 hours or list the tables currently exposed via your REST API, this skill handles the authentication and request logic efficiently.
Supabase Use Cases
- Tracking new user signups over 24-hour or 7-day windows.
- Auditing user lists to identify authentication providers and registration dates.
- Setting up automated daily summaries of application growth for team updates.
- Quickly listing available database tables for schema inspection.
- Exporting user data in JSON format for external analysis or secondary processing.
How Supabase Works
- The user provides their Supabase URL and service_role JWT key to establish a secure connection.
- The AI agent executes the underlying Python script to communicate with the Supabase Auth Admin API.
- The skill retrieves specific user or project data based on the requested command triggers.
- Responses are parsed and formatted into human-readable summaries or structured JSON objects.
- If configured, a cron scheduler triggers these steps at specific intervals for automated reporting within the Openclaw Skills framework.
Supabase Setup
1. Obtain API Credentials
Navigate to your Supabase Dashboard -> Project Settings -> API and locate the Legacy service_role API key. Ensure you use the JWT format (starts with eyJ...) for full admin functionality, as the newer secret keys have limited access to the Auth Admin API.
2. Configuration
You can configure the connection via the CLI or environment variables:
# Interactive setup
python3 scripts/supabase.py auth
# Manual environment export
export SUPABASE_URL="https://your-project.supabase.co"
export SUPABASE_SERVICE_KEY="your-jwt-key"
Alternatively, you can create a ~/.supabase_config.json file containing your credentials to persist the configuration across sessions.
Supabase Data Schema & Taxonomy
This skill interacts primarily with the Supabase Auth and REST schemas. Below is how the data is organized:
| Category | Attributes |
|---|---|
| User Data | Email, display name, auth provider, and creation timestamp. |
| Project Metadata | API URL, key validation status, and available REST tables. |
| Analytics | Aggregated counts for daily, weekly, and total user signups. |
All metadata queries used by Openclaw Skills are read-only and designed to provide snapshots of your project state.
Supabase Advanced Features
- Cron Automation: Schedule recurring reports using the built-in cron system to receive daily updates at specific times.
- JSON Output Mode: Use the
--jsonflag to return raw data for use in secondary scripts or automation workflows. - GraphQL Integration: Support for enabling and querying the pg_graphql extension for complex schema interactions.
- Admin Access: Full support for the Auth Admin API, enabling management tasks like user counting that standard client keys cannot perform.
- Secure Configuration: Automatic file permissions (mode 600) for local configuration files to ensure key safety.
SKILL.md
Loading
Related Openclaw Skills
Spotify Web API
A cross-platform skill allowing AI agents to control Spotify playback, search tracks, and analyze listening history via the official Web API.
Search X
Search X is a real-time Twitter search tool powered by Grok-4 that allows AI agents to find tweets, trends, and discussions with verified citations.
Remotion Server
A headless video rendering engine for Linux that uses Remotion v5 and Chrome Headless Shell to generate professional videos from React templates.
Polymarket Prediction Trading
A comprehensive tool for monitoring odds and executing trades on the world's largest prediction market directly from your AI agent.
xAI Grok Integration
A high-performance integration for Openclaw Skills that enables interaction with xAI's Grok models for advanced reasoning and real-time information retrieval.
SlideSpeak PowerPoint Automation
Automate the creation, editing, and management of professional PowerPoint presentations from text or documents using the SlideSpeak API.
METADATA
Featured*
