What problem does it solve? Writing or modifying Snowflake-backed analytics queries in the LFX One backend is error-prone: SQL bind mismatches are the most common Critical bug, and bypassing the singleton connection pool breaks query deduplication and warehouse selection. This Skill enforces the correct patterns before code review catches them. ## Core Features & Use Cases - Bind Discipline Enforcement: Walks through SQL left-to-right to verify every ? placeholder has a matching value in the binds array, preventing Critical review flags. - Singleton Pool Compliance: Ensures all new analytics endpoints route through snowflake.service.ts rather than creating ad-hoc connections. - Parameterized Query Guidance: Blocks string interpolation of user input into SQL and pushes filtering into Snowflake columns instead of post-fetch JS filtering. - Use Case: When adding a new analytics endpoint under apps/lfx-one/src/server/, use this Skill to write the query, align binds, select the right warehouse, and log via the logger service correctly. ## Quick Start Use the snowflake skill to add a new Snowflake-backed analytics endpoint with a parameterized query and correctly aligned binds.
