Optimize SQL queries, indexing, and schema design for complex workloads.
npx skills add https://github.com/platootalp/agents --skill sql-expert-platootalp
Please help me install this Agent Skill. Skill: sql_expert Source: https://github.com/platootalp/agents/tree/main/apps/engineer/coder/skills/sql_expert Command: npx skills add https://github.com/platootalp/agents --skill sql-expert-platootalp
SQL querying, performance tuning, and database design are common bottlenecks for developers and data teams. This Skill provides practical guidance to write efficient SQL, optimize queries, and design scalable schemas that meet real-world requirements.
Provide an optimized SQL query and schema design guidance for a given workload and dataset.
High-intent search queries and answers about installing and using this skill.
Optimize slow SQL queries by diagnosing execution plans, applying targeted indexing strategies, and rewriting queries to handle complex joins and aggregations efficiently across transactional and analytical databases.
Design a scalable database schema by proposing normalized or denormalized models based on your specific workload, applying appropriate constraints and data types to support lean warehouse architectures for analytical reporting.
Denormalize your database schema when analytical workloads require faster read performance, applying denormalized models to complex data workloads instead of normalized structures used for transactional integrity.
Yes, you can apply SQL optimization and schema design guidance to both transactional and analytical databases, addressing real-world data models for complex data workloads across different database types.
Your SQL query execution plan shows a table scan due to missing indexes or non-sargable query predicates, requiring indexing strategies and query rewrites to improve execution performance and avoid full table scans.
Write SQL queries handling complex joins by constructing correct, readable statements that manage complex aggregations and multi-table relationships while satisfying performance diagnostics criteria for scalable data retrieval.
yu13130122297Identify uncertainties in research framing, datasets, metrics, and baselines.
iCesofTAnalyze EXPLAIN plans and apply indexing strategies to eliminate slow SQL queries.
Tnemo65Automate end-to-end data pipeline and platform design with governance and cost optimization.
chatermAnalyze SQL execution plans and optimize indexes for MySQL and PostgreSQL queries.
