Supabase Postgres Best Practices
supabase/agent-skills
Gives the agent Postgres rules to consult before writing or changing tables, queries, indexes, RLS policies or migrations, and when diagnosing slow queries.
Applies ClawHub's repository-specific Convex rules and routes work to the right managed Convex skill for performance, migrations, retention and deployments.
Install ClawHub Convex Conventions
$ npx skills add openclaw/clawhub --skill clawhub-convex -a claude-codeProject install by default; add -g for ~/.claude/skills/.
$ gh skill install openclaw/clawhub clawhub-convex --agent claude-codeProject scope by default; add --scope user for a personal install. Needs GitHub CLI 2.90.0 or later (public preview).
$ git clone --depth 1 https://github.com/openclaw/clawhub.git skills-src && mkdir -p .claude/skills && cp -r skills-src/.agents/skills/clawhub-convex .claude/skills/clawhub-convex && rm -rf skills-srcUse ~/.claude/skills/ instead of .claude/skills for a personal install. The folder must contain SKILL.md.
Claude Code skills documentation · loads skills from .claude/skills/
Install the "clawhub-convex" agent skill from https://github.com/openclaw/clawhub/tree/main/.agents/skills/clawhub-convex into .claude/skills/clawhub-convex/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "clawhub-convex", then confirm the skill loads.Claude Code copies the folder itself, the same result as the manual copy. Check what it changed before you commit it.
$skill-installer install https://github.com/openclaw/clawhub/tree/main/.agents/skills/clawhub-convexType this inside Codex. $skill-installer <name> installs a curated skill from openai/skills. The installer writes to $CODEX_HOME/skills (default ~/.codex/skills). Restart Codex if the skill does not show up.
$ npx skills add openclaw/clawhub --skill clawhub-convex -a codexProject install goes to .agents/skills/; add -g for ~/.codex/skills/.
$ gh skill install openclaw/clawhub clawhub-convex --agent codexProject scope by default (.agents/skills/); add --scope user for a personal install.
$ git clone --depth 1 https://github.com/openclaw/clawhub.git skills-src && mkdir -p .agents/skills && cp -r skills-src/.agents/skills/clawhub-convex .agents/skills/clawhub-convex && rm -rf skills-srcUse ~/.agents/skills/ instead of .agents/skills for a personal install.
Codex skills documentation · loads skills from .agents/skills/
Install the "clawhub-convex" agent skill from https://github.com/openclaw/clawhub/tree/main/.agents/skills/clawhub-convex into .agents/skills/clawhub-convex/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "clawhub-convex", then confirm the skill loads.Codex copies the folder itself, the same result as the manual copy. Check what it changed before you commit it.
$ npx skills add openclaw/clawhub --skill clawhub-convex -a cursorProject install goes to .agents/skills/; add -g for ~/.cursor/skills/.
$ gh skill install openclaw/clawhub clawhub-convex --agent cursorProject scope by default (.agents/skills/); add --scope user for a personal install.
$ git clone --depth 1 https://github.com/openclaw/clawhub.git skills-src && mkdir -p .cursor/skills && cp -r skills-src/.agents/skills/clawhub-convex .cursor/skills/clawhub-convex && rm -rf skills-srcUse ~/.cursor/skills/ instead of .cursor/skills for a personal install.
Cursor skills documentation · loads skills from .cursor/skills/, .agents/skills/, .claude/skills/, .codex/skills/
Install the "clawhub-convex" agent skill from https://github.com/openclaw/clawhub/tree/main/.agents/skills/clawhub-convex into .cursor/skills/clawhub-convex/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "clawhub-convex", then confirm the skill loads.Cursor copies the folder itself, the same result as the manual copy. Check what it changed before you commit it.
$ gemini skills install https://github.com/openclaw/clawhub.git --path .agents/skills/clawhub-convex--scope user (default) or --scope workspace; --path is the subfolder of the repo that holds the skill; --consent skips the security confirmation prompt.
$ npx skills add openclaw/clawhub --skill clawhub-convex -a gemini-cliProject install goes to .agents/skills/; add -g for ~/.gemini/skills/.
$ gh skill install openclaw/clawhub clawhub-convex --agent gemini-cliProject scope by default (.agents/skills/); add --scope user for a personal install.
$ git clone --depth 1 https://github.com/openclaw/clawhub.git skills-src && mkdir -p .gemini/skills && cp -r skills-src/.agents/skills/clawhub-convex .gemini/skills/clawhub-convex && rm -rf skills-srcUse ~/.gemini/skills/ instead of .gemini/skills for a personal install, then run /skills reload.
Gemini CLI skills documentation · loads skills from .gemini/skills/, .agents/skills/
Install the "clawhub-convex" agent skill from https://github.com/openclaw/clawhub/tree/main/.agents/skills/clawhub-convex into .gemini/skills/clawhub-convex/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "clawhub-convex", then confirm the skill loads.Gemini CLI copies the folder itself, the same result as the manual copy. Check what it changed before you commit it.
$ gh skill install openclaw/clawhub clawhub-convexInstalls for Copilot at project scope by default; add --scope user for a personal install. Preview a skill first with gh skill preview. Needs GitHub CLI 2.90.0 or later (public preview).
$ npx skills add openclaw/clawhub --skill clawhub-convex -a github-copilotProject install goes to .agents/skills/; add -g for ~/.copilot/skills/.
$ git clone --depth 1 https://github.com/openclaw/clawhub.git skills-src && mkdir -p .github/skills && cp -r skills-src/.agents/skills/clawhub-convex .github/skills/clawhub-convex && rm -rf skills-srcUse ~/.copilot/skills/ instead of .github/skills for a personal install. Commit .github/skills so cloud agent and code review can use it.
GitHub Copilot skills documentation · loads skills from .github/skills/, .claude/skills/, .agents/skills/
Install the "clawhub-convex" agent skill from https://github.com/openclaw/clawhub/tree/main/.agents/skills/clawhub-convex into .github/skills/clawhub-convex/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "clawhub-convex", then confirm the skill loads.GitHub Copilot copies the folder itself, the same result as the manual copy. Check what it changed before you commit it.
$ npx skills add openclaw/clawhub --skill clawhub-convex -a opencodeOpenCode documents no install command of its own. Project install goes to .agents/skills/; add -g for ~/.config/opencode/skills/.
$ gh skill install openclaw/clawhub clawhub-convex --agent opencodeProject scope by default (.agents/skills/); add --scope user for a personal install.
$ git clone --depth 1 https://github.com/openclaw/clawhub.git skills-src && mkdir -p .opencode/skills && cp -r skills-src/.agents/skills/clawhub-convex .opencode/skills/clawhub-convex && rm -rf skills-srcUse ~/.config/opencode/skills/ instead of .opencode/skills for a personal install.
OpenCode skills documentation · loads skills from .opencode/skills/, .claude/skills/, .agents/skills/
Install the "clawhub-convex" agent skill from https://github.com/openclaw/clawhub/tree/main/.agents/skills/clawhub-convex into .opencode/skills/clawhub-convex/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "clawhub-convex", then confirm the skill loads.OpenCode copies the folder itself, the same result as the manual copy. Check what it changed before you commit it.
Facts
- Skill name
clawhub-convex- GitHub stars
- 9.5k
- Token cost
- ~1.4k tokens
- SKILL.md length
- 622 words
- Files
- 2
- Skills in repo
- 55
- Repo updated
- First seen
- Licence
- MIT
At a glance
Applies ClawHub's repository-specific Convex rules and routes work to the right managed Convex skill for performance, migrations, retention and deployments.
- Works in 3 steps: Read convex/_generated/ai/guidelines.md… → Name the target runtime before running a… → Route to the most specific companion skill
- Changing anything under convex/ in the ClawHub repository
- SKILL.md covers Start Here, Commands And Runtime Validation, ClawHub Migration Boundaries and Query And Bandwidth Work, plus 2 more sections
- Calls bunx and bun
What it does
Convex guidance is split in two: managed upstream skills cover general framework behavior, and this skill covers ClawHub's own boundaries. The agent reads `convex/_generated/ai/guidelines.md` before editing Convex code, names the target runtime (`local`, `dev` or `prod`) before any Convex command, and routes to the most specific companion: `convex-performance-audit` for query cost and indexes, `convex-migration-helper` and `create-and-cleanup-migration` for migrations and backfills, and `convex-retention` for TTL fields and cleanup crons. Upstream-managed skills are never edited to hold ClawHub policy.
Command rules: push changed functions before `convex run`, using `bunx convex dev --once` for dev and the production release workflow for prod, `bunx convex deploy -y` only for an explicit direct production deploy, and `bunx convex codegen` after API or schema changes. Mutations are imported from `convex/functions.ts` so the trigger wrapper runs. A `401 MissingAccessToken` after login is fixed by dropping `--env-file` and targeting a deployment. Mocked `ctx` tests cover pure logic only, so behavior touching pagination, indexes, validators, auth or storage also needs a real Convex path.
When your agent uses it
- Changing anything under convex/ in the ClawHub repository
- Running Convex commands against local, dev or prod deployments
- Auditing query performance or planning a production migration
- Adding retention or cleanup for a table
Example prompts
- “Add a TTL field and a cleanup cron for the session table in convex/.”
- “Why does bunx convex run return 401 MissingAccessToken?”
- “Plan a production backfill that narrows the skills table schema.”
Requirements
- The ClawHub repository with bun installed
- Access to the target Convex deployment
Workflow steps
3 steps, taken from the first numbered list in SKILL.md.
- Read convex/_generated/ai/guidelines.md before editing Convex code.
- Name the target runtime before running a Convex command: local, dev, or
- Route to the most specific companion skill
What it can do on your machine
Read from SKILL.md and the folder at commit d044664. It shows what the files ask for, not the result of running them.
Tool permissions
Pre-approves nothing: there is no allowed-tools line, so your agent's usual permission prompts apply.
From allowed-tools in the SKILL.md frontmatter.
Runs code
Shell commands in SKILL.md call:
bunxbun
From the folder's file list and the shell code blocks in SKILL.md.
Network
No URLs in SKILL.md. Its commands use bunx, which can reach the network depending on how they are called.
From URLs in SKILL.md, links to its own repository left out.
Credentials
Names no API keys, tokens, secrets or passwords.
From names ending in _API_KEY, _TOKEN, _SECRET, _KEY or _PASSWORD in SKILL.md.
Context cost
ClawHub Convex Conventions loads about 1.4k tokens when it runs. Until then it costs about 74 tokens; SKILL.md has 622 words of instructions outside code blocks.
Estimates: characters ÷ 4, the usual rule of thumb; real counts depend on the model's tokenizer. Scripts and assets cost tokens only if the agent reads them.
Safety
Auto-check: notes
The automated check noted patterns worth knowing about, such as sudo or a known installer.
- NoteMentions a .env fileSKILL.md:36
- If `bunx convex run --env-file .env.local ...` returns
Automated static check — not a guarantee. Review scripts before installing. It scans the text of SKILL.md for risky patterns (piping downloads into a shell, reading credential files, hidden Unicode, destructive commands); files beside SKILL.md are not scanned.
SKILL.md
The full file from openclaw/clawhub at commit d044664, republished under its MIT licence (© openclaw). 622 words, ~1,430 tokens.
Download SKILL.mdSave it as
.claude/skills/clawhub-convex/SKILL.md (or your agent's skills folder). This skill also uses 1 other file; get the full folder from GitHub.- name
- clawhub-convex
- description
- Apply ClawHub-specific Convex conventions and route to the right managed Convex skill. Use for any change under convex/, Convex commands or deployment targeting, query performance, migrations, retention, runtime validation, or skill stat reads and writes in the ClawHub repository.
ClawHub Convex
Use the managed Convex guidance for general framework behavior and this skill for ClawHub's repository-specific boundaries.
Start Here
- Read
convex/_generated/ai/guidelines.mdbefore editing Convex code. - Name the target runtime before running a Convex command:
local,dev, orprod. Include the exact deployment when known and whether the current function/schema code has already been pushed there. - Route to the most specific companion skill:
- Query cost, indexes, read amplification, subscriptions, or OCC:
convex-performance-audit - Production migration, backfill, schema narrowing, or table reshaping:
convex-migration-helperandcreate-and-cleanup-migration - Tables, TTL fields, cleanup crons, retention, auth/session cleanup, metric
dedupe cleanup, or deprecated table removal:
convex-retention - Auth, reusable components, or setup: use the matching managed Convex skill.
- Query cost, indexes, read amplification, subscriptions, or OCC:
Do not edit upstream-managed Convex skills to store ClawHub policy.
Commands And Runtime Validation
- Push new or changed functions before
convex run:- dev:
bunx convex dev --once - prod: deploy through the workflow described by
clawhub-production-release
- dev:
- For a non-interactive direct production deploy when explicitly required, use
bunx convex deploy -y. - If
bunx convex run --env-file .env.local ...returns401 MissingAccessTokenafter login, omit--env-fileand target the deployment with--deployment <name>or--prod. - Regenerate committed API/types with
bunx convex codegenafter Convex API/schema changes. - Import mutations from
convex/functions.ts, notconvex/_generated/server, so ClawHub's trigger wrapper runs. Type imports can still come fromconvex/_generated/server. - Do not disable typechecking for an ordinary direct deploy. The production workflow owns its explicit deploy behavior and exceptions.
Mocked ctx tests cover pure business logic only. When behavior depends on
pagination, indexes, validators, auth identity, internal/public boundaries,
schedulers, actions calling functions, HTTP actions, storage, or OCC, also run
a real Convex path such as:
bunx convex dev --oncebunx convex run ...- an HTTP action smoke
bun run test:pw:local-auth
Tests that invoke a mutation through ._handler need a mock database with
normalizeId: vi.fn() for trigger-wrapper compatibility.
ClawHub Migration Boundaries
- Default production data changes to
@convex-dev/migrations; the companion skills own batching, dry runs, resume/progress, confirmation, validation, and cleanup. - Put component-backed table-wide backfills in
convex/migrations.ts. - Put custom repairs, admin-gated operations, and incident-specific workflows
in
convex/maintenance.ts. - Keep one-off operator migration runs out of
.github/workflows/deploy.yml. - Remove temporary migration functions in a follow-up PR after production apply and verification unless they are intentionally retained as maintenance tooling.
Show full SKILL.md (257 more words)Show less
Query And Bandwidth Work
Use convex-performance-audit for the detailed rules on indexes, bounded reads,
denormalization, digest tables, subscriptions, and function limits. Before
writing or reviewing a performance-sensitive query, check deployment health
when available:
bunx convex insights --details
bunx convex logs --failurePrefer measured runtime signals over speculative restructuring.
ClawHub Hot-Path Conventions
Use convex-performance-audit for the complete workflow. Preserve these
ClawHub-specific implementations when touching their paths:
- Public listing and browse pages use one-shot
ConvexHttpClient.query()reads unless the user needs live updates. - When a
skillSearchDigestrow exists, resolve owner data withdigestToOwnerInfo(digest). Do not re-read the owner document when the digest already contains the required owner fields. - Keep denormalized tables synchronized through the existing
convex-helperstriggers and skip writes when derived fields did not change. - Paginate computed search results client-side after running the scoring pipeline once; do not rerun the full vector, lexical, and popularity pipeline for each page.
- Add
delayMsbetween backfill batches that update reactively subscribed tables. - Split mutations that would read more than the transaction budget through the existing action-query-mutation pattern.
Skill Stat Contract
The skills table still has a compatibility shape for four migrated stats:
| Legacy nested field | Top-level source of truth |
|---|---|
stats.downloads | statsDownloads |
stats.stars | statsStars |
stats.installsCurrent | statsInstallsCurrent |
stats.installsAllTime | statsInstallsAllTime |
- Read these fields with
readCanonicalStat()fromconvex/lib/skillStats.ts. It prefers the top-level field and falls back for pre-migration documents. - Write deltas with
applySkillStatDeltas(). It updates both shapes in one patch. - Any direct patch touching these values must update both shapes.
- Nested-only reads remain valid for
stats.commentsandstats.versions. - When adding a migrated stat field, use the same dual-write shape and add a cursor-based backfill.
© openclaw, MIT. Rendered from Markdown: HTML in the file is shown as text, images as links, and headings moved down two levels. Raw file
Files
SKILL.md and 1 other file in .agents/skills/clawhub-convex of openclaw/clawhub.
- SKILL.md
- agents/openai.yaml
Open the folder on GitHubat commit d044664
Compare with similar skills
ClawHub Convex Conventions next to the 5 skills that share the most tags, products or categories with it. Stars are the repository's; “used in” counts other GitHub owners with a copy.
| Skill | Stars | Used in | Tokens | Auto-check | Licence | Repo updated |
|---|---|---|---|---|---|---|
| ClawHub Convex Conventions this skillopenclaw/clawhub | 9.5k | — | ~1.4k | Automated safety check: Notes | MIT | |
| Supabase Postgres Best Practicessupabase/agent-skills | 2.7k | 24 repos | ~808 | Automated safety check: Pass | MIT | |
| MySQL Schema and Query Tuningplanetscale/database-skills | 708 | 3 repos | ~1.4k | Automated safety check: Pass | MIT | |
| Wtfnoobnooc/agent | 1.4k | — | ~2.1k | Automated safety check: Notes | None | |
| Drizzle Migration Safety on Neonsuperset-sh/superset | 15k | — | ~2k | Automated safety check: Notes | Custom licence | |
| Database Migrationdavila7/claude-code-templates | 33k | 11 repos | ~2.8k | Automated safety check: Pass | MIT |
Similar skills
- Official
- Official
MySQL Schema and Query Tuning
planetscale/database-skills
Guides safe, measurable MySQL and InnoDB changes across schema design, indexing, query tuning, transactions, locking and replication, with rollout steps.
Wtf
noobnooc/agent
Pre-launch and pre-commit audit for vibe coding projects. An agent skill from noobnooc/agent.
Drizzle Migration Safety on Neon
superset-sh/superset
Generates a Drizzle migration on a fresh Neon branch and runs a production-safety checklist for table sizes, lock order and load rehearsal before the PR opens.
Database Migration
davila7/claude-code-templates
Master database schema and data migrations across ORMs (Sequelize, TypeORM, Prisma), including rollback strategies and zero-downtime deployments.
Lovable
aiskillstore/marketplace
Integration skill for Lovable.dev projects. An agent skill from aiskillstore/marketplace.
More from openclaw/clawhub
All 55 skills in this repoAxiom Alerting Management
openclaw/clawhub
Creates and manages Axiom monitors and notifiers end to end through the v2 API, with scripts for each CRUD operation and a recommended create-validate-tune workflow.
Axiom Dashboard Builder
openclaw/clawhub
Designs and deploys Axiom dashboards through the API, choosing chart types and writing APL or metrics queries, with templates and migration notes for Splunk and Grafana.
Axiom Cost Control
openclaw/clawhub
Finds unused data in Axiom by analyzing query patterns, then deploys a cost dashboard and ingest monitors to keep spend under the contract limit.
Axiom Metrics Query
openclaw/clawhub
Explores and queries OpenTelemetry metrics in Axiom MetricsDB, listing datasets, metrics and tags first and picking the right aggregation for each metric's type.
Axiom SRE Investigator
openclaw/clawhub
Investigates incidents and production problems with hypothesis-driven debugging, queries Axiom observability data when available, and keeps secrets out of commands and output.
Axiom Eval Writer
openclaw/clawhub
Scaffolds evaluation suites for the Axiom AI SDK: eval files, scorers, flag schemas and axiom.config.ts, generated from plain descriptions of an AI capability.
Related
Works with
Categories
Questions about ClawHub Convex Conventions
What does ClawHub Convex Conventions do?
Applies ClawHub's repository-specific Convex rules and routes work to the right managed Convex skill for performance, migrations, retention and deployments. Convex guidance is split in two: managed upstream skills cover general framework behavior, and this skill covers ClawHub's own boundaries.md` before editing Convex code, names the target runtime (`local`, `dev` or `prod`) before any Convex command, and routes to the most specific companion: `convex-performance-audit` for query cost and indexes, `convex-migration-helper` and `create-and-cleanup-migration` for migrations and backfills, and `convex-retention` for TTL fields and cleanup crons.
When should I use ClawHub Convex Conventions?
ClawHub Convex Conventions fits situations like: changing anything under convex/ in the ClawHub repository; running Convex commands against local, dev or prod deployments; auditing query performance or planning a production migration; adding retention or cleanup for a table.
How do I install ClawHub Convex Conventions in Claude Code?
Run `npx skills add openclaw/clawhub --skill clawhub-convex -a claude-code`. Or copy the skill folder (.agents/skills/clawhub-convex in openclaw/clawhub) into .claude/skills/clawhub-convex in your project. Claude Code loads it when a task matches its description.
How do I install ClawHub Convex Conventions in Codex?
Run `npx skills add openclaw/clawhub --skill clawhub-convex -a codex`. Or copy the skill folder (.agents/skills/clawhub-convex in openclaw/clawhub) into .agents/skills/clawhub-convex in your project. Codex loads it when a task matches its description.
Can I use ClawHub Convex Conventions in Cursor, Gemini CLI or GitHub Copilot?
Cursor, Gemini CLI, GitHub Copilot and OpenCode also load SKILL.md folders. With the skills CLI, run `npx skills add openclaw/clawhub --skill clawhub-convex -a cursor` (or -a gemini-cli, github-copilot or opencode for the others). To copy it by hand, put the folder in .cursor/skills/clawhub-convex, .gemini/skills/clawhub-convex, .github/skills/clawhub-convex and .opencode/skills/clawhub-convex in your project.
What does ClawHub Convex Conventions need to run?
Going by SKILL.md and its folder, ClawHub Convex Conventions needs the command-line tools its instructions call (bunx and bun). Our summary lists: The ClawHub repository with bun installed; Access to the target Convex deployment.
Does ClawHub Convex Conventions access the network?
SKILL.md contains no URLs. Any network use would come from the scripts or tools the agent runs. This is read from the text; nothing was executed.
Is ClawHub Convex Conventions safe to install?
Our automated static check of SKILL.md found notes only (mentions a .env file), nothing it rates as a warning. It is not a guarantee. Review the folder before installing.
What licence does ClawHub Convex Conventions use?
ClawHub Convex Conventions is published under the MIT licence (the repository's licence). It allows redistribution, so the full SKILL.md is shown on this page.
How many tokens does ClawHub Convex Conventions use?
About 1.4k tokens (SKILL.md is roughly 5.7k characters). Agents keep only the skill's name and description in context until a task matches; then they load SKILL.md in full.
What are the alternatives to ClawHub Convex Conventions?
Skills that share tags, products or a category with ClawHub Convex Conventions: Supabase Postgres Best Practices (supabase/agent-skills, 2.7k stars), MySQL Schema and Query Tuning (planetscale/database-skills, 708 stars), Wtf (noobnooc/agent, 1.4k stars) and Drizzle Migration Safety on Neon (superset-sh/superset, 15k stars). The comparison table on this page puts their stars, adoption, token cost, safety result and licence side by side.
Who maintains ClawHub Convex Conventions?
openclaw (a GitHub organization) maintains it in openclaw/clawhub, which has 9,497 GitHub stars. The repository holds 55 skills in this directory. The repository was last updated on October 9, 2026.
Source: openclaw/clawhub on GitHub. Facts on this page come from the repository at the commit we read; the author's words are quoted as theirs.