Loading…
Read and write data in Appflare handlers with the typed ctx.db API, including findMany and findFirst with where operators (eq, in, gt, contains/startsWith/endsWith, exists, includes, geoWithin) and and/or/not combinators, relation loading and filtering with "with", orderBy, limit/offset, iterate and cursor pagination, insert with nested relations, update with increment/decrement expressions and expectRows guards, atomic batch and transaction writes, upsert with target/set, delete, count, sum, avg, min, max and groupBy aggregates, and the ctx.$db raw Drizzle escape hatch. Use when writing database logic, filters, search, joins, pagination, counters, aggregates, upserts, transfers or bulk updates inside Appflare query, mutation, scheduler or cron handlers.
appflare-querying is an agent skill entry in ChatHome Skills, sourced from GitHub Skill Search and scored 58/100. # Appflare data access (`ctx.db`) ## Default patterns ```ts // list with filters, relations, sort and limit const tasks = await ctx.db.tasks.findMany({ where: {. As an agent skill, it packages a reusable instruction set that AI coding agents such as Codex and Claude Code can load to perform this task without hand-written glue code. ChatHome Skills discovered this entry through its daily ingest of official registries and GitHub discovery queries, and re-verifies repository facts, freshness signals, and install metadata on every run. The quality score weighs official-registry presence, a working install command, license clarity, GitHub star trajectory, and repository freshness — the full formula is on the Sources page. The install command above is ready to copy. Review the last-pushed date and repository status before adding appflare-querying to a production agent workflow; the snapshot facts below are point-in-time values from the most recent ingest.
codex skill install Imtiajrex/appflare-skillsReview the upstream source before running this command.
Scan coverage: Install metadata and the indexed document body.
Automated signals from install metadata and a bounded skill body — not a full code security audit and not a recursive source or dependency review.
# Appflare data access (`ctx.db`) ## Default patterns ```ts // list with filters, relations, sort and limit const tasks = await ctx.db.tasks.findMany({ where: { projectId: args.pro