Sql skills

This skill designs dimensional models and data warehouses, enabling analytics teams to build scalable schemas, optimize queries, and deliver reliable BI

This skill helps you implement ACID transactions, manage isolation levels, and handle concurrency in SQL backed applications.

This skill helps you master PHP database operations with PDO, ORM patterns, optimization, migrations, and robust error handling.

This skill helps you write and debug TypeQL queries for TypeDB 3.8+, covering schema, data operations, and complex pattern matching.

This skill performs a comprehensive ClickHouse diagnostic by orchestrating expert modules to reveal performance bottlenecks and actionable improvements.

This skill securely queries PostgreSQL databases via pglr, lists tables, and describes schemas without exposing credentials.

This skill helps you craft production-ready Supabase RLS policies with best practices and PostgreSQL conventions.

This skill helps you perform exploratory data analysis and advanced SQL analytics to derive business insights from complex datasets.

This skill analyzes SQL queries, suggests indexing and rewriting techniques to boost performance across databases.

This skill helps you master BI fundamentals including metric definitions, KPI calculations, dimensional modeling, and dashboard optimization for rapid data

This skill helps you design data warehouses using star schemas and slowly changing dimensions to improve query performance and accuracy.

This skill helps you master SQL fundamentals, enabling efficient data queries, updates, and design patterns across databases.

This skill helps you manage database schema changes safely with version control, migration tools, and zero-downtime deployment strategies.

This skill helps you administer and optimize MySQL databases, enabling efficient query tuning, replication setup, and reliable backups.

This skill helps you design schemas, optimize queries, and manage migrations for MongoDB and PostgreSQL with practical, production-ready guidance.

This skill analyzes database schemas and suggests improvements for Prisma, TypeORM, or Drizzle, and can generate TypeScript types.

This skill generates CakePHP test fixtures directly from migration files, integrates Configure::read usage, and supports multi-database environments.

This skill designs PostgreSQL 17 schemas and migrations for laneweaverTMS using UUIDs, audit trails, soft deletes, and Supabase conventions.

This skill analyzes ClickHouse issues through targeted wave agents, producing reproducible artifacts and an RCA-style report to guide faster remediation.

This skill designs scalable database schemas and multi-tenant migrations for PHP/CakePHP projects, ensuring normalized structures and maintainable migrations.

This skill helps you optimize slow database queries, fix N+1 problems, and design effective indexes to boost PostgreSQL, MySQL, and other DB performance.