snowflake-dbt-demo: Instructions file for Codex

AGENTS.md

snowflake-dbt-demo AGENTS.md is an instructions file for Codex, OpenCode from sfc-gh-dflippo/snowflake-dbt-demo. It costs 10,406 tokens per session, scanned C, original, Apache-2.0.

Project instructions for a dbt and Snowflake data-engineering repository. dbt transforms data into models, while Snowflake is a cloud database; the document explains their tools and project conventions.

In plain words
What is it for?
They help install and configure dbt, work with Snowflake and Python, use Streamlit and Schemachange, and understand the repository’s dbt packages.
Why use it?
They give coding agents the technical context and commands needed to change, test, and run this specific data project correctly.

Instructions file for CodexOpenCode

Written for Codex and OpenCode: the file is AGENTS.md. Also seen: mentions subagents; mentions AGENTS.md; mentions Cursor.

This is sfc-gh-dflippo/snowflake-dbt-demo's own configuration. It tells Codex and OpenCode how to work on snowflake-dbt-demo itself, so it is not a mod to install elsewhere. Copy it as a starting point and replace the rules that are about this project. Everything snowflake-dbt-demo configures →

Not installable: its command points at a path on the author’s own machine, so it runs nowhere else. The line is /Users/dflippo/Documents/GitHub/snowflake-dbt-demo/.claude/skills/snowflake-cli/SKILL.md.

Reuse

Borrowing it

Nothing to install: this file belongs to sfc-gh-dflippo/snowflake-dbt-demo. Take a copy, put it at the same path in your own repository, and replace the rules that are about this project with yours.

Copy the file
curl -O https://raw.githubusercontent.com/sfc-gh-dflippo/snowflake-dbt-demo/main/AGENTS.md
Clone the repo
git clone --depth 1 https://github.com/sfc-gh-dflippo/snowflake-dbt-demo

Made for: Codex, OpenCode.

Wrote this? Show the measurements

A badge with what this costs and how it scanned, read live from this page, so it follows the numbers instead of freezing them. Markdown for a README, HTML for a documentation site or a project page.

agentmods badge for snowflake-dbt-demo AGENTS.md

