aaronvanston

Building AI agents and assistants with Convex. Use when implementing chat interfaces, AI assistants, tool-calling agents, RAG (retrieval-augmented generation), conversation threads, or integrating LLMs like OpenAI/Anthropic.

File uploads, storage, and serving in Convex. Use when implementing file uploads, generating upload URLs, serving files, managing file metadata, or building file-based features like avatars, attachments, or media galleries.

Database migrations and schema evolution in Convex. Use when adding new fields, changing data structures, backfilling data, renaming fields, or performing zero-downtime schema changes.

Realtime subscriptions and optimistic updates in Convex. Use when implementing live data updates, optimistic UI, pagination with realtime, presence indicators, typing indicators, or any feature requiring instant data synchronization.

Best practices for Convex actions, transactions, and scheduling. Use when writing actions that call external APIs, using ctx.runQuery/ctx.runMutation, scheduling functions with ctx.scheduler, or working with the Convex runtime vs Node.js runtime ("use node").

Scheduled functions and cron jobs in Convex. Use when setting up recurring tasks, cleanup jobs, data syncing, scheduled notifications, or any background automation that runs on a schedule.

HTTP actions for webhooks and API endpoints in Convex. Use when building webhook handlers (Stripe, Clerk, GitHub), creating REST API endpoints, handling file uploads/downloads, or implementing CORS for browser requests.

Code organization patterns and TypeScript best practices for Convex. Use when structuring a Convex project, writing helper functions, defining schemas, working with types like QueryCtx/MutationCtx/ActionCtx, or organizing code in a convex/model directory.

Build toward the model the code should have, not the one it currently has. Use when implementing, refactoring, addressing review feedback, deleting stale paths, evaluating tests as contracts, or deciding whether to reshape code instead of fitting into it.

Validate runtime behavior with real end-to-end evidence. Use when a change affects an app, browser surface, API, CLI, workflow, integration, dev server, runtime orchestration, or any user-visible behavior that tests and typechecks alone cannot prove.

Write high-signal automated tests and avoid test theatre. Use when adding, reviewing, deleting, or restructuring unit, integration, property, golden, fixture, or regression tests.

Ingest a meeting transcript into a markdown wiki -- creating cleaned transcripts, structured meeting notes, person profiles, term stubs, and feature evidence. Use when the user asks to "ingest meeting notes," "process a meeting," "add meeting to wiki," "create meeting notes from transcript," "process Granola notes," or provides a transcript to be turned into wiki content. Works with any domain wiki that follows the markdown content directory pattern.

Set up a markdown-based wiki knowledge base in a repository. Creates the directory structure, writing guide, AGENTS.md configuration, and initial content templates. Use when the user asks to "set up a wiki," "create a knowledge base," "start a wiki," "initialize wiki content," "set up a second brain," or wants to create a structured markdown content system for learning and research in their project.

Create deeply researched wiki term entries with web research, practical examples, and cross-references. Use when the user asks to "create a wiki term," "write a term entry," "add a glossary definition," "research a concept," "define this term," or when a meeting ingestion identifies terms to create. Produces comprehensive entries with external citations, worked examples, and detailed breakdowns. Works with any domain wiki using markdown content.

Convex backend development - queries, mutations, actions, schemas, indexes, realtime subscriptions, optimistic updates, file storage, HTTP endpoints, webhooks, cron jobs, migrations, AI/LLM agents, RAG, security, authentication, authorization, rate limiting, error handling with ConvexError, code review, convex-helpers, custom functions, triggers, row-level security, relationship helpers, Hono, CORS, Zod validation, CRUD, manual pagination, QueryStreams, query caching, sessions, workpool, components, RBAC, audit trails. Use when writing Convex functions, defining schemas, building real-time features, integrating external APIs, handling file uploads, setting up scheduled jobs, performing database migrations, building AI chat interfaces, reviewing Convex code for production readiness, using convex-helpers patterns, or building reusable Convex components.

Build tables and datagrids with TanStack Table v8. Covers column definitions, row models, sorting, filtering, pagination, grouping, expanding, row selection, column sizing/ordering/pinning/visibility, virtualization, row pinning, faceting, fuzzy filtering, custom features, state management, and rendering. React adapter primary, core API is framework-agnostic. Use when asked to "build a data table", "add sorting to a table", "paginate results", "filter table data", "create a datagrid", "add row selection", "virtualize a large table", or any task involving TanStack Table.

Write bold, minimal slide content with punchy headlines, concise body text, and impactful bullet points. Use when writing slides, asking "write content for...", "draft slides about...", or "help me phrase this slide...". Transforms ideas into presentation-ready copy designed for speaking to, not reading from.

Visual design guidance for bold, minimal presentations. Provides layout patterns, typography hierarchy, color specifications, and slide composition rules. Use when asking "how should this slide look?", "design guidance for...", "what layout for this slide?", or when translating content into visual structure for a presentation.

Generate speaker notes and talking points for conversational, off-the-cuff delivery. Creates scannable prompts designed for riffing — not scripts to read. Use when asking "write speaker notes for...", "talking points for...", "what should I say on this slide...", or when preparing to present a deck live.

Generate structured presentation outlines with bold statement slides, section dividers, and clear narrative arcs. Use when starting a new presentation, planning a deck structure, or asking "outline a presentation about...", "structure a deck for...", or "create a presentation flow for...". Outputs markdown outlines ready to translate into slides.

Create investor pitch decks designed to stand alone without a presenter. Follows Sequoia/YC frameworks with traction-first structure and standalone readability. Use when creating a "pitch deck", "investor presentation", "fundraising deck", or any deck sent async to investors, partners, or stakeholders who won't have the presenter alongside.

Granola meeting notes CLI (list/search/show/export + transcript fetch).

Generic CLI utilities for maintaining an Obsidian vault (lint/linkify/promote stubs).