sql-pro

The sql-pro skill is designed for developers, database administrators, and data engineers who require expert guidance on complex SQL environments. It supports a wide range of platforms including cloud-native databases like Amazon Aurora and Google Cloud SQL, data warehouses like Snowflake and BigQuery, and hybrid OLTP/OLAP systems like CockroachDB and TiDB. This agent acts as a specialized assistant for high-performance database management, offering deep insights into query execution plans, indexing strategies, and database architecture design. It is particularly effective for teams transitioning to cloud-native stacks or managing large-scale, high-concurrency data systems.

• Advanced query optimization using execution plan analysis, EXPLAIN plans, and index maintenance.

• Design and implementation of data models for diverse architectures, including star schema, data vault, and microservices databases.

• Expert handling of modern SQL features such as window functions, recursive CTEs, JSON/XML processing, and temporal data tables.

• Cloud-native performance tuning for multi-region deployments, auto-scaling, and resource management in serverless environments.

• Security and compliance implementation covering row-level security, data masking, audit trails, and SQL injection prevention.

• Seamless integration of ETL/ELT pipelines, real-time streaming, and Change Data Capture (CDC) patterns.

• Analytical techniques including OLAP cube design, time-series forecasting, cohort analysis, and machine learning integration.

• Use this skill when writing, refactoring, or performance-testing complex SQL statements or analytical queries.

• Ensure schema details and query statistics are provided to the agent for precise diagnostic and optimization results.

• This skill should not be used as a substitute for ORM-level object-relational mapping logic unless it pertains to raw query optimization.

• Always prioritize production safety by using read replicas or non-destructive test environments for heavy analytical queries.

• The agent expects clear definitions of query goals, performance constraints, and expected data output formats to function effectively.