Skip to content

Example apps built with Pixeltable

29 apps, each one app.py: the tables it declares, the columns that run on insert, and the routes that serve them, drawn from the file itself. Grouped with notebooks and how-tos by task on /examples.

  • runs on insert
  • stored
  • index
  • route

29 apps shown

Starter kits

Maintained in pixeltable-starter-kit

  • Chat agent

    A knowledge base, conversation memory and an /ask route over Claude, with sentence embeddings for retrieval.

    sentencesview, string_splitter
    1. embedding index on text
    agent6 stored
    1. memory_context = recall_memory(prompt)
    2. knowledge_context = search_knowledge(prompt)
    3. context = assemble_context(prompt, memory_context, knowledge_context)
    4. +2 more computed

    +2 more tables: knowledge, conversations

    serves

    1. POST/api/knowledge
    2. POST/api/conversations
    3. +6 more routes
    3 tables · 1 view · 5 computed · 8 routes
  • Video search

    Video frames extracted at one per second and indexed with CLIP, searchable by text or by image.

    framesview, frame_iterator
    1. thumbnail = pxt_image.b64_encode(pxt_image.thumbnail(frame, size=(320, 320)))
    2. embedding index on frame
    images5 stored
    1. thumbnail = pxt_image.b64_encode(pxt_image.thumbnail(image, size=(128, 128)))
    2. width = image.width
    3. height = image.height
    4. +1 more computed

    +1 more table: videos

    serves

    1. POST/api/ingest
    2. POST/api/ingest/image
    3. +4 more routes
    2 tables · 1 view · 5 computed · 6 routes

More apps

