Skill UI

A comprehensive guide to optimizing query performance in Snowflake. Learn advanced techniques such as implementing clustering keys, utilizing materialized views, leveraging result caching, and analyzing query profiles. This guide also covers best practices for warehouse tuning and optimizing common SQL anti-patterns to ensure efficient data querying and cost management.

This guide outlines architectural patterns and best practices for building scalable, production-ready APIs with FastAPI. It covers proper project structure, separating concerns using routers, services, and CRUD layers, implementing dependency injection for database sessions and authentication, defining Pydantic schemas for request/response, handling asynchronous operations, and managing custom error responses.

This expert skill guides the creation of comprehensive, highly structured, and implementation-ready design system guidelines based on Material Design principles. It ensures consistency across visual style, accessibility (WCAG 2.2 AA), and component behavior. The output is actionable documentation covering tokens, states, variants, and anti-patterns, suitable for guiding both engineers and designers.

An expert skill designed to author comprehensive, implementation-ready design system guidelines for editorial content like books, magazines, and reports. It structures visual language across tokens, typography, spacing, and component states, while rigorously adhering to WCAG accessibility standards and defining clear content tone and anti-patterns for developers and designers.

This skill functions as an expert design system author, generating comprehensive, implementation-ready guidelines based on specific brand aesthetics (e.g., Riso). It covers design tokens, component anatomy, accessibility criteria (WCAG 2.2 AA), writing tone, and anti-patterns. It ensures deep consistency and usability for engineers and designers.

A powerful PreToolUse hook designed to act as a safety net during code writing sessions. It automatically scans both file paths and content for 12 common security anti-patterns, including SQL injection, XSS, command injection (Node.js/Python), and unsafe deserialization. It blocks the writing operation and provides immediate warnings, ensuring adherence to secure coding practices when handling sensitive code like authentication or payment logic.

A comprehensive guide to writing idiomatic and efficient Go code. It covers best practices for error handling (using `%w`), managing slices and maps, implementing robust concurrency with goroutines and channels, designing small composable interfaces, and avoiding common anti-patterns. Essential for improving code quality in Go projects.

This comprehensive guide outlines modern and idiomatic Java best practices. It covers advanced topics like Streams, Optional, Records, and Pattern Matching, while detailing anti-patterns and efficient ways to handle concurrency and error management in contemporary Java development.

This guide serves as a comprehensive reference for writing idiomatic, efficient, and modern Python code. It covers best practices for comprehensions, context managers, error handling (EAFP), data class usage, type hinting, and avoiding common anti-patterns, helping developers write cleaner, more robust, and truly 'Pythonic' code.