Write optimized SQL queries and analyze EXPLAIN plans across major databases.
npx skills add https://github.com/AutumnsGrove/ClaudeSkills --skill sql-expert
Please help me install this Agent Skill. Skill: sql-expert Source: https://github.com/AutumnsGrove/ClaudeSkills/tree/main/sql-expert Command: npx skills add https://github.com/AutumnsGrove/ClaudeSkills --skill sql-expert
Writing complex SQL, optimizing slow queries, designing robust schemas, and managing database changes can be time-consuming and error-prone. This Skill automates the heavy lifting, ensuring your database operations are efficient and reliable.
EXPLAIN plans and get recommendations for indexes and query rewrites.EXPLAIN plan, identify bottlenecks, and suggest optimal indexes and a rewritten, faster query.EXPLAIN ANALYZE SELECT users.name, COUNT(orders.id) as order_count FROM users LEFT JOIN orders ON users.id = orders.user_id GROUP BY users.id, users.name;
High-intent search queries and answers about installing and using this skill.
Query optimization analyzes EXPLAIN plans to identify bottlenecks, recommends indexes, and rewrites queries for better performance. Run EXPLAIN ANALYZE on your slow query to see execution details, then apply index suggestions and restructure joins or subqueries to reduce cost.
Yes. Complex SQL queries combine JOINs, CTEs, and window functions to solve multi-table aggregations and ranking problems. Use parameterized queries to safely pass values and avoid SQL injection while maintaining readability.
Schema design eliminates data redundancy by organizing tables into logical relationships, reducing anomalies and improving query efficiency. Define relationships between entities, apply normalization rules, and validate the structure before migration.
Safe migrations generate scripts with rollback capability, allowing schema changes on live databases without service interruption. Execute migrations in stages, test rollbacks first, and include indexes and constraints as part of the migration plan.
Yes. The Skill handles PostgreSQL, MySQL, SQLite, and SQL Server, adapting syntax and query optimization techniques to each database engine's EXPLAIN format and index capabilities.
SQL error debugging identifies syntax issues, constraint violations, and logic errors in queries. Check parameterization, verify table and column names, review JOIN conditions, and test with sample data to isolate the problem.
icartshWrite optimized SQL queries and schemas across PostgreSQL, MySQL, SQLite, and SQL Server.
Tnemo65Analyze slow queries and execution plans to optimize database performance.
devCharuzuTranslate user requirements into SQL queries, migration scripts, and ORM patterns.
loianeDetect Flyway or Liquibase usage from pom.xml dependencies and migration directories.