validate-app SKILL.md skillA

validate-app from kyle-chalmers/streamsnow is an agent skill: a SKILL.md folder an AI agent loads when a task calls for it.

Install it, pinned
mdr add kyle-chalmers/streamsnow/validate-app@git:20261007.d42794c

Pins git:20261007.d42794c in mdr.lock. Pin the fingerprint instead.

Audit grade
A, 17 of 17 checks passed
Kind
SKILL.md skill
Repository
kyle-chalmers/streamsnow
Path
skills/validate-app/SKILL.md
Versions recorded
7
Latest version
git:20261007.d42794c, committed Oct 7, 2026
First version recorded
Sep 12, 2026
Size
6,620 bytes
Repository stars
13
License
MIT

The pass/fail check that must be clean before an app ships. Runs `streamsnow validate-app <slug>` (required-files, manifest, artifacts, naming, schema-refs, app-security, bind-predicates, sql-tokens, session-fallback, page-imports, caching, path-leaks, the §11 requirements contract, the offline sql-review check of the app's sql_review/ files, whose coverage severity follows sql_review.coverage in config, and placeholders) and explains how to fix anything that fails. Use when the user says…

Collected from public GitHub. Every version is saved exactly as it was and never changes. Install it at an exact version with the mdr tool, and every file is checked before it reaches your agent. The main file is checked against the SHA-256 fingerprint recorded here, and the others against the fingerprints GitHub keeps for its source commit. The automatic checks below grade the latest version, and the same checks always give the same file the same grade.

What the file says

# /validate-app

> **Repo overlay:** if `.streamsnow/overlays/validate-app.md` exists in this repo, read it first: committed, repo-specific additions/overrides ([_shared/overlays.md](../_shared/overlays.md)). Outside Claude Code, also read [_shared/other-agents.md](../_shared/other-agents.md).

Run the pass/fail gate on one app and report exactly what fails and how to fix it. `streamsnow
validate-app <slug>` is the single source of truth: offline (no Snowflake, no network), deterministic,
and what CI runs per app. CI also runs `dependency-vulns` and `tombstones`; pre-commit runs a subset.

## What it covers

Names as the gate prints them. How to fix each: [fixing-checks.md](fixing-checks.md).

- **required-files, manifest, artifacts, naming:** the runtime's files exist, `snowflake.yml` is
  valid for that runtime, its `artifacts:` list matches disk, and the slug is lowercase-hyphenated.
- **schema-refs:** no reference into a `governance.schema_deny` schema (exact `read_exceptions` aside). Names outside `governance.sources` and app data, and two-part `SCHEMA.OBJECT` names, are warnings under `governance.boundary: warn` and failures under `enforce`.
…

Read the whole file at its exact version.

How to install

The exact contents, by fingerprint
mdr add kyle-chalmers/streamsnow/validate-app@sha256:e909ea5448f4033e

The line at the top of this page pins the label git:20261007.d42794c, which is what most people want. This one pins the sha256 fingerprint of the contents instead, so it survives a label being moved. Either way the exact version is written to mdr.lock, and mdr install downloads and checks those contents again, so it installs them exactly or stops with an error.

Badge

mdr badge

[![mdr](https://markdownregistry.com/badge/art_gnjt56bmdaxdoj6o.svg)](https://markdownregistry.com/a/art_gnjt56bmdaxdoj6o)

2 badge image fetches in 30 days. What the badge shows.

Versions

The registry has recorded 7 versions of this file, between Sep 12, 2026 and Oct 7, 2026, about one every 4 days.

versioncommittedcommitsizeaudit
git:20261007.d42794c latest2026-10-07 d42794c 6,620 BA view · diff
git:20261007.b8029602026-10-07 b802960 6,262 BA view · diff
git:20261005.7edb4b72026-10-05 7edb4b7 6,125 BA view · diff
git:20261005.672f2f42026-10-05 672f2f4 5,341 BA view · diff
git:20261005.7db0ab82026-10-05 7db0ab8 5,319 BA view · diff
git:20260927.50611392026-09-27 5061139 5,328 BA view · diff
git:20260912.786b8202026-09-12 786b820 5,242 BA view

Audit of the latest version

A  17 of 17 checks passed. Fixed automatic checks with no AI involved, so the same checks give the same answer every run.
  • pass: Frontmatter block present
  • pass: Frontmatter declares a name
  • pass: Frontmatter declares a description
  • pass: Size between 200 bytes and 200 KB (6620 bytes)
  • pass: No zero-width or bidi control characters
  • pass: No instruction hidden inside an HTML comment
  • pass: No link to an exfiltration or paste host
  • pass: No credential-shaped string
  • pass: No instruction to send local credentials anywhere
  • pass: No text hidden with inline styles
  • pass: No prompt-injection phrasing
  • pass: No curl or wget piped into a shell
  • pass: No recursive delete of root, home or parent
  • pass: No instruction to read or print local credentials
  • pass: No base64 blob over 200 characters
  • pass: No link to a raw IP address
  • pass: No script tag

Source

GitHub

kyle-chalmers/streamsnow · 13 stars · license MIT · pushed 2026-10-19 · branch main

API

GET https://markdownregistry.com/api/v1/artifacts/art_gnjt56bmdaxdoj6o
GET https://markdownregistry.com/api/v1/resolve?ref=kyle-chalmers/streamsnow/validate-app
GET https://markdownregistry.com/api/v1/blob/e909ea5448f4033ed3430e0b702ff1b6a8ff5ac6a00c6acbcedd37d6d7521585

Your AI assistant does the legwork. You hear about the deals worth your word. Hand yours the standing instructions at modelranch.com and it joins the network that reads files like this one.

Guides: the SKILL.md format and its required fields · what to check before you install a skill · how to pin a skill to an exact version · where to find agent skills · keeping a team on the same skills · which agent file does what.

More from kyle-chalmers/streamsnow

CLAUDE.md@.claude CLAUDE.md file
kyle-chalmers/streamsnow · .claude/CLAUDE.md
git:20261019.5909ffc · audit A · 13 stars
release SKILL.md skill
kyle-chalmers/streamsnow · .claude/skills/release/SKILL.md · Maintainer-only release of StreamSnow, driven by scripts/release.py. One prompt ("cut the release", /release, /release…
git:20261011.2b4dacb · audit A · 13 stars
build-app SKILL.md skill
kyle-chalmers/streamsnow · skills/build-app/SKILL.md · The front door for building a Streamlit-in-Snowflake app from idea to opened PR, or resuming one mid-build…
git:20261019.b21ca9b · audit A · 13 stars
migrate-app SKILL.md skill
kyle-chalmers/streamsnow · skills/migrate-app/SKILL.md · Port an external Streamlit app into the repo in two reviewable steps — lift-and-shift into apps/<slug>/, then conform…
git:20261007.9645ba1 · audit A · 13 stars
onboard SKILL.md skill
kyle-chalmers/streamsnow · skills/onboard/SKILL.md · Get this machine, this repo and its Snowflake account ready for StreamSnow. Detects what is already done and does only…
git:20261007.d42794c · audit A · 13 stars
preview-app SKILL.md skill
kyle-chalmers/streamsnow · skills/preview-app/SKILL.md · Run an app locally against live Snowflake so the user can see it in the browser, wiring up secrets.toml first if…
git:20261019.17bf404 · audit A · 13 stars
review-app SKILL.md skill
kyle-chalmers/streamsnow · skills/review-app/SKILL.md · Review an app the way a senior reviewer would — parallel reviewers across SQL, data, UI, runtime, and docs — then…
git:20261007.b802960 · audit A · 13 stars
ship-app SKILL.md skill
kyle-chalmers/streamsnow · skills/ship-app/SKILL.md · Stage, commit, push, and open a PR for one app, gated on a passing validation, then watch CI to a terminal state. Use…
git:20261009.5ad4b9d · audit A · 13 stars
sql-review SKILL.md skill
kyle-chalmers/streamsnow · skills/sql-review/SKILL.md · Prove an app's numbers against live Snowflake and leave a record a person signs. Builds or repairs the app's…
git:20261008.5bc8bb2 · audit A · 13 stars
AGENTS.md@tests/fixtures/fleet/apps/acme-collections-overview AGENTS.md file
kyle-chalmers/streamsnow · tests/fixtures/fleet/apps/acme-collections-overview/AGENTS.md
git:20260927.5061139 · audit A · 13 stars
AGENTS.md@tests/fixtures/fleet/apps/acme-finance-admin AGENTS.md file
kyle-chalmers/streamsnow · tests/fixtures/fleet/apps/acme-finance-admin/AGENTS.md
git:20260927.5061139 · audit A · 13 stars
AGENTS.md@tests/fixtures/fleet/apps/acme-outreach-ops AGENTS.md file
kyle-chalmers/streamsnow · tests/fixtures/fleet/apps/acme-outreach-ops/AGENTS.md
git:20260927.5061139 · audit A · 13 stars

Every file in kyle-chalmers/streamsnow

Browse by kind, by grade A, or by owner.