A powerful integration for querying Supabase projects and generating user analytics directly from your chat interface.
Install & Download
1. ClawHub CLI
The fastest way to install a skill directly from the registry.
npx clawhub@latest install supabase-query
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-query 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 skill for Openclaw Skills enables developers to interact with their database projects using simple natural language commands or CLI scripts. By leveraging the Supabase Auth Admin API, users can monitor growth metrics, list recent signups, and inspect project health without leaving their terminal or agent environment.
This skill bridges the gap between backend management and conversational AI, making database oversight more accessible. It is specifically designed to work with Openclaw Skills to provide real-time insights into user behavior and project configuration, supporting both manual queries and automated workflows.
Supabase Use Cases
- Monitoring daily user signups and growth metrics.
- Auditing user lists and authentication providers for security reviews.
- Generating automated project status reports for team updates.
- Quick inspection of database tables and project metadata via REST endpoints.
How Supabase Works
- The skill authenticates with the Supabase project using a Legacy JWT service_role key to ensure full admin access.
- It interfaces with the Auth Admin API to retrieve user-specific data and uses the REST API for table discovery.
- Users issue commands like 'users-today' or 'list-users' via the chat interface or CLI.
- The skill processes the request, filters the data according to specified limits or timeframes, and returns formatted summaries or raw JSON data.
Supabase Setup
To get started with this component of Openclaw Skills, follow these steps:
- Get Credentials: Obtain your URL and Legacy service_role API key from Project Settings > API in the Supabase Dashboard.
- Interactive Setup:
python3 scripts/supabase.py auth
- Manual Configuration: Create a
~/.supabase_config.jsonfile with your credentials or export them as environment variables:
export SUPABASE_URL="https://xxxxx.supabase.co"
export SUPABASE_SERVICE_KEY="eyJhbG..."
Supabase Data Schema & Taxonomy
The skill organizes data retrieved from the Supabase environment as follows:
| Category | Source | Fields |
|---|---|---|
| User Data | Auth Admin API | Email, Display Name, Provider, Signup Date |
| Analytics | Aggregation | Total User Count, New Signups (24h/7d) |
| Schema | REST API | Table Names, Key Types, API Accessibility |
| Configuration | Local Storage | Encrypted/Restricted JSON (mode 600) |
Supabase Advanced Features
- Automated daily reports using Clawdbot cron scheduling for hands-off monitoring.
- JSON output flag for pipe-friendly integration with other Openclaw Skills and developer tools.
- Support for pg_graphql extensions to enable complex schema reflections.
- Restricted execution mode ensuring no write or delete operations are performed on the database.
SKILL.md
Loading
Related Openclaw Skills
Polymarket Prediction Market Tool
A comprehensive CLI tool for tracking Polymarket prediction markets, monitoring price momentum, and simulating trades via a local paper trading system.
Parallel.ai Search & Research
A high-accuracy web search API optimized for AI agents to perform deep research with rich excerpts and citations.
markdown-new
Transform public web content into clean, LLM-ready Markdown for efficient AI data ingestion and processing.
Manus AI Agent
An autonomous AI agent skill that executes complex tasks through web browsing and tool usage via the Manus API.
Adaptive Routing
A local-first routing engine that prioritizes privacy and cost-efficiency by intelligently escalating LLM requests to the cloud only when necessary.
Local-First LLM Router
A smart routing agent that prioritizes local LLMs over cloud APIs to reduce costs and enhance data privacy.
Featured*