README.md
[![agentmods](https://agentmods.dev/badge/instructions/sfc-gh-dflippo/snowflake-dbt-demo/agents-md/github.svg)](https://agentmods.dev/instructions/sfc-gh-dflippo/snowflake-dbt-demo/agents-md)
Your own site
<a href="https://agentmods.dev/instructions/sfc-gh-dflippo/snowflake-dbt-demo/agents-md"><img src="https://agentmods.dev/badge/instructions/sfc-gh-dflippo/snowflake-dbt-demo/agents-md/github.svg" alt="Measured on agentmods" height="20"></a>

Or the 80×15 button, for a site that already has a row of RSS and ATOM ones. Only the verdict fits; the numbers stay here.

agentmods 80×15 button for snowflake-dbt-demo AGENTS.md

Your own site · 80×15
<a href="https://agentmods.dev/instructions/sfc-gh-dflippo/snowflake-dbt-demo/agents-md"><img src="https://agentmods.dev/badge/instructions/sfc-gh-dflippo/snowflake-dbt-demo/agents-md.svg" alt="Reviewed on agentmods" width="80" height="20"></a>
Per session 10,406 This file is loaded in full into every session.
When invoked 10,406 The same file — it is already loaded in full.
Security scan C 2 findings. A grade says what 26 rules found in the file — not that it is safe.
Origin original No closer match found in the catalogue.
Token cost

What it costs to keep this loaded

Counted locally with the o200k_base tokenizer, which is exact for GPT models; Claude uses its own tokenizer and its counts differ. Treat this as one consistent yardstick across the catalogue rather than a bill. Prices are per million input tokens.

ModelPer sessionOnce invoked
Fable 5.1 $0.10406 $0.10406
Opus 5 $0.05203 $0.05203
Sonnet 5 $0.02081 $0.02081
Haiku 4.5 $0.01041 $0.01041

Measured 10d ago against content hash 4d6c5b300cef, method: parsed. Prices are Anthropic first-party input rates as of 2026-09-10, from the pricing page.

Security

Grade C, and why

snowflake-dbt-demo AGENTS.md scanned grade C with 2 findings against 26 rules in 11 categories — prompt injection, anti-refusal, data exfiltration, privilege escalation, supply chain, agent snooping, system-prompt leakage, SSRF and excessive agency — measured 10d ago.

A static scan of the body, not an audit. Every finding is printed with the line that produced it so you can judge whether it matters here. A mod is markdown that instructs an agent; that is exactly why what it instructs is worth reading.

Downloads and executes remote codehighSupply chain

curl | sh runs whatever the server returns today, which is not necessarily what it returned when this was reviewed.

**dbt install**: Use the Fusion installer — macOS/Linux: `curl -fsSL https://public.cdn.getdbt.com/fs/install/install.sh | sh -s -- --update`; Windows PowerShell: `irm https://public.cdn.getdbt.com/fs/install/install.ps1

Makes network callslowCapability

Not a fault in itself. Listed so you know the mod talks to something, and to what.

**dbt install**: Use the Fusion installer — macOS/Linux: `curl -fsSL https://public.cdn.getdbt.com/fs/install/install.sh | sh -s -- --update`; Windows PowerShell: `irm https://public.cdn.getdbt.com/fs/install/install.ps1
AGENTS.md · 1,096 lines

How it starts

The opening of the file, as written. The whole thing — 1,096 lines — stays where its author put it; the contents beside it link to each section on GitHub.

AGENTS.md

Context and guidelines for AI coding agents working on this dbt + Snowflake data engineering project.

Project Context

This is a modern data engineering project built with dbt 2.0 (Fusion engine) and Snowflake, implementing industry best practices for analytics engineering.


Technology Stack

Core Technologies

  • dbt (Fusion engine, dbt 2.0): data transformation framework with built-in Snowflake adapter
  • Snowflake: Relational database
  • Streamlit in Snowflake: Preferred graphical user interface (if needed)
  • Schemachange: CI/CD for database objects outside dbt
  • Python: 3.11+ with Snowpark for advanced analytics and ML models

dbt install: Use the Fusion installer — macOS/Linux: curl -fsSL https://public.cdn.getdbt.com/fs/install/install.sh | sh -s -- --update; Windows PowerShell: irm https://public.cdn.getdbt.com/fs/install/install.ps1 | iex. For the Snowflake managed runtime, run SELECT SYSTEM$SUPPORTED_DBT_VERSIONS(); to see supported versions and pin with DBT_VERSION (≥ 2.0 selects the Fusion engine). See dbt Projects on Snowflake.

Key dbt Packages

  • dbt_constraints: Database-level constraint enforcement (primary keys, foreign keys)
  • dbt_utils: Utility macros and helper functions for common transformations
  • dbt_artifacts: dbt logging to Snowflake database tables

Development Tools

  • Snowflake CLI (snow command): Execution of database commands and scripts
  • dbt Projects on Snowflake: Preferred execution environment when not developing locally
  • conda and uv: Preferred Python package managers
  • schemachange: Preferred CI/CD deployment tool for non-dbt objects (procedures, UDF, tasks, etc.)
  • Taskmaster AI: Task-driven development workflow management
  • Git: Version control with feature branch strategy
  • Playwright: Testing GUI applications

Agent Guidelines and Constraints

Read the full file on GitHub · 1,096 lines

Changes

What this file has done since we first saw it

Hashed on every crawl. A supply-chain change to an agent config is a question of when, not whether, so the history is kept rather than the latest state alone.

  1. 10d ago First seen · 1,096 lines · 10,406 tokens per session scan C 4d6c5b300cef

Subscribe to this mod's changes

snowflake-dbt-demo AGENTS.md is an instructions file published in the GitHub repository sfc-gh-dflippo/snowflake-dbt-demo (33 stars, last pushed yesterday), licensed Apache-2.0. It adds 10,406 tokens to every session, about $0.0520 per session on Opus 5. A static security scan graded it C with 2 findings (downloads and executes remote code, makes network calls). No closer match exists in the catalogue, so it is treated as the original; first seen 2026-08-30.

Related

Other instructions, from other repositories

next.js AGENTS.md

AGENTS.md instructions for vercel/next.js, covering next.js development guide, codebase structure, monorepo overview, core package: packages/next and other important packages.

vercel/next.js · 7,296 tokens

codex AGENTS.md

AGENTS.md instructions for openai/codex, covering rust/codex-rs, the codex-core crate, code review rules, crate api surface and model visible context.

openai/codex · 5,153 tokens

vscode buildNext.instructions.md

Working notes and architecture documentation for the new esbuild-based build system in build/next. Use when making changes to the new build pipeline (transpile/bundle commands, NLS plugin, source-map handling, resource copying, or self-hosting watch tasks).

microsoft/vscode · 6,785 tokens

spec-kit AGENTS.md

AGENTS.md instructions for github/spec-kit, covering agents.md, about spec kit and specify, quickstart — add a new integration in 5 steps, integration architecture and integrationmanifest — file tracking.

github/spec-kit · 7,104 tokens

vscode oss-third-party-notices.instructions.md

Instructions for microsoft/vscode, covering vs code oss third-party-notices pipeline, architecture, pipeline flow in ci, applying the notice (cutover) and fallback chain (never fail the build).

microsoft/vscode · 5,001 tokens

langchain AGENTS.md

AGENTS.md instructions for langchain-ai/langchain, covering global development guidelines for the langchain monorepo, corridor security analysis, project architecture and context, monorepo structure and development tools & commands.

langchain-ai/langchain · 4,469 tokens