---
title: "Example apps built with Pixeltable"
description: "29 runnable example apps, each one app.py."
url: "https://www.pixeltable.com/recipes"
---

# Example apps built with Pixeltable

Each app is one `app.py`: tables declared as `TableModel` classes, computed columns that run on insert, indexes, and `FastAPIRouter` routes. Every fact below is parsed from the app's own file. Each page has its run commands and the full `app.py`.

- [Chat agent](https://www.pixeltable.com/recipes/chat-agent.md): A knowledge base, conversation memory and an /ask route over Claude, with sentence embeddings for retrieval. (3 tables, 1 view, 5 computed columns, 8 HTTP routes; Embedding indexes, Views and iterators, LLM calls, UDFs)
- [Video search](https://www.pixeltable.com/recipes/video-search.md): Video frames extracted at one per second and indexed with CLIP, searchable by text or by image. (2 tables, 1 view, 5 computed columns, 6 HTTP routes; Embedding indexes, Views and iterators, Images, video and audio, File uploads)
- [Research Agent Memory](https://www.pixeltable.com/recipes/research-agent-memory.md): Durable, searchable long-term memory for an AI research assistant: per-user semantic recall, retrieval_udf lookups, tool calling and memory consolidation with custom aggregates (3 tables, 8 computed columns; Embedding indexes, B-tree indexes, Images, video and audio, LLM calls, UDFs)
- [Archery Range](https://www.pixeltable.com/recipes/archery-lanes.md): Migrate archery-range scoring sessions from legacy JSON into Pixeltable, score with date-aware computed columns, and run as an incremental scheduled pipeline (1 table, 13 computed columns; B-tree indexes, UDFs)
- [Apiary Advisor](https://www.pixeltable.com/recipes/apiary-advisor.md): RAG + tool-calling beekeeping advisor: custom embedding index, table-as-UDF agent pipeline, expr_udf mite math (4 tables, 1 view, 13 computed columns; Embedding indexes, B-tree indexes, Views and iterators, LLM calls, UDFs)
- [Orchard Harvest Crates](https://www.pixeltable.com/recipes/orchard-crates.md): Batch ETL for orchard harvest crates: CSV import/export, packing math, and moisture on_error handling (1 table, 13 computed columns; B-tree indexes, UDFs)
- [Harbor Radio Signals](https://www.pixeltable.com/recipes/harbor-signals.md): Harbor radio signal media pipeline: audio normalize/fade, vision box overlays, and StringSplitter sentence views (1 table, 1 view, 13 computed columns; B-tree indexes, Views and iterators, Images, video and audio, UDFs)
- [Forge Heat Cycles](https://www.pixeltable.com/recipes/forge-heats.md): Forge heat-cycle registry API: B-tree indexes, chained risk UDFs, and parallel shop-floor writers (1 table, 4 computed columns, 8 HTTP routes; B-tree indexes, UDFs)
- [Climbing Route Topos](https://www.pixeltable.com/recipes/climbing-routes.md): Climbing-route topo registry API: photo uploads with thumbnails, grayscale copies, grade bands and index-backed crag lookups (1 table, 6 computed columns, 7 HTTP routes; B-tree indexes, Images, video and audio, UDFs, File uploads)
- [Warehouse Pick Lists](https://www.pixeltable.com/recipes/warehouse-picklists.md): Warehouse pick-list REST API: units, pick zones, waves and tote labels as incremental computed columns over Json order lines (1 table, 5 computed columns, 6 HTTP routes; B-tree indexes, UDFs)
- [Ferry Booking](https://www.pixeltable.com/recipes/ferry-bookings.md): Ferry booking REST API: fares and deck classes as incremental computed columns, served with FastAPI (2 tables, 3 computed columns, 9 HTTP routes; B-tree indexes, UDFs)
- [Pharmacy Refill](https://www.pixeltable.com/recipes/pharmacy-refills.md): Pharmacy refill queue API with HMAC-signed receipts keyed by a runtime secret and B-tree indexed lookups (2 tables, 3 computed columns, 6 HTTP routes; B-tree indexes, UDFs)
- [Mural Registry](https://www.pixeltable.com/recipes/mural-registry.md): Public-art mural registry API: wall photo uploads with thumbnails, grayscale copies and color tags (1 table, 5 computed columns, 5 HTTP routes; B-tree indexes, Images, video and audio, UDFs, File uploads)
- [Greenhouse Operations](https://www.pixeltable.com/recipes/greenhouse-bays.md): Greenhouse operations API: bays, climate readings and plantings, sized for Pixeltable Cloud in pixeltable.toml (3 tables, 3 computed columns, 7 HTTP routes; B-tree indexes, UDFs)
- [Vineyard Estate](https://www.pixeltable.com/recipes/vineyard-blocks.md): Vineyard estate API: blocks, vines, harvests and tastings as four related Pixeltable tables with yield UDFs (4 tables, 5 computed columns, 8 HTTP routes; UDFs)
- [Trail Permit](https://www.pixeltable.com/recipes/trail-permits.md): Backcountry trail permit API with check-ins, permit bands and a full Pixeltable Cloud lifecycle (3 tables, 6 computed columns, 6 HTTP routes; UDFs)
- [Marina Berth Booking](https://www.pixeltable.com/recipes/marina-berths.md): Marina berth booking API: string primary keys, binary columns, berth fees and stay bands as computed columns (3 tables, 4 computed columns, 9 HTTP routes; UDFs)
- [Museum Loans](https://www.pixeltable.com/recipes/museum-loans.md): Museum object loan tracker API with overdue flags and urgency bands, explorable from the pxt CLI and dashboard (2 tables, 5 computed columns, 5 HTTP routes; UDFs)
- [Invoice Audit](https://www.pixeltable.com/recipes/invoice-audit.md): Invoice line-item audit API: a chain of computed columns from subtotal to tax, total and risk band (2 tables, 10 computed columns, 5 HTTP routes; UDFs)
- [Lab Accession](https://www.pixeltable.com/recipes/lab-accession.md): Lab sample accession queue API: three related tables, parallel writers and racing claims (3 tables, 3 computed columns, 7 HTTP routes; B-tree indexes, UDFs)
- [Fleet Telemetry](https://www.pixeltable.com/recipes/fleet-telemetry.md): Fleet telemetry API with B-tree indexed lookups and a chained severity/alert UDF pipeline (1 table, 3 computed columns, 7 HTTP routes; B-tree indexes, UDFs)
- [Webhook Vault](https://www.pixeltable.com/recipes/webhook-vault.md): Webhook registry API that HMAC-signs payloads with a secret from the environment, as computed columns (1 table, 3 computed columns, 4 HTTP routes; UDFs)
- [Travel Scrapbook](https://www.pixeltable.com/recipes/travel-scrapbook.md): Travel photo scrapbook API: image uploads, thumbnails and place tags as computed columns (1 table, 4 computed columns, 4 HTTP routes; Images, video and audio, UDFs, File uploads)
- [Plant Care](https://www.pixeltable.com/recipes/plant-care.md): Houseplant care API that turns soil moisture and watering history into care advice via computed columns (1 table, 3 computed columns, 4 HTTP routes; UDFs)
- [Coffee Journal](https://www.pixeltable.com/recipes/coffee-journal.md): Coffee tasting journal API: roast labels and tasting summaries as computed columns (1 table, 3 computed columns, 4 HTTP routes; UDFs)
- [Habit Tracker](https://www.pixeltable.com/recipes/habit-tracker.md): Habit tracker API with streak labels as computed columns, deployable to Pixeltable Cloud (1 table, 3 computed columns, 4 HTTP routes; UDFs)
- [Recipe Box](https://www.pixeltable.com/recipes/recipe-box.md): Recipe box API with ingredient counts and quick-meal search as computed columns and queries (1 table, 3 computed columns, 4 HTTP routes; UDFs)
- [Bookmark Shelf](https://www.pixeltable.com/recipes/bookmark-shelf.md): Bookmark manager API that derives domains and tag counts as computed columns, served with FastAPI (1 table, 4 computed columns, 5 HTTP routes; UDFs)
- [Sticky Notes](https://www.pixeltable.com/recipes/sticky-notes.md): Sticky-notes REST API where titles and previews are computed columns, served with FastAPI (1 table, 2 computed columns, 5 HTTP routes; UDFs)

For a free hosted database with no account, run `pxt new` (https://www.pixeltable.com/new).
