convex
npx machina-cli add skill PolarCoding85/convex-agent-skillz/convex-skill --openclawConvex Backend Development
Core Architecture
Convex is a reactive database where queries are TypeScript functions. The sync engine (queries + mutations + database) is the heart of Convex — center your app around it.
Function Types
| Type | DB Access | Deterministic | Cached/Reactive | Use For |
|---|---|---|---|---|
query | Read only | Yes | Yes | All reads, subscriptions |
mutation | Read/Write | Yes | No | All writes (transactions) |
action | Via ctx.run* | No | No | External APIs, LLMs, email |
httpAction | Via ctx.run* | No | No | Webhooks, custom HTTP |
Key rule: Queries and mutations cannot make network requests. Actions cannot directly access the database.
Project Structure (Best Practice)
convex/
├── _generated/ # Auto-generated types (commit this)
├── schema.ts # Database schema
├── model/ # Helper functions (most logic lives here)
│ ├── users.ts
│ └── messages.ts
├── users.ts # Thin wrappers exposing public API
├── messages.ts
├── crons.ts # Cron job definitions
└── http.ts # HTTP action routes
Essential Patterns
1. Function Structure
// convex/messages.ts
import { query, mutation, internalMutation } from './_generated/server';
import { internal } from './_generated/api';
import { v } from 'convex/values';
// PUBLIC query with validators (always validate public functions)
export const list = query({
args: { channelId: v.id('channels') },
handler: async (ctx, { channelId }) => {
return await ctx.db
.query('messages')
.withIndex('by_channel', (q) => q.eq('channelId', channelId))
.order('desc')
.take(50);
}
});
// PUBLIC mutation with validators and auth check
export const send = mutation({
args: { channelId: v.id('channels'), body: v.string() },
handler: async (ctx, { channelId, body }) => {
const user = await ctx.auth.getUserIdentity();
if (!user) throw new Error('Unauthorized');
await ctx.db.insert('messages', {
channelId,
body,
authorId: user.subject
});
}
});
// INTERNAL mutation (for scheduling, crons, actions)
export const deleteOld = internalMutation({
args: { before: v.number() },
handler: async (ctx, { before }) => {
const old = await ctx.db
.query('messages')
.withIndex('by_createdAt', (q) => q.lt('_creationTime', before))
.take(100);
for (const msg of old) {
await ctx.db.delete(msg._id);
}
}
});
2. Helper Functions Pattern
Most logic should live in helper functions, NOT in query/mutation handlers:
// convex/model/users.ts
import { QueryCtx, MutationCtx } from '../_generated/server';
import { Doc } from '../_generated/dataModel';
export async function getCurrentUser(
ctx: QueryCtx
): Promise<Doc<'users'> | null> {
const identity = await ctx.auth.getUserIdentity();
if (!identity) return null;
return await ctx.db
.query('users')
.withIndex('by_tokenIdentifier', (q) =>
q.eq('tokenIdentifier', identity.tokenIdentifier)
)
.unique();
}
export async function requireUser(ctx: QueryCtx): Promise<Doc<'users'>> {
const user = await getCurrentUser(ctx);
if (!user) throw new Error('Unauthorized');
return user;
}
3. Actions with Scheduling
// convex/ai.ts
import { action, internalMutation } from './_generated/server';
import { internal } from './_generated/api';
import { v } from 'convex/values';
export const summarize = action({
args: { documentId: v.id('documents') },
handler: async (ctx, { documentId }) => {
// Read data via internal query
const doc = await ctx.runQuery(internal.documents.get, { documentId });
// Call external API
const response = await fetch('https://api.openai.com/v1/...', {...});
const summary = await response.json();
// Write result via internal mutation
await ctx.runMutation(internal.documents.setSummary, {
documentId,
summary: summary.text
});
}
});
// Trigger action from mutation (not directly from client)
export const requestSummary = mutation({
args: { documentId: v.id('documents') },
handler: async (ctx, { documentId }) => {
const user = await ctx.auth.getUserIdentity();
if (!user) throw new Error('Unauthorized');
await ctx.db.patch(documentId, { status: 'processing' });
// Schedule action (runs after mutation commits)
await ctx.scheduler.runAfter(0, internal.ai.summarizeInternal, {
documentId
});
}
});
4. Application Errors
import { ConvexError } from 'convex/values';
export const assignRole = mutation({
args: { roleId: v.id('roles'), userId: v.id('users') },
handler: async (ctx, { roleId, userId }) => {
const existing = await ctx.db
.query('assignments')
.withIndex('by_role', (q) => q.eq('roleId', roleId))
.first();
if (existing) {
throw new ConvexError({
code: 'ROLE_TAKEN',
message: 'Role is already assigned'
});
}
await ctx.db.insert('assignments', { roleId, userId });
}
});
Critical Rules
DO ✅
- Use
internal.functions for allctx.run*,ctx.scheduler, and crons - Always validate args for public functions with
v.*validators - Always check auth in public functions:
ctx.auth.getUserIdentity() - Use indexes with
.withIndex()instead of.filter() - Await all promises (enable
no-floating-promisesESLint rule) - Keep actions small — put logic in queries/mutations
- Batch database operations in single mutations
- Use
ConvexErrorfor user-facing errors
DON'T ❌
- Don't use
api.functions for scheduling (useinternal.) - Don't use
.filter()on queries — use indexes or TypeScript filter - Don't use
.collect()on unbounded queries (use.take()or pagination) - Don't use
Date.now()in queries (breaks caching) - Don't call actions directly from client (trigger via mutation + scheduler)
- Don't make sequential
ctx.runQuery/runMutationcalls in actions (batch them) - Don't use
ctx.runActionunless switching runtimes (use helper functions)
Reference Guides
For detailed patterns, see:
- FUNCTIONS.md — Queries, mutations, actions, internal functions
- VALIDATION.md — Argument validation, extended validators
- ERROR_HANDLING.md — ConvexError, application errors
- HTTP_ACTIONS.md — HTTP actions, CORS, webhooks
- RUNTIMES.md — Default vs Node.js runtime, bundling, debugging
- DATABASE.md — Schema, indexes, reading/writing data
- SEARCH.md — Full-text search, vector search, RAG patterns
- ADVANCED.md — System tables, schema philosophy, OCC
- AUTH.md — Row-level security, Convex Auth (first-party)
- SCHEDULING.md — Crons, scheduled functions, workflows
- FILE_STORAGE.md — Upload, store, serve, delete files
- NEXTJS.md — Next.js App Router, SSR, Server Actions
Auth Provider Skills (add to project as needed):
convex-auth— Universal auth patterns, storing users, debuggingconvex-clerk— Clerk setup, webhooks, JWT configurationconvex-workos— WorkOS AuthKit setup, auto-provisioning
Source
git clone https://github.com/PolarCoding85/convex-agent-skillz/blob/main/.claude/skills/convex-skill/SKILL.mdView on GitHub Overview
Master Convex backend development to build reactive, server-side logic with queries, mutations, actions, and schemas. This skill covers authentication, scheduling, file storage, search, and Next.js App Router integration, helping you design robust Convex apps. It emphasizes organizing code around the Convex sync engine and following best practices for projects like convex/schema.ts, convex/model/*, and http.ts.
How This Skill Works
Convex exposes function types—query, mutation, action, and httpAction—that run inside the Convex sync engine (the heart of the system). Queries and mutations are deterministic and cannot perform network requests, while actions can invoke external APIs. Code lives under convex/ with a _generated server/api, and you expose a public API surface (e.g., convex/users.ts) while keeping business logic in helper functions under convex/model. For HTTP-based workflows, use httpAction/httpRouter and be mindful of CORS and webhooks.
When to Use It
- You're building a Convex-backed app (Next.js App Router) and need a clean public API surface
- You're implementing read/write data through queries/mutations with proper auth checks
- You're scheduling recurring tasks or crons using convex cron or internalMutation
- You're handling file uploads, storage, and URL generation via ctx.storage and generateUploadUrl
- You need advanced search capabilities (full-text, vector search) and embeddings using searchIndex/vectorIndex
Quick Start
- Step 1: Scaffold Convex project structure: convex/schema.ts, _generated, model/, http.ts, crons.ts
- Step 2: Implement sample functions (list and send) with appropriate validators and auth checks as shown
- Step 3: Wire up ConvexProvider in Next.js App Router and test with useQuery/useMutation
Best Practices
- Structure should mirror the file tree: convex/schema.ts, _generated/, model/, and http.ts
- Put most business logic in convex/model helper functions, not in query/mutation handlers
- Always validate inputs and enforce authentication in mutations
- Use internalMutation for cron jobs and scheduled tasks
- Keep public API wrappers in separate files (e.g., convex/users.ts) for a clean surface
Example Use Cases
- Query a list of messages by channel using an index (by_channel) and order/limit
- Send a message with auth check and insert into messages table
- Internal mutation deleteOld used by a cron to purge old messages
- HTTP action route in http.ts to handle a webhook
- Upload a file: generateUploadUrl, store, and retrieve the URL via storage.getUrl