Convex Design
openclaw/clawhub
Design and build reactive, type-safe, production-grade backends on Convex.
Designs convex/schema.ts tables, validators, indexes, and relationships, and keeps the schema honest as data evolves.
$ npx skills add waynesutton/builder-skills --skill convex-schema-validator -a claude-codeProject install by default; add -g for ~/.claude/skills/.
$ gh skill install waynesutton/builder-skills convex-schema-validator --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/waynesutton/builder-skills.git skills-src && mkdir -p .claude/skills && cp -r skills-src/skills/convex-schema-validator .claude/skills/convex-schema-validator && 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 "convex-schema-validator" agent skill from https://github.com/waynesutton/builder-skills/tree/main/skills/convex-schema-validator into .claude/skills/convex-schema-validator/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "convex-schema-validator", 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/waynesutton/builder-skills/tree/main/skills/convex-schema-validatorType 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 waynesutton/builder-skills --skill convex-schema-validator -a codexProject install goes to .agents/skills/; add -g for ~/.codex/skills/.
$ gh skill install waynesutton/builder-skills convex-schema-validator --agent codexProject scope by default (.agents/skills/); add --scope user for a personal install.
$ git clone --depth 1 https://github.com/waynesutton/builder-skills.git skills-src && mkdir -p .agents/skills && cp -r skills-src/skills/convex-schema-validator .agents/skills/convex-schema-validator && rm -rf skills-srcUse ~/.agents/skills/ instead of .agents/skills for a personal install.
Codex skills documentation · loads skills from .agents/skills/
Install the "convex-schema-validator" agent skill from https://github.com/waynesutton/builder-skills/tree/main/skills/convex-schema-validator into .agents/skills/convex-schema-validator/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "convex-schema-validator", 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 waynesutton/builder-skills --skill convex-schema-validator -a cursorProject install goes to .agents/skills/; add -g for ~/.cursor/skills/.
$ gh skill install waynesutton/builder-skills convex-schema-validator --agent cursorProject scope by default (.agents/skills/); add --scope user for a personal install.
$ git clone --depth 1 https://github.com/waynesutton/builder-skills.git skills-src && mkdir -p .cursor/skills && cp -r skills-src/skills/convex-schema-validator .cursor/skills/convex-schema-validator && 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 "convex-schema-validator" agent skill from https://github.com/waynesutton/builder-skills/tree/main/skills/convex-schema-validator into .cursor/skills/convex-schema-validator/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "convex-schema-validator", 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/waynesutton/builder-skills.git --path skills/convex-schema-validator--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 waynesutton/builder-skills --skill convex-schema-validator -a gemini-cliProject install goes to .agents/skills/; add -g for ~/.gemini/skills/.
$ gh skill install waynesutton/builder-skills convex-schema-validator --agent gemini-cliProject scope by default (.agents/skills/); add --scope user for a personal install.
$ git clone --depth 1 https://github.com/waynesutton/builder-skills.git skills-src && mkdir -p .gemini/skills && cp -r skills-src/skills/convex-schema-validator .gemini/skills/convex-schema-validator && 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 "convex-schema-validator" agent skill from https://github.com/waynesutton/builder-skills/tree/main/skills/convex-schema-validator into .gemini/skills/convex-schema-validator/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "convex-schema-validator", 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 waynesutton/builder-skills convex-schema-validatorInstalls 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 waynesutton/builder-skills --skill convex-schema-validator -a github-copilotProject install goes to .agents/skills/; add -g for ~/.copilot/skills/.
$ git clone --depth 1 https://github.com/waynesutton/builder-skills.git skills-src && mkdir -p .github/skills && cp -r skills-src/skills/convex-schema-validator .github/skills/convex-schema-validator && 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 "convex-schema-validator" agent skill from https://github.com/waynesutton/builder-skills/tree/main/skills/convex-schema-validator into .github/skills/convex-schema-validator/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "convex-schema-validator", 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 waynesutton/builder-skills --skill convex-schema-validator -a opencodeOpenCode documents no install command of its own. Project install goes to .agents/skills/; add -g for ~/.config/opencode/skills/.
$ gh skill install waynesutton/builder-skills convex-schema-validator --agent opencodeProject scope by default (.agents/skills/); add --scope user for a personal install.
$ git clone --depth 1 https://github.com/waynesutton/builder-skills.git skills-src && mkdir -p .opencode/skills && cp -r skills-src/skills/convex-schema-validator .opencode/skills/convex-schema-validator && 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 "convex-schema-validator" agent skill from https://github.com/waynesutton/builder-skills/tree/main/skills/convex-schema-validator into .opencode/skills/convex-schema-validator/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "convex-schema-validator", 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.
convex-schema-validatorDesigns convex/schema.ts tables, validators, indexes, and relationships, and keeps the schema honest as data evolves.
Convex Schema Validator is an agent skill from waynesutton/builder-skills. Designs convex/schema.ts tables, validators, indexes, and relationships, and keeps the schema honest as data evolves. Use when creating tables, adding fields, choosing index fields, modeling relationships, or when a validator error appears at deploy time.
Its SKILL.md is about 2.4k tokens, which your agent loads only when the skill is triggered. The skill folder holds 5 other files, including assets (for example `agents/openai.yaml`).
The repository describes itself as: Builder skills for Convex apps. Convex patterns plus a PRD, task.md, changelog, and files.md workflow for Claude Code, Codex, Cursor, and OpenCode. The licence is Apache-2.0.
Read from SKILL.md and the folder at commit 82d1ce2. It shows what the files ask for, not the result of running them.
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.
Shell commands in SKILL.md call:
npxFrom the folder's file list and the shell code blocks in SKILL.md.
Links to these hosts (documentation or services it may open):
docs.convex.devFrom URLs in SKILL.md, links to its own repository left out.
Names no API keys, tokens, secrets or passwords.
From names ending in _API_KEY, _TOKEN, _SECRET, _KEY or _PASSWORD in SKILL.md.
Convex Schema Validator loads about 2.4k tokens when it runs. Until then it costs about 70 tokens; SKILL.md has 887 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.
The automated check found no risky patterns in SKILL.md.
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.
The full file from waynesutton/builder-skills at commit 82d1ce2, republished under its Apache-2.0 licence (© waynesutton). 887 words, ~2,386 tokens.
.claude/skills/convex-schema-validator/SKILL.md (or your agent's skills folder). This skill also uses 3 other files; get the full folder from GitHub.Produces a convex/schema.ts that types every document, indexes every query path, and passes validation against the data already in the database. The one rule: every withIndex in a function needs a matching .index() here, named after its fields, queried in field order.
.filter() and needs an index insteadv.idnpx convex dev fails with a schema validation error// convex/schema.ts
import { defineSchema, defineTable } from "convex/server";
import { v } from "convex/values";
export default defineSchema({
users: defineTable({
name: v.string(),
email: v.string(),
avatarUrl: v.optional(v.string()),
}).index("by_email", ["email"]),
tasks: defineTable({
userId: v.id("users"),
title: v.string(),
completed: v.boolean(),
priority: v.union(v.literal("low"), v.literal("medium"), v.literal("high")),
})
.index("by_userId", ["userId"])
.index("by_userId_and_completed", ["userId", "completed"]),
});defineTable takes either an object of field validators or a single v.union of v.object validators (see discriminated unions). Every table gets _id and _creationTime for free. Do not declare them.
| Validator | TypeScript type | Note |
|---|---|---|
v.string() | string | UTF-8, under 1 MB |
v.number() | number | Float64. Use for timestamps and counts |
v.boolean() | boolean | |
v.null() | null | undefined is not a Convex value. Return null instead |
v.int64() | bigint | Not v.bigint(), which is deprecated |
v.bytes() | ArrayBuffer | Under 1 MB |
v.id("table") | Id<"table"> | Typed reference. Convex does not enforce that the target exists |
v.array(t) | T[] | At most 8192 items |
v.object({...}) | {...} | At most 1024 entries. Keys cannot start with $ or _ |
v.record(k, t) | Record<K, T> | Dynamic ASCII keys. No v.map or v.set |
v.union(a, b) | A | B | Use v.literal members for enums |
v.literal("x") | "x" | |
v.optional(t) | T | undefined | Field may be absent |
v.any() | any | Last resort. Loses type safety and validation |
v.optional means the key may be missing from the document. v.union(t, v.null()) means the key is always present and may hold null. They are different at validation time.
items: defineTable({
description: v.optional(v.string()), // may be absent
deletedAt: v.union(v.number(), v.null()), // always present, may be null
notes: v.optional(v.union(v.string(), v.null())), // either
}),Use v.optional for fields added after the table had data. Use v.union(..., v.null()) when "explicitly cleared" carries meaning.
For a table whose documents come in several shapes, pass a v.union of v.object validators to defineTable. Each member has the same literal key so TypeScript narrows on it.
events: defineTable(
v.union(
v.object({
kind: v.literal("signup"),
userId: v.id("users"),
email: v.string(),
}),
v.object({
kind: v.literal("purchase"),
userId: v.id("users"),
orderId: v.id("orders"),
amount: v.number(),
}),
),
).index("by_kind", ["kind"]),Put the discriminant (kind) first in any index on a union table so queries can scope to one shape. Prefer this over one wide object full of v.optional fields.
Name the index after its fields in order: by_field1_and_field2. Querying must follow the same order: equality on a prefix of the fields, then at most one range on the next field.
messages: defineTable({
channelId: v.id("channels"),
authorId: v.id("users"),
sentAt: v.number(),
})
.index("by_channelId", ["channelId"])
.index("by_channelId_and_authorId", ["channelId", "authorId"])
.index("by_channelId_and_sentAt", ["channelId", "sentAt"]),// Valid: equality on channelId, range on sentAt
await ctx.db
.query("messages")
.withIndex("by_channelId_and_sentAt", (q) =>
q.eq("channelId", args.channelId).gt("sentAt", args.since),
)
.order("desc")
.take(50);You cannot skip channelId and filter on sentAt alone with that index. Add by_sentAt if that query exists. _creationTime is appended to every index automatically, so results within an equal prefix sort by creation time.
Reserved names: by_id and by_creation_time. Limits: 32 indexes per table, 16 fields per index.
withIndex, .eq, or a range comparisonuserId, channelId, orgId) on the child table.collect() then in memory filter is fineIf a query uses .filter(), that is the signal to add an index and switch to withIndex.
Link documents with v.id("table") on the child. Do not nest growing arrays of objects inside the parent.
// Good: one to many via a foreign key
posts: defineTable({
authorId: v.id("users"),
title: v.string(),
}).index("by_authorId", ["authorId"]),
comments: defineTable({
postId: v.id("posts"),
authorId: v.id("users"),
body: v.string(),
}).index("by_postId", ["postId"]),
// Many to many via a join table
postTags: defineTable({
postId: v.id("posts"),
tagId: v.id("tags"),
})
.index("by_postId", ["postId"])
.index("by_tagId", ["tagId"]),Embed with v.object or a small v.array only when the data is bounded, always loaded with the parent, and updated together. A user's settings object is a good embed. A user's posts array is not: it hits the 8192 item cap and every post edit rewrites the user document.
_id: Id<"table"> and _creationTime: number (ms since epoch) exist on every document. Include them in return validators when a function returns whole documents:
returns: v.array(
v.object({
_id: v.id("tasks"),
_creationTime: v.number(),
userId: v.id("users"),
title: v.string(),
completed: v.boolean(),
}),
),Do not add your own createdAt unless you need a value that differs from insertion time.
Declared on the table like regular indexes. filterFields must be top level fields.
articles: defineTable({
title: v.string(),
body: v.string(),
category: v.string(),
embedding: v.array(v.number()),
})
.searchIndex("search_body", {
searchField: "body",
filterFields: ["category"],
})
.vectorIndex("by_embedding", {
vectorField: "embedding",
dimensions: 1536,
filterFields: ["category"],
}),Query search indexes with withSearchIndex in queries. Vector search runs only in actions via ctx.vectorSearch.
| Mistake | Why it breaks | Do instead |
|---|---|---|
withIndex("by_userId") with no matching .index() | Deploy fails | Declare the index in the schema first |
Index named by_user on ["userId", "status"] | Hides what it covers, easy to misuse | by_userId_and_status |
Querying status on by_userId_and_status without userId | Index prefix rule | Add by_status or include userId |
Adding newField: v.string() to a table with rows | Existing documents fail validation | v.optional, backfill, then require |
posts: v.array(v.object(...)) on users | 8192 cap, write conflicts on every edit | Separate posts table with by_authorId |
v.bigint() | Deprecated | v.int64() |
Declaring _id or _creationTime in defineTable | Rejected | They are automatic |
v.any() to move fast | No validation, no types | Model the shape, or a v.union of the real cases |
v.union(v.string(), v.null()) for a new field | Old documents lack the key entirely | v.optional(v.string()) |
Storing a Date | Not a Convex value | v.number() ms timestamp |
convex/schema.ts and exports defineSchema(...) as defaultv.any() unless justifiedwithIndex call in convex/ has a matching .index() with fields in the namev.id("table") with an index on the child tablev.optionalv.union of v.literal or v.object members_id and _creationTime when returning whole documentsnpx convex dev pushes without a schema validation error© waynesutton, Apache-2.0. Rendered from Markdown: HTML in the file is shown as text, images as links, and headings moved down two levels. Raw file
SKILL.md and 3 other files (assets) in skills/convex-schema-validator of waynesutton/builder-skills.
Open the folder on GitHubat commit 82d1ce2
Convex Schema Validator 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 |
|---|---|---|---|---|---|---|
| Convex Schema Validator this skillwaynesutton/builder-skills | 404 | — | ~2.4k | Automated safety check: Pass | Apache-2.0 | |
| Convex Designopenclaw/clawhub | 9.5k | 1 repos | ~967 | Automated safety check: Notes | MIT | |
| Design Systemaffaan-m/ECC | 275k | — | ~698 | Automated safety check: Pass | MIT | |
| Design Guidepaperclipai/paperclip | 99k | 1 repos | ~3.1k | Automated safety check: Pass | MIT | |
| Convexdavila7/claude-code-templates | 32k | 3 repos | ~6.4k | Automated safety check: Notes | MIT | |
| Postgresql Table Designwshobson/agents | 40k | — | ~2k | Automated safety check: Pass | MIT |
openclaw/clawhub
Design and build reactive, type-safe, production-grade backends on Convex.
affaan-m/ECC
Generate a design system from an existing codebase or audit one for visual consistency: extract tokens (colors, typography, spacing, shadows) into design-tokens.json and CSS custom properties with…
paperclipai/paperclip
Paperclip UI design system guide for building consistent, reusable frontend components.
davila7/claude-code-templates
Convex reactive backend expert: schema design, TypeScript functions, real-time subscriptions, auth, file storage, scheduling, and deployment.
wshobson/agents
A skill your agent uses when designing or reviewing a PostgreSQL-specific schema.
thedotmack/claude-mem
Audits a design against Dieter Rams' ten principles of good design, scores each with evidence, and hands off a make-plan prompt for a new, refined or redesigned outcome.
waynesutton/builder-skills
Builds AI agents on the Convex agent component: threads, messages, tools that call queries and mutations, streaming, RAG with vector search, and workflows for multi step jobs.
waynesutton/builder-skills
Production patterns for Convex apps and the rules the @convex-dev/eslint-plugin enforces: validators, indexes, idempotent mutations, avoiding OCC conflicts, thin function wrappers, error handling.
waynesutton/builder-skills
Creates reusable Convex components with defineComponent, a clean client wrapper, their own schema, and an npm publish setup.
waynesutton/builder-skills
Schedules work in Convex: cron jobs in convex/crons.ts, one off scheduled functions with runAfter and runAt, batching large jobs, and cancelling or inspecting the queue.
waynesutton/builder-skills
Adds HTTP endpoints in convex/http.ts: webhook receivers with signature checks, REST style routes, CORS, auth headers, streaming responses, and file uploads over HTTP.
waynesutton/builder-skills
Changes a live Convex schema without downtime: make a field optional, backfill in batches, flip the validator, then clean up.
Designs convex/schema.ts tables, validators, indexes, and relationships, and keeps the schema honest as data evolves. Convex Schema Validator is an agent skill from waynesutton/builder-skills.ts tables, validators, indexes, and relationships, and keeps the schema honest as data evolves.
Convex Schema Validator fits situations like: creating tables; choosing index fields; modeling relationships; A validator error appears at deploy time.
Run `npx skills add waynesutton/builder-skills --skill convex-schema-validator -a claude-code`. Or copy the skill folder (skills/convex-schema-validator in waynesutton/builder-skills) into .claude/skills/convex-schema-validator in your project. Claude Code loads it when a task matches its description.
Run `npx skills add waynesutton/builder-skills --skill convex-schema-validator -a codex`. Or copy the skill folder (skills/convex-schema-validator in waynesutton/builder-skills) into .agents/skills/convex-schema-validator in your project. Codex loads it when a task matches its description.
Cursor, Gemini CLI, GitHub Copilot and OpenCode also load SKILL.md folders. With the skills CLI, run `npx skills add waynesutton/builder-skills --skill convex-schema-validator -a cursor` (or -a gemini-cli, github-copilot or opencode for the others). To copy it by hand, put the folder in .cursor/skills/convex-schema-validator, .gemini/skills/convex-schema-validator, .github/skills/convex-schema-validator and .opencode/skills/convex-schema-validator in your project.
Going by SKILL.md and its folder, Convex Schema Validator needs the command-line tools its instructions call (npx). Our summary lists: Node.js.
SKILL.md names 1 domain. As links in the text: docs.convex.dev. This is read from the text; nothing was executed.
Our automated static check of SKILL.md found no risky patterns, such as piping downloads into a shell, reading credential files or hidden Unicode. It is not a guarantee. Review the folder before installing.
Convex Schema Validator is published under the Apache-2.0 licence (the repository's licence). It allows redistribution, so the full SKILL.md is shown on this page.
About 2.4k tokens (SKILL.md is roughly 9.5k characters). Agents keep only the skill's name and description in context until a task matches; then they load SKILL.md in full.
Skills that share tags, products or a category with Convex Schema Validator: Convex Design (openclaw/clawhub, 9.5k stars), Design System (affaan-m/ECC, 275k stars), Design Guide (paperclipai/paperclip, 99k stars) and Convex (davila7/claude-code-templates, 32k stars). The comparison table on this page puts their stars, adoption, token cost, safety result and licence side by side.
waynesutton (a GitHub user) maintains it in waynesutton/builder-skills, which has 404 GitHub stars. The repository holds 17 skills in this directory. The repository was last updated on September 28, 2026.
Source: waynesutton/builder-skills on GitHub. Facts on this page come from the repository at the commit we read; the author's words are quoted as theirs.