From awesome-pixeltable-apps; add yours with a pull request

  • Research Agent Memory

    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

    memories7 stored
    1. embedding index on content
    2. +1 more index
    turns3 stored
    1. recalled = recall_memories(user_id, message, 4)
    2. memory_text = memory_block(recalled)
    3. response = openai.chat_completions(agent_messages(user_id, message, memory_text), model=CHAT_MODEL...
    4. +4 more computed

    +1 more table: sources

    3 tables · 8 computed · Python only
  • Archery Range

    Migrate archery-range scoring sessions from legacy JSON into Pixeltable, score with date-aware computed columns, and run as an incremental scheduled pipeline

    sessions9 stored
    1. session_year = pxtd.year(session_date)
    2. session_month = pxtd.month(session_date)
    3. session_day = pxtd.day(session_date)
    4. +10 more computed
    5. B-tree index on archer
    6. +4 more indexes
    1 table · 13 computed · Python only
  • Apiary Advisor

    RAG + tool-calling beekeeping advisor: custom embedding index, table-as-UDF agent pipeline, expr_udf mite math

    advisor1 stored
    1. regional_question = with_region(question)
    2. hits = search_guides(question, 3)
    3. context = format_context(hits)
    4. +1 more computed
    questions1 stored
    1. hits = search_guides(question, 3)
    2. context = format_context(hits)
    3. response = openai.chat_completions(advisor_messages(question, context), model='gpt-4o-mini', model...
    4. +3 more computed

    +3 more tables: guides, guide_chunks, inspections

    4 tables · 1 view · 13 computed · Python only
  • Orchard Harvest Crates

    Batch ETL for orchard harvest crates: CSV import/export, packing math, and moisture on_error handling

    crates9 stored
    1. volume_cm3 = length_cm * width_cm * height_cm
    2. abs_weight = pxtm.abs(weight_kg)
    3. weight_ceil = pxtm.ceil(weight_kg)
    4. +10 more computed
    5. B-tree index on orchard
    6. +2 more indexes
    1 table · 13 computed · Python only
  • Harbor Radio Signals

    Harbor radio signal media pipeline: audio normalize/fade, vision box overlays, and StringSplitter sentence views

    signals11 stored
    1. meta = pxtf.audio.get_metadata(clip)
    2. normalized = pxtf.audio.normalize(clip)
    3. faded_in = pxtf.audio.fade_in(normalized, duration=0.25)
    4. +8 more computed
    5. B-tree index on harbor
    6. +2 more indexes
    sentencesview, string_splitter
    1. length = pxtf.string.len(text)
    2. upper = pxtf.string.upper(text)
    1 table · 1 view · 13 computed · Python only
  • Forge Heat Cycles

    Forge heat-cycle registry API: B-tree indexes, chained risk UDFs, and parallel shop-floor writers

    heats9 stored
    1. band = heat_band(peak_c)
    2. risk = risk_score(peak_c, hold_min, quench)
    3. tag = heat_tag(band, risk, alloy)
    4. +1 more computed
    5. B-tree index on forge_id
    6. +3 more indexes

    serves

    1. POST/heats
    2. POST/heats/status
    3. +6 more routes
    1 table · 4 computed · 8 routes
  • Climbing Route Topos

    Climbing-route topo registry API: photo uploads with thumbnails, grayscale copies, grade bands and index-backed crag lookups

    routes8 stored
    1. thumb = topo.resize((96, 128))
    2. gray = topo.convert('L')
    3. aspect = aspect_band(topo)
    4. +3 more computed
    5. B-tree index on crag
    6. +3 more indexes

    serves

    1. POST/routes
    2. POST/analyze
    3. +5 more routes
    1 table · 6 computed · 7 routes
  • Warehouse Pick Lists

    Warehouse pick-list REST API: units, pick zones, waves and tote labels as incremental computed columns over Json order lines

    orders6 stored
    1. units = total_units(lines)
    2. zone_list = zones(lines)
    3. est_minutes = pick_minutes(units, zone_list, rush)
    4. +2 more computed
    5. B-tree index on status
    6. +2 more indexes

    serves

    1. POST/orders
    2. POST/orders/update
    3. +4 more routes
    1 table · 5 computed · 6 routes
  • Ferry Booking

    Ferry booking REST API: fares and deck classes as incremental computed columns, served with FastAPI

    sailings5 stored
    1. B-tree index on route
    bookings7 stored
    1. fare = fare_cents(party_size, vehicle_len_m, extras)
    2. deck_class = deck(vehicle_len_m)
    3. extras_order = extras_keys(extras)
    4. B-tree index on sailing_id
    5. +1 more index

    serves

    1. POST/bookings
    2. POST/bookings/update
    3. +7 more routes
    2 tables · 3 computed · 9 routes
  • Pharmacy Refill

    Pharmacy refill queue API with HMAC-signed receipts keyed by a runtime secret and B-tree indexed lookups

    prescriptions5 stored
    1. state = refill_state(refills_left)
    2. B-tree index on patient_ref
    3. +1 more index
    refills6 stored
    1. label = status_label(status, channel)
    2. receipt_sig = receipt_signature(rx_number, requested_at, status)
    3. B-tree index on rx_number
    4. +1 more index

    serves

    1. POST/prescriptions
    2. POST/refills
    3. +4 more routes
    2 tables · 3 computed · 6 routes
  • Mural Registry

    Public-art mural registry API: wall photo uploads with thumbnails, grayscale copies and color tags

    murals5 stored
    1. thumb = wall_photo.resize((96, 64))
    2. gray = wall_photo.convert('L')
    3. aspect = aspect_band(wall_photo)
    4. +2 more computed
    5. B-tree index on neighborhood

    serves

    1. POST/murals
    2. POST/analyze
    3. +3 more routes
    1 table · 5 computed · 5 routes
  • Greenhouse Operations

    Greenhouse operations API: bays, climate readings and plantings, sized for Pixeltable Cloud in pixeltable.toml

    bays4 stored
    1. label = bay_label(zone, bay_id, crop)
    2. B-tree index on zone
    3. +2 more indexes
    readings5 stored
    1. band = climate_band(temp_c, humidity_pct)
    2. vpd = vpd_kpa(temp_c, humidity_pct)
    3. B-tree index on bay_id

    +1 more table: plantings

    serves

    1. POST/bays
    2. POST/bays/status
    3. +5 more routes
    3 tables · 3 computed · 7 routes
  • Vineyard Estate

    Vineyard estate API: blocks, vines, harvests and tastings as four related Pixeltable tables with yield UDFs

    vines5 stored
    1. age = vine_age(planted_year)
    harvests6 stored
    1. tpa = yield_per_acre(tons, acres)
    2. band = yield_band(tons, acres)
    3. ripe = ripeness(brix)

    +2 more tables: blocks, tastings

    serves

    1. POST/blocks
    2. POST/vines
    3. +6 more routes
    4 tables · 5 computed · 8 routes
  • Trail Permit

    Backcountry trail permit API with check-ins, permit bands and a full Pixeltable Cloud lifecycle

    trails6 stored
    1. region_upper = pxtf.string.upper(region)
    2. name_lower = pxtf.string.lower(name)
    permits7 stored
    1. band = permit_band(days, party_size)
    2. trail_upper = pxtf.string.upper(trail_code)

    +1 more table: checkins

    serves

    1. POST/trails
    2. POST/permits
    3. +4 more routes
    3 tables · 6 computed · 6 routes
  • Marina Berth Booking

    Marina berth booking API: string primary keys, binary columns, berth fees and stay bands as computed columns

    slips4 stored
    1. label = slip_label(dock, slip_id, length_m)
    bookings5 stored
    1. fee = berth_fee(loa_m, nights)
    2. band = stay_band(nights)

    +1 more table: vessels

    serves

    1. POST/slips
    2. POST/vessels
    3. +7 more routes
    3 tables · 4 computed · 9 routes
  • Museum Loans

    Museum object loan tracker API with overdue flags and urgency bands, explorable from the pxt CLI and dashboard

    objects6 stored
    1. accession_upper = pxtf.string.upper(accession)
    2. title_lower = pxtf.string.lower(title)
    loans8 stored
    1. label = loan_label(accession, borrower, venue)
    2. overdue = is_overdue(status, days_out)
    3. urgency_band = urgency(status, days_out)

    serves

    1. POST/objects
    2. POST/loans
    3. +3 more routes
    2 tables · 5 computed · 5 routes
  • Invoice Audit

    Invoice line-item audit API: a chain of computed columns from subtotal to tax, total and risk band

    vendors5 stored
    1. code_upper = pxtf.string.upper(code)
    2. tier_upper = pxtf.string.upper(tier)
    line_items10 stored
    1. ref = invoice_ref(vendor_code, sku)
    2. subtotal = line_subtotal(qty, unit_price)
    3. net = apply_discount(subtotal, discount_pct)
    4. +5 more computed

    serves

    1. POST/lines
    2. POST/lines/adjust
    3. +3 more routes
    2 tables · 10 computed · 5 routes
  • Lab Accession

    Lab sample accession queue API: three related tables, parallel writers and racing claims

    stations3 stored
    1. label = station_label(name, capacity)
    assignments7 stored
    1. urgency = urgency_band(priority, delayed_min)
    2. B-tree index on station_id
    3. +1 more index

    +1 more table: samples

    serves

    1. POST/stations
    2. POST/samples
    3. +5 more routes
    3 tables · 3 computed · 7 routes
  • Fleet Telemetry

    Fleet telemetry API with B-tree indexed lookups and a chained severity/alert UDF pipeline

    readings8 stored
    1. severity = severity_score(speed_kph, engine_temp_c, fuel_pct)
    2. alert = alert_label(severity)
    3. tag = vehicle_tag(fleet, vehicle_id)
    4. B-tree index on vehicle_id
    5. +3 more indexes

    serves

    1. POST/readings
    2. POST/readings/correct
    3. +5 more routes
    1 table · 3 computed · 7 routes
  • Webhook Vault

    Webhook registry API that HMAC-signs payloads with a secret from the environment, as computed columns

    webhooks5 stored
    1. host = target_host(url)
    2. digest = digest_payload(payload)
    3. signature = sign_payload(event, payload)

    serves

    1. POST/webhooks
    2. POST/sign
    3. +2 more routes
    1 table · 3 computed · 4 routes
  • Travel Scrapbook

    Travel photo scrapbook API: image uploads, thumbnails and place tags as computed columns

    scrapbook6 stored
    1. thumb = photo.resize((64, 48))
    2. place = trip_tag(city, country)
    3. shape = orientation(photo)
    4. +1 more computed

    serves

    1. POST/photos
    2. POST/photos/caption
    3. +2 more routes
    1 table · 4 computed · 4 routes
  • Plant Care

    Houseplant care API that turns soil moisture and watering history into care advice via computed columns

    plants6 stored
    1. water_label = water_advice(moisture, days_since_water)
    2. species_upper = pxtf.string.upper(species)
    3. notes_blurb = care_blurb(species, location)

    serves

    1. POST/plants
    2. POST/plants/update
    3. +2 more routes
    1 table · 3 computed · 4 routes
  • Coffee Journal

    Coffee tasting journal API: roast labels and tasting summaries as computed columns

    cups6 stored
    1. roast = roast_label(roast_level)
    2. bean_upper = pxtf.string.upper(bean)
    3. notes_blurb = brew_blurb(notes)

    serves

    1. POST/cups
    2. POST/cups/update
    3. +2 more routes
    1 table · 3 computed · 4 routes
  • Habit Tracker

    Habit tracker API with streak labels as computed columns, deployable to Pixeltable Cloud

    habits5 stored
    1. label = streak_label(streak_days)
    2. name_upper = pxtf.string.upper(name)
    3. name_blurb = habit_blurb(name, category)

    serves

    1. POST/habits
    2. POST/habits/update
    3. +2 more routes
    1 table · 3 computed · 4 routes
  • Recipe Box

    Recipe box API with ingredient counts and quick-meal search as computed columns and queries

    recipes5 stored
    1. n_ingredients = ingredient_count(ingredients)
    2. title_upper = pxtf.string.upper(title)
    3. title_blurb = teaser(title, minutes)

    serves

    1. POST/recipes
    2. POST/recipes/update
    3. +2 more routes
    1 table · 3 computed · 4 routes
  • Bookmark Shelf

    Bookmark manager API that derives domains and tag counts as computed columns, served with FastAPI

    bookmarks5 stored
    1. domain = extract_domain(url)
    2. title_upper = pxtf.string.upper(title)
    3. n_tags = tag_count(tags)
    4. +1 more computed

    serves

    1. POST/bookmarks
    2. POST/bookmarks/update
    3. +3 more routes
    1 table · 4 computed · 5 routes
  • Sticky Notes

    Sticky-notes REST API where titles and previews are computed columns, served with FastAPI

    notes4 stored
    1. title_upper = pxtf.string.upper(title)
    2. blurb = blurb(body)

    serves

    1. POST/notes
    2. POST/notes/update
    3. +3 more routes
    1 table · 2 computed · 5 routes