Develop and optimize SQL queries, design schemas, and advise on indexing strategies.
npx skills add https://github.com/htlin222/dotfiles --skill sql-htlin222
Please help me install this Agent Skill. Skill: sql Source: https://github.com/htlin222/dotfiles/tree/main/claude.symlink/skills/sql Command: npx skills add https://github.com/htlin222/dotfiles --skill sql-htlin222
This Skill helps users write efficient SQL queries, optimize database performance, and design robust database schemas.
Use the sql skill to write a query that calculates the 7-day moving average of sales from the 'transactions' table, ordering by date.
High-intent search queries and answers about installing and using this skill.
To optimize a slow SQL query, analyze its execution plan to identify bottlenecks like full table scans, then implement effective indexing strategies to reduce retrieval times and improve overall database performance.
You can write a SQL query to calculate a 7-day moving average by using window functions to define a frame of preceding rows, averaging the sales column while ordering the dataset by date.
The best way to design a normalized database schema is to organize tables to reduce data redundancy and improve integrity, applying relational database principles to structure relationships and ensure efficient data modeling.
You should add indexes to improve database performance when query execution plans reveal slow data retrieval operations, specifically targeting columns frequently used in WHERE clauses or JOIN conditions to accelerate access.
Yes, you can use Common Table Expressions (CTEs) for complex SQL development to temporarily name a result set, making multi-step data transformations and hierarchical queries much easier to read and maintain.
sahiixxList database tables, detail columns, and map foreign-key relationships.
liutao96Query PolarDB (MySQL) databases using natural language instead of writing SQL.
clawpod-appTranslate natural-language data requests into dialect-aware SQL queries.
SylphxAIModel entities, relationships, and schemas for relational and NoSQL databases.
