About
The Data SQL skill empowers Claude with specialized knowledge for architecting robust database systems and writing high-performance queries across dialects like PostgreSQL, Redshift, and Spark SQL. It provides a structured framework for query optimization through Common Table Expressions (CTEs), efficient indexing strategies, and advanced window functions. By enforcing best practices such as idempotent operations and explicit column selection, this skill helps developers move from basic CRUD operations to sophisticated data modeling, including star schemas and slowly changing dimensions, while systematically avoiding common performance anti-patterns.
