---

name: convex description: >- Assists with building real-time reactive backends using Convex. Use when creating databases with automatic client sync, reactive queries, file storage, scheduled functions, or full-text and vector search. Trigger words: convex, reactive backend, real-time database, useQuery, useMutation, convex functions, convex schema. license: Apache-2.0 compatibility: "Works with React, Next.js, Remix, React Native" metadata: author: terminal-skills version: "1.0.0" category: data-ai tags: ["convex", "real-time", "reactive", "backend", "database"]

Convex

Overview

Convex is a reactive backend platform where database queries, mutations, and actions are defined in TypeScript and data automatically syncs to connected clients in real-time. It eliminates WebSocket code, polling, and cache invalidation, providing ACID transactions and optimistic updates out of the box.

Instructions

• When defining schemas, use defineSchema() with defineTable() and typed validators (v.string(), v.number(), v.id("tableName")), and define indexes for all filtered and sorted queries.
• When writing functions, use queries for reads (automatically reactive), mutations for writes (transactional, triggers reactive updates), and actions for external API calls (non-transactional).
• When building React UIs, use useQuery() for reactive data subscriptions that auto-update, useMutation() for writes with optimistic updates, and usePaginatedQuery() for infinite scroll.
• When handling authentication, use convex-auth for built-in auth or integrate Clerk/Auth0, and validate user identity at the start of every mutation with ctx.auth.getUserIdentity().
• When processing background work, use ctx.scheduler.runAfter() for delayed execution and cron jobs for recurring tasks instead of making mutations slow.
• When storing files, use ctx.storage.store() for upload and ctx.storage.getUrl() for serving URLs without S3 or CDN configuration.
• When implementing search, use full-text search indexes with searchIndex() or vector search with vectorIndex() for AI/RAG applications, with metadata filtering.

Examples

Example 1: Build a real-time chat application

User request: "Create a real-time chat app with Convex and React"

Actions:

1. Define messages table with schema, author reference, and timestamp index
2. Create a query function that returns messages sorted by timestamp
3. Create a mutation for sending messages with auth validation
4. Use useQuery() in React to subscribe to messages with automatic real-time updates

Output: A chat application where messages appear instantly for all connected users without WebSocket code.

Example 2: Add full-text and vector search

User request: "Implement search across articles with both keyword and semantic search"

Actions:

1. Define search index on article body field with searchIndex()
2. Define vector index on embedding field with vectorIndex()
3. Create query functions for text search and vector similarity search
4. Combine metadata filtering with search for scoped results

Output: A dual search system supporting both keyword matching and semantic similarity queries.

Guidelines

• Use schema validation in production: defineSchema() catches type errors at deploy time, not runtime.
• Define indexes for all filtered/sorted queries to ensure efficient data access.
• Use queries for reads, mutations for writes, actions for external APIs; never mix concerns.
• Keep mutations small and fast since they hold a database lock; move heavy processing to actions.
• Use ctx.scheduler.runAfter() for background work instead of making mutations slow.
• Validate user identity at the start of every mutation to prevent unauthorized writes.
• Use optimistic updates for interactive UIs; the client sees the change instantly while the server confirms.