Agent skill

Airtable Register

by mehta-lab in mehta-lab/VisCy

Register zarr positions into the Computational Imaging Database on Airtable, write channelsmetadata/experimentmetadata to zarr .zattrs, or bulk-update Airtable records via MCP.

BSD-3-ClauseAuto-check passedData & Analytics

Install Airtable Register

skills CLI
$ npx skills add mehta-lab/VisCy --skill airtable-register -a claude-code

Project install by default; add -g for ~/.claude/skills/.

GitHub CLI
$ gh skill install mehta-lab/VisCy airtable-register --agent claude-code

Project scope by default; add --scope user for a personal install. Needs GitHub CLI 2.90.0 or later (public preview).

Manual copy
$ git clone --depth 1 https://github.com/mehta-lab/VisCy.git skills-src && mkdir -p .claude/skills && cp -r skills-src/.claude/skills/airtable-register .claude/skills/airtable-register && rm -rf skills-src

Use ~/.claude/skills/ instead of .claude/skills for a personal install. The folder must contain SKILL.md.

Claude Code skills documentation · loads skills from .claude/skills/

Facts

Skill name
airtable-register
GitHub stars
104
Token cost
~1.9k tokens
SKILL.md length
563 words
Files
1
Skills in repo
4
Repo updated
First seen
Licence
BSD-3-Clause

At a glance

Register zarr positions into the Computational Imaging Database on Airtable, write channelsmetadata/experimentmetadata to zarr .zattrs, or bulk-update Airtable records via MCP.

  • Works in 3 steps: Register (zarr -> Airtable) → Write (Airtable -> zarr) → Bulk Update (via Airtable MCP)
  • The user asks to register a dataset
  • SKILL.md covers Airtable Configuration, Operations, Datasets Table Fields and Marker Registry, plus 3 more sections
  • Calls uv; needs AIRTABLE_API_KEY

What it does

Airtable Register is an agent skill from mehta-lab/VisCy. Register zarr positions into the Computational Imaging Database on Airtable, write channelsmetadata/experimentmetadata to zarr .zattrs, or bulk-update Airtable records via MCP. Use when the user asks to "register a dataset", "register zarr positions", "update airtable from zarr", "write metadata to zarr", "run register on", "sync airtable", "populate channel markers", "update airtable records", "backfill fields", or "fill in missing fields". Also use for Marker Registry questions.

Its SKILL.md is about 1.9k tokens, which your agent loads only when the skill is triggered. It is a single SKILL.md file with no bundled scripts.

It sits in Data & Analytics, covering DataFrames. It works with Airtable, Zarr and Model Context Protocol. The repository describes itself as: computer vision models for single-cell phenotyping. The licence is BSD-3-Clause.

When your agent uses it

  • The user asks to register a dataset
  • Register zarr positions
  • Update airtable from zarr
  • Write metadata to zarr

Example prompts

  • “register a dataset”
  • “register zarr positions”
  • “update airtable from zarr”
  • “/airtable-register”

Requirements

  • A credential in AIRTABLE_API_KEY

Workflow steps

3 steps, taken from the step headings in SKILL.md.

  1. Register (zarr -> Airtable)
  2. Write (Airtable -> zarr)
  3. Bulk Update (via Airtable MCP)

What it can do on your machine

Read from SKILL.md and the folder at commit 4b62365. It shows what the files ask for, not the result of running them.

  • Tool permissions

    Pre-approves nothing: there is no allowed-tools line, so your agent's usual permission prompts apply.

    From allowed-tools in the SKILL.md frontmatter.

  • Runs code

    Shell commands in SKILL.md call:

    • uv

    From the folder's file list and the shell code blocks in SKILL.md.

  • Network

    No URLs in SKILL.md. Its commands use uv, which can reach the network depending on how they are called.

    From URLs in SKILL.md, links to its own repository left out.

  • Credentials

    Names these keys or tokens, usually read from environment variables:

    • AIRTABLE_API_KEY

    From names ending in _API_KEY, _TOKEN, _SECRET, _KEY or _PASSWORD in SKILL.md.

