snowflake-principal-engineer
Principal/Senior-level Snowflake playbook for warehouse architecture, data modeling, cost governance, security, data sharing, and operating enterprise analytics platforms responsibly. Use when: designing Snowflake environments, reviewing warehouse and database strategy, governing data platforms, or optimizing cost and reliability in production analytics workflows.
What this skill does
# Snowflake Mastery (Senior → Principal) ## Operate - Start from business domains, data product boundaries, governance, and cost visibility. - Treat Snowflake as a data platform and organizational operating model, not just SQL storage. - Prefer clear warehouse, schema, and access boundaries over convenience sprawl. - Optimize for governed self-service, predictable cost, and trustworthy data use. ## Default Standards - Warehouse design must reflect workload classes and cost control. - Data model and sharing strategy should match domain ownership. - Access, masking, and compliance controls must be explicit. - Platform governance should enable teams without creating chaos. - Performance optimization should not ignore cost efficiency. ## References - Account, org, and environment architecture: [references/account-org-and-environment-architecture.md](references/account-org-and-environment-architecture.md) - Warehouse strategy and workload isolation: [references/warehouse-strategy-and-workload-isolation.md](references/warehouse-strategy-and-workload-isolation.md) - Data modeling, schemas, and domain ownership: [references/data-modeling-schemas-and-domain-ownership.md](references/data-modeling-schemas-and-domain-ownership.md) - Security, masking, and governance: [references/security-masking-and-governance.md](references/security-masking-and-governance.md) - Sharing, data products, and collaboration: [references/sharing-data-products-and-collaboration.md](references/sharing-data-products-and-collaboration.md) - Cost optimization and platform economics: [references/cost-optimization-and-platform-economics.md](references/cost-optimization-and-platform-economics.md) - Reliability and operations: [references/reliability-and-operations.md](references/reliability-and-operations.md) - Incident runbooks: [references/incident-runbooks.md](references/incident-runbooks.md)
Related in Security
mac-ops
IncludedComprehensive macOS workstation operations — diagnose kernel panics, identify failing drives, audit launchd startup items, decode wake reasons, triage TCC permission denials, manage APFS snapshots, recover from no-boot. Use for: Mac is slow, slow bootup, won't boot, kernel panic, kernel_task hot, mds_stores CPU, photoanalysisd, cloudd, login loop, gray screen, sleep wake failure, drive failing, IO errors, APFS snapshots eating space, Time Machine local snapshots, Spotlight indexing, launchd, LaunchAgent, LaunchDaemon, login items, TCC permissions, Full Disk Access, Screen Recording denied, Gatekeeper, quarantine, com.apple.quarantine, app is damaged, helper tool, /Library/PrivilegedHelperTools, pmset, wake reasons, dark wake, sysdiagnose, panic.ips, DiagnosticReports, configuration profile, MDM profile, remote diagnostics over SSH.
a11y-audit
IncludedRun accessibility audits on web projects combining automated scanning (axe-core, Lighthouse) with WCAG 2.1 AA compliance mapping, manual check guidance, and structured reporting. Output is configurable: markdown report only, markdown plus machine-readable JSON, or markdown plus issue tracker integration. Use this skill whenever the user mentions "accessibility audit", "a11y audit", "WCAG audit", "accessibility check", "compliance scan", or asks to check a web project for accessibility issues. Also trigger when the user wants to verify WCAG conformance or map findings to a specific standard (CAN-ASC-6.2, EN 301 549, ADA/AODA).
erpclaw
IncludedAI-native ERP system with self-extending OS. Full accounting, invoicing, inventory, purchasing, tax, billing, HR, payroll, advanced accounting (ASC 606/842, intercompany, consolidation), and financial reporting. 413 actions across 14 domains, 43 expansion modules. Constitutional guardrails, adversarial audit, schema migration. Double-entry GL, immutable audit trail, US GAAP.
assess
IncludedAssesses and rates quality 0-10 across multiple dimensions (correctness, maintainability, security, performance, testability, simplicity) with pros/cons analysis. Compares against project conventions and prior decisions from memory. Produces structured evaluation reports with actionable improvement suggestions. Use when evaluating code, designs, architectures, or comparing alternative approaches.
spring-boot-security-jwt
IncludedProvides JWT authentication and authorization patterns for Spring Boot 3.5.x covering token generation with JJWT, Bearer/cookie authentication, database/OAuth2 integration, and RBAC/permission-based access control using Spring Security 6.x. Use when implementing authentication or authorization in Spring Boot applications.
code-hardcode-audit
IncludedDetect hardcoded values, magic numbers, and leaked secrets. TRIGGERS - hardcode audit, magic numbers, PLR2004, secret scanning.