Use when revising prose for a Sociological Methods & Research (SMR) manuscript — methods-paper introduction arc, ASA citation style, the…
Conduct comprehensive security assessments of SMTP (Simple Mail Transfer Protocol) servers to identify vulnerabilities including open…
XCUITest specialist for iOS UI automation, accessibility-identifier-driven element queries, programmatic screenshot capture, and fastlane…
Create and validate component snapshots for UI regression testing.
Use this skill to inspect network connections with a modern, readable output.
MUST use when writing Snowflake queries.
Apply advanced Snowflake debugging with query profiling, spill analysis, lock contention, and performance deep-dives using ACCOUNT_USAGE…
Choose and implement Snowflake architecture blueprints: data lakehouse,
Automate Snowflake data warehouse operations -- list databases, schemas, and tables, execute SQL statements, and manage data workflows via…
Execute Snowflake primary workflow: data loading via stages and COPY
Execute Snowflake data transformation with streams, tasks, and dynamic tables.
Optimize Snowflake costs with resource monitors, warehouse auto-suspend,
Collect Snowflake debug evidence for support tickets and troubleshooting.
Use when writing Snowflake SQL, building data pipelines with Dynamic Tables or Streams/Tasks, using Cortex AI functions, creating Cortex…
Create a minimal working Snowflake example with real SQL queries.
Install and configure Snowflake driver authentication for Node.js and
Identify and avoid Snowflake anti-patterns and common mistakes in SQL,
Implement Snowflake load testing, warehouse scaling, and capacity planning.
Configure Snowflake local development with testing, mocking, and fast iteration.
Handle Snowflake concurrency limits, warehouse queuing, and query throttling.
Apply production-ready Snowflake SDK patterns for snowflake-sdk and snowflake-connector-python.