Context cost

Airtable Register loads about 1.9k tokens when it runs. Until then it costs about 126 tokens; SKILL.md has 563 words of instructions outside code blocks.

Always · name and description, kept in context so the agent knows when to use it
~126
When it runs · the whole SKILL.md, loaded when a task matches
~1.9k

Estimates: characters ÷ 4, the usual rule of thumb; real counts depend on the model's tokenizer. Scripts and assets cost tokens only if the agent reads them.

Safety

Auto-check passed

The automated check found no risky patterns in SKILL.md.

Automated static check — not a guarantee. Review scripts before installing. It scans the text of SKILL.md for risky patterns (piping downloads into a shell, reading credential files, hidden Unicode, destructive commands); files beside SKILL.md are not scanned.

SKILL.md

The full file from mehta-lab/VisCy at commit 4b62365, republished under its BSD-3-Clause licence (© mehta-lab). 563 words, ~1,923 tokens.

Download SKILL.mdSave it as .claude/skills/airtable-register/SKILL.md (or your agent's skills folder).
name
airtable-register
description
Register zarr positions into the Computational Imaging Database on Airtable, write channels_metadata/experiment_metadata to zarr .zattrs, or bulk-update Airtable records via MCP. Use when the user asks to "register a dataset", "register zarr positions", "update airtable from zarr", "write metadata to zarr", "run register on", "sync airtable", "populate channel markers", "update airtable records", "backfill fields", or "fill in missing fields". Also use for Marker Registry questions.
version
3.0.0
author
ai-x-imaging
tags
Airtable, OME-Zarr, Metadata, Registration, DynaCLR, VisCy

Airtable Registration & Update Skill

Manages bidirectional metadata sync between OME-Zarr datasets and the Computational Imaging Database on Airtable, and supports bulk field updates via MCP.

Airtable Configuration

  • Base ID: app8vqaoWyOwa0sB5 (Computational Imaging Database)
  • Datasets table ID: tblaFzrDMlVZHPZIj
  • Collections table ID: tblu0Rbj9OnLl7vJf
  • Models table ID: tblVZhRA48tDMWj8U
  • Marker Registry table: tblmP8l2GmpCeERyD
  • Script: applications/airtable/scripts/write_experiment_metadata.py
  • Core logic: applications/airtable/src/airtable_utils/registration.py
  • Schemas: applications/airtable/src/airtable_utils/schemas.py
  • Database interface: applications/airtable/src/airtable_utils/database.py
  • Channel parsing: packages/viscy-data/src/viscy_data/channel_utils.py
  • MAX_CHANNELS = 8 (defined in schemas.py)
  • AIRTABLE_API_KEY and AIRTABLE_BASE_ID must be set in environment

Operations

1. Register (zarr -> Airtable)

Reads zarr metadata and writes per-FOV records to Airtable.

Fields written by register:

  • data_path — full path to zarr position
  • channel_{i}_name — zarr channel names (up to 8)
  • channel_{i}_marker — protein marker, derived from Marker Registry
  • t_shape, c_shape, z_shape, y_shape, x_shape — array dimensions
  • pixel_size_xy_um, pixel_size_z_um — from zarr coordinate transforms

Marker derivation rules:

  • labelfree channels -> marker = channel name (e.g. "Phase3D", "BF", "DIC")
  • virtual_stain channels -> marker = channel name (e.g. "nuclei_prediction")
  • fluorescence channels -> substring-match aliases against channel name -> protein marker from registry (e.g. "TOMM20", "SEC61B")
Commands
bash
# Dry run first (always recommended)
uv run --package airtable-utils \
    applications/airtable/scripts/write_experiment_metadata.py \
    register --dry-run /path/to/dataset.zarr/*/*/*

# Register all positions
uv run --package airtable-utils \
    applications/airtable/scripts/write_experiment_metadata.py \
    register /path/to/dataset.zarr/*/*/*

# Single position
uv run --package airtable-utils \
    applications/airtable/scripts/write_experiment_metadata.py \
    register /path/to/dataset.zarr/A/1/000000

# Override dataset name (when zarr stem doesn't match Airtable)
uv run --package airtable-utils \
    applications/airtable/scripts/write_experiment_metadata.py \
    register --dataset my_dataset /path/to/dataset.zarr/*/*/*
Parquet Readiness Report

After registration, the CLI prints a Parquet Readiness report that flags any fields still needed before a flat parquet cell index can be built. Fields are split by source:

  • zarr fields (auto-filled by register): data_path, channel_N_name, channel_N_marker, pixel_size_xy_um, pixel_size_z_um
  • platemap fields (biologist fills in Airtable): tracks_path, perturbation, time_interval_min, hours_post_perturbation, cell_type

If any platemap fields are missing, the report shows what to fill in and how (Airtable UI or MCP bulk update).

2. Write (Airtable -> zarr)

Writes channels_metadata and experiment_metadata to zarr .zattrs.

bash
uv run --package airtable-utils \
    applications/airtable/scripts/write_experiment_metadata.py \
    write /path/to/dataset.zarr/*/*/*
channels_metadata schema
json
{
  "Phase3D": {
    "channel_type": "labelfree",
    "biological_annotation": {"marker": "Phase3D"}
  },
  "raw GFP EX488 EM525-45": {
    "channel_type": "fluorescence",
    "biological_annotation": {
      "marker": "TOMM20",
      "marker_type": "protein_tag",
      "fluorophore": null
    }
  }
}
experiment_metadata schema
json
{
  "perturbations": [
    {"name": "ZIKV", "type": "unknown", "hours_post": 48.0, "moi": 5.0}
  ],
  "time_sampling_minutes": 15.0
}
3. Bulk Update (via Airtable MCP)

For updating fields that don't come from zarr (e.g. tracks_path, organelle, manually-curated fields).

Process:

  1. Fetch target records with mcp__airtable__list_records using filterByFormula
  2. Compute new values (python/jq)
  3. Batch update with mcp__airtable__update_records (max 10 per call, send all batches in parallel)
  4. Verify with the same filter query (must return zero remaining records)

Pagination warning: mcp__airtable__list_records returns ~100 records max per call. If count equals ~100, re-query with tighter filters.

Show full SKILL.md (238 more words)Show less

Datasets Table Fields

FieldDescriptionWritten by register?
datasetExperiment nameon create
well_idWell path (e.g. B/2)on create
fovFOV identifieron create
data_pathPath to HCS OME-Zarr positionyes
tracks_pathPath to tracking zarrno (manual/MCP)
channel_0_name .. channel_7_nameZarr channel namesyes
channel_0_marker .. channel_7_markerProtein marker per channelyes
t_shape .. x_shapeArray dimensionsyes
pixel_size_xy_umPhysical XY pixel size (um)yes
pixel_size_z_umPhysical Z pixel size (um)yes
markerWell-level primary markertemplate copy
organelleTarget organelletemplate copy
perturbationPerturbation appliedtemplate copy
cell_typeCell type (e.g. A549)template copy
cell_stateCondition labeltemplate copy
time_interval_minMinutes between framestemplate copy
hours_post_perturbationHPI at imaging starttemplate copy
moiMultiplicity of infectiontemplate copy
fluorescence_modalityImaging modalitytemplate copy

Marker Registry

Table tblmP8l2GmpCeERyD — maps constructs to protein markers.

FieldTypeExample
marker-fluorophoretext (primary)TOMM20-GFP
channel_name_aliasestextGFP, FITC
markertextTOMM20

Matching is substring-based: "GFP" in "raw GFP EX488 EM525-45" -> match.

Flat Parquet Alignment

The register command writes all fields needed to build a flat parquet cell index:

  • channel_{i}_name -> parquet channel_name
  • channel_{i}_marker -> parquet marker
  • pixel_size_xy_um, pixel_size_z_um -> parquet pixel size columns
  • data_path -> parquet store_path

Dataset Directory Conventions

For organelle_dynamics datasets:

data_path:    /hpc/projects/intracellular_dashboard/organelle_dynamics/{EXP}/2-assemble/{EXP}.zarr
tracks_path:  /hpc/projects/intracellular_dashboard/organelle_dynamics/{EXP}/1-preprocess/label-free/3-track/{EXP}_cropped.zarr

Other families (organelle_box, viral-sensor) have non-standard structures — check filesystem.

Example Invocations

  • "register this dataset /path/to/dataset.zarr///*"
  • "write metadata to zarr for dataset X"
  • "update tracks_path for all organelle_dynamics datasets"
  • "fill in pixel_size_xy_um for all records where it's missing"
  • "set organelle = 'mitochondria' for all 2024_11_21 records"

© mehta-lab, BSD-3-Clause. Rendered from Markdown: HTML in the file is shown as text, images as links, and headings moved down two levels. Raw file

Files

Just SKILL.md in .claude/skills/airtable-register of mehta-lab/VisCy.

Open the folder on GitHubat commit 4b62365

Compare with similar skills

Airtable Register next to the 5 skills that share the most tags, products or categories with it. Stars are the repository's; “used in” counts other GitHub owners with a copy.

Airtable Register compared with similar skills
SkillStarsUsed inTokensAuto-checkLicenceRepo updated
Airtable Register this skillmehta-lab/VisCy104—~1.9kAutomated safety check: PassBSD-3-Clause
Retentioneering Product Analyticsretentioneering/retentioneering-tools925—~1.6kAutomated safety check: PassApache-2.0
Investigate Datawalkthru-earth/geocoding-playground153—~935Automated safety check: PassCC-BY-4.0
Downloading Batch Export FilesPostHog/posthog40k—~2.4kAutomated safety check: PassCustom licence
Setup Polarchmonitor/chmonitor299—~1.1kAutomated safety check: WarnGPL-3.0
Ray Data for ML PipelinesOrchestra-Research/AI-Research-SKILLs13k3 repos~1.8kAutomated safety check: PassMIT

Similar skills

  • Retentioneering Product Analytics

    retentioneering/retentioneering-tools

    Analyze event logs, clickstreams, user paths, product funnels, retention, behavioral segments, transition graphs, step matrices, sequence patterns, and customer journeys using Retentioneering.

    925 GitHub stars~1.6k tokensUpdated yesterday
    Data & AnalyticsAuto-check passed
  • Investigate Data

    walkthru-earth/geocoding-playground

    Investigates geocoder data quality issues by querying live S3 parquet files via MotherDuck MCP.

    153 GitHub stars~935 tokensUpdated 3 mo ago
    Data & AnalyticsAuto-check passed
  • Official

    Export PostHog events, persons, sessions, or the results of a HogQL query on demand and download the resulting files.

    40k GitHub stars~2.4k tokensUpdated today
    Data & AnalyticsAuto-check passed
  • Setup Polar

    chmonitor/chmonitor

    Interactive onboarding wizard to set up Polar payment integration from scratch.

    299 GitHub stars~1.1k tokensUpdated 3 days ago
    Data & AnalyticsAuto-check: warnings
  • Ray Data for ML Pipelines

    Orchestra-Research/AI-Research-SKILLs

    Uses Ray Data to read, transform and write large datasets across a cluster for ML training and batch inference, with streaming execution and optional GPU steps.

    13k GitHub starsUsed in 3 repos~1.8k tokens
    Data & AnalyticsAuto-check passed
  • Zarr Python

    davila7/claude-code-templates

    Chunked N-D arrays for cloud storage. An agent skill from davila7/claude-code-templates.

    32k GitHub starsUsed in 11 repos~5k tokens
    Backend & APIsAuto-check passed

More from mehta-lab/VisCy

  • Prepare Dataset

    mehta-lab/VisCy

    Prepare datasets for training on VAST storage (NFS - VAST rechunked zarr v3 pipeline).

    104 GitHub stars~1.1k tokensUpdated today
    Auto-check passed
  • Query Airtable MCP to fetch experiment metadata and generate a DynaCLR collection YAML for training

    104 GitHub stars~1.8k tokensUpdated today
    Auto-check passed
  • Hf Dynacell

    mehta-lab/VisCy

    Develop, deploy, and maintain the DynaCell virtual-staining HuggingFace demo hosted at biohub/dynacell (ZeroGPU).

    104 GitHub stars~1.1k tokensUpdated today
    Auto-check passed

Questions about Airtable Register

What does Airtable Register do?

Register zarr positions into the Computational Imaging Database on Airtable, write channelsmetadata/experimentmetadata to zarr .zattrs, or bulk-update Airtable records via MCP. Airtable Register is an agent skill from mehta-lab/VisCy.zattrs, or bulk-update Airtable records via MCP.

When should I use Airtable Register?

Airtable Register fits situations like: the user asks to register a dataset; register zarr positions; update airtable from zarr; write metadata to zarr.

How do I install Airtable Register in Claude Code?

Run `npx skills add mehta-lab/VisCy --skill airtable-register -a claude-code`. Or copy the skill folder (.claude/skills/airtable-register in mehta-lab/VisCy) into .claude/skills/airtable-register in your project. Claude Code loads it when a task matches its description.

How do I install Airtable Register in Codex?

Run `npx skills add mehta-lab/VisCy --skill airtable-register -a codex`. Or copy the skill folder (.claude/skills/airtable-register in mehta-lab/VisCy) into .agents/skills/airtable-register in your project. Codex loads it when a task matches its description.

Can I use Airtable Register in Cursor, Gemini CLI or GitHub Copilot?

Cursor, Gemini CLI, GitHub Copilot and OpenCode also load SKILL.md folders. With the skills CLI, run `npx skills add mehta-lab/VisCy --skill airtable-register -a cursor` (or -a gemini-cli, github-copilot or opencode for the others). To copy it by hand, put the folder in .cursor/skills/airtable-register, .gemini/skills/airtable-register, .github/skills/airtable-register and .opencode/skills/airtable-register in your project.

What does Airtable Register need to run?

Going by SKILL.md and its folder, Airtable Register needs the command-line tools its instructions call (uv) and credentials named AIRTABLE_API_KEY. Our summary lists: A credential in AIRTABLE_API_KEY.

Does Airtable Register access the network?

SKILL.md contains no URLs. Its commands use uv, which can reach the network depending on how they are called. This is read from the text; nothing was executed.

Is Airtable Register safe to install?

Our automated static check of SKILL.md found no risky patterns, such as piping downloads into a shell, reading credential files or hidden Unicode. It is not a guarantee. Review the folder before installing.

What licence does Airtable Register use?

Airtable Register is published under the BSD-3-Clause licence (the repository's licence). It allows redistribution, so the full SKILL.md is shown on this page.

How many tokens does Airtable Register use?

About 1.9k tokens (SKILL.md is roughly 7.7k characters). Agents keep only the skill's name and description in context until a task matches; then they load SKILL.md in full.

What are the alternatives to Airtable Register?

Skills that share tags, products or a category with Airtable Register: Retentioneering Product Analytics (retentioneering/retentioneering-tools, 925 stars), Investigate Data (walkthru-earth/geocoding-playground, 153 stars), Downloading Batch Export Files (PostHog/posthog, 40k stars) and Setup Polar (chmonitor/chmonitor, 299 stars). The comparison table on this page puts their stars, adoption, token cost, safety result and licence side by side.

Who maintains Airtable Register?

mehta-lab (a GitHub organization) maintains it in mehta-lab/VisCy, which has 104 GitHub stars. The repository holds 4 skills in this directory. The repository was last updated on October 9, 2026.

Source: mehta-lab/VisCy on GitHub. Facts on this page come from the repository at the commit we read; the author's words are quoted as theirs.