Getting it into your agent
One page per mod, every tool's command on it. A separate URL per tool would split the same page into five that compete with each other.
npx agentmods add rules/hamzaamjad/cursor-rules/203-analytics-engineeringgit clone --depth 1 https://github.com/hamzaamjad/cursor-rulesWhat 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.
| Model | Per session | Once invoked |
|---|---|---|
| Fable 5 | $0.00000 | $0.00408 |
| Opus 5 | $0.00000 | $0.00204 |
| Sonnet 5 | $0.00000 | $0.00082 |
| Haiku 4.5 | $0.00000 | $0.00041 |
Grade A, and why
203-analytics-engineering scanned grade A with 0 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 yesterday.
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.
Nothing flagged
None of the 26 patterns this scan looks for appear in this file: no shell pipes, no recursive deletes, no credential paths, no hidden text, no instruction-override or anti-refusal phrasing, no agent-config snooping. That is not a guarantee, it is the absence of the things that are checkable.
What it actually says
analytics-engineering.mdc
- Purpose: Guide development of Mirror's analytics engineering layer using dbt+DuckDB for transforming raw personal data into AI-consumable information.
- Requirements:
- Privacy-First: All transformations run locally. Set
send_anonymous_usage_stats: falsein dbt_project.yml - Incremental Processing: Use
{{ is_incremental() }}for efficiency on personal devices - Semantic Layer: Models follow staging → intermediate → marts pattern for DIKW progression
- Testing Coverage: Every model needs primary key test + business logic validation
- Documentation: Each model requires description explaining its role in the semantic layer
- Privacy-First: All transformations run locally. Set
- Validation:
- Check: Does model compile with
dbt compile? - Check: Are PII fields hashed using
{{ hash_pii() }}macro? - Check: Do incremental models have proper unique_key?
- Check: Is there a corresponding test in schema.yml?
- Check: Does model compile with
- Patterns:
- Daily Aggregations: Use
date_trunc('day', timestamp)for consistent grouping - Score Calculations: Normalize to 0-100 range for AI interpretation
- Anomaly Handling: Filter outliers in staging, don't propagate to marts
- Mobile Sync: Only sync mart tables, never raw/staging data
- Daily Aggregations: Use
- Wildcard Ideas:
- Real-time CDC: Use DuckDB's APPENDER API for streaming inserts
- Graph Analytics: Model social health metrics using DuckDB's recursive CTEs
- Federated Learning: Pre-aggregate personal models for privacy-preserving ML
- Source References: Mirror dbt evaluation, DuckDB best practices
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.
- yesterday First seen · 28 lines · 0 tokens per session scan A 58974df28e24
203-analytics-engineering is a cursor rule published in the GitHub repository hamzaamjad/cursor-rules (2 stars, last pushed 1y ago), licensed MIT. It costs nothing until one of its globs matches a file; then it loads 408 tokens. A static security scan graded it A with 0 findings. No closer match exists in the catalogue, so it is treated as the original; first seen 2026-08-31.
Other cursor rules, from other repositories
angular-20
This rule provides comprehensive best practices and coding standards for Angular development, focusing on modern TypeScript, standalone components, signals, and performance optimizations.
dev-standard
Apache Superset development standards and guidelines for Cursor IDE.
typescript
Changes to these high-fan-out internals can affect every message, delta, element, or rerun. Keep work in them minimal, and benchmark changes with representative stress-test apps.
coolify-ai-docs
Master reference to all Coolify AI documentation in .ai/ directory.
python_lib
Tips and guidelines specific to the development of the Streamlit Python library, not applicable to scripts and e2e tests.
specs
This directory contains product and tech specs for Streamlit features.