Sql skills

This skill analyzes a Magento 1 module to determine its purpose, usage, and migration viability for Magento 2.

This skill helps you develop robust Keboola Streamlit data apps by validating data structures, building SQL-first queries, and verifying with Playwright.

This skill helps you create and customize Frappe reports including query, script, and nocode builders for powerful data analysis.

This skill helps you identify and remediate race conditions by applying atomic, transactional, and locking patterns across code paths.

This skill enforces safe Laravel migrations and factories, guiding when to modify or add migrations, and pairing models with seeds for realistic, tested

This skill helps ensure atomic multi-step writes in Laravel by wrapping operations in transactions and applying after-commit events for consistency.

This skill helps you systematically debug Flask apps with phase-driven approach, tooling guidance, and actionable steps for routing, templates, and DB issues.

This skill helps you prevent Rails runtime errors before coding by enforcing explicit exposure, proper grouping, and safe component access.

This skill helps you build revenue analytics on HubSpot by connecting API data, SQL warehouse queries, and ML scoring to drive actionable insights.

This skill helps you optimize Rails ActiveRecord queries, manage associations, and use PostgreSQL patterns to prevent N+1 and improve performance.

This skill helps you craft and optimize PostGIS 3.5+ queries by applying latest function changes, topology, and raster enhancements across spatial analyses.

This skill runs a quick overview of ClickHouse server health, analyzes metrics and logs, and routes findings to relevant expert modules.

This skill diagnoses ClickHouse query performance, identifies slow patterns, and offers optimization insights to reduce latency and timeouts.

This skill helps validate ClickHouse connections and prepare MCP or client queries for diagnostics and analysis.

This skill designs high-performance PostgreSQL databases with optimized schemas, indexing, partitioning, replication, and PostgreSQL 17 tuning for production

This skill analyzes ClickHouse disk usage and compression, identifies bottlenecks, and recommends optimizations for storage efficiency.

This skill diagnoses and resolves ClickHouse grant and authentication errors after upgrades, guiding minimal grants and post-upgrade compatibility checks for

This skill analyzes database queries to optimize performance through quick wins and deeper schema and index improvements for scalable workloads.

This skill diagnoses ClickHouse merge performance and part backlog, generating a decision-ready report for remediation and ongoing monitoring.

This skill analyzes ClickHouse system logs health, TTL settings, disk usage, freshness, and cleanup to optimize retention and RCA readiness.

This skill helps diagnose ClickHouse RAM usage, OOM risks, and memory pressure, guiding you to optimize queries and configurations.