nicsuzor/dbt
aops-extras/skills/dbt/SKILL.md
dbt (data build tool) implementation of the analyst transformation layer. Use when a project has a dbt/ directory or you need to build, test, or document SQL transformations as version-controlled, reproducible dbt models. This is the dbt-specific HOW for the tech-agnostic principles in the aops-tools analyst skill.
$ install --global
skillsauthnpx skillsauth add nicsuzor/academicops dbtInstall this skill globally with one command. Works with Claude Code, Cursor, and Windsurf.
Security Scan Results
3 of 9 scanners reported clean
Some scanners were skipped, did not run, or reported a non-clean status. Review each row below.
3
Scanners Passed
9
Scanners in report
Clean
TrivyContainer and dependency vulnerability scanner
95%
Clean
SemgrepStatic code analysis for vulnerabilities
95%
Clean
mcp-scan (Snyk)Model Context Protocol security validation
95%
Skipped
Snyk (dep)Open source security scanning
50%
Skipped
Socket.devSupply chain security analysis
50%
Skipped
VirusTotalMulti-engine malware detection
50%
Skipped
CrowdStrikeAdvanced threat intelligence
50%
Skipped
OSV-ScannerOpen Source Vulnerability database check
50%
Skipped
OWASP Dep-Check
50%
Last scanned: Jun 13, 2026, 7:02 AM36.1s1 file scanned
SKILL.md
- name:
- dbt
- type:
- skill
- description:
- dbt (data build tool) implementation of the analyst transformation layer. Use when a project has a dbt/ directory or you need to build, test, or document SQL transformations as version-controlled, reproducible dbt models. This is the dbt-specific HOW for the tech-agnostic principles in the aops-tools analyst skill.
- category:
- instruction
- modifies_files:
- true
- needs_task:
- false
- mode:
- execution
- allowed-tools:
- Read,Grep,Glob,Edit,Write,Bash,Skill
- version:
- 0.1.0
- permalink:
- skills-aops-extras-dbt
dbt — Transformation Layer (academicOps)
This skill is the dbt-specific implementation of the transformation layer described
in the tech-agnostic analyst skill (aops-tools). The analyst skill owns the
principles (all transformation in a versioned/tested/reproducible layer; presentation
displays pre-computed data only); this skill owns the dbt how-to.
dbt is one swappable choice of transformation layer. The analyst principles hold regardless of which engine you use; only the commands and file layout below are dbt-specific.
Contents
- [[dbt-workflow]] — single-step collaborative workflow for creating and modifying dbt models in the staging / intermediate / mart layered architecture.
- [[dbt-patterns]] — comprehensive reference: data-access policy, model organisation, testing strategies (schema / singular / package tests), documentation, incremental models, and performance.
When to use
- The project contains a
dbt/directory (dbt/models/,dbt_project.yml). - You need to add a metric, join, aggregation, or any business logic — it belongs in a dbt model with tests, never in the presentation layer.
- You need to test or document a transformation so reviewers can re-run and audit it.
Related Skills
nicsuzor/streamlit
tools
VerifiedTrustedCommunity
Streamlit implementation of the analyst presentation layer. Use when building or updating a Streamlit dashboard that displays pre-computed research data. This is the Streamlit-specific HOW for the tech-agnostic principles in the aops-tools analyst skill — display only, never transform.
2SKILL.mdUpdated Jun 13, 2026
nicsuzor/python-viz
tools
VerifiedTrustedCommunity
Python plotting and statistical-modelling libraries (matplotlib, seaborn, statsmodels) for the analyst presentation and statistical-methodology layers. Use when producing publication-quality figures or fitting statistical models in Python. Library-specific HOW for the tech-agnostic principles in the aops-tools analyst skill.
2SKILL.mdUpdated Jun 13, 2026
nicsuzor/aops
development
VerifiedTrustedCommunity
Core academicOps skill — institutional memory, strategic coordination, workflow routing, and framework governance. Merges butler (chief-of-staff) with framework development conventions.
2SKILL.mdUpdated Apr 18, 2026
nicsuzor/analyst
development
VerifiedTrustedCommunity
Support academic research data analysis with technology-agnostic principles — research-data immutability, a versioned/tested/reproducible transformation layer, statistical methodology, and self-documenting research. Use this skill for any computational research project with an empirical data pipeline. The skill enforces academicOps best practices for reproducible, transparent research with a collaborative single-step workflow. Tech-specific how-to (dbt, Streamlit, Python plotting/stats) lives in the aops-extras package.
2SKILL.mdUpdated Apr 9, 2026