Write clean SQL queries and normalized schemas for PostgreSQL, MySQL, BigQuery, and SQLite.
npx skills add https://github.com/grasberg/sofia --skill sql-analyst-grasberg
Please help me install this Agent Skill. Skill: sql-analyst Source: https://github.com/grasberg/sofia/tree/main/workspace/skills/sql-analyst Command: npx skills add https://github.com/grasberg/sofia --skill sql-analyst-grasberg
SQL experts who craft readable, maintainable queries using CTEs, descriptive names, and minimal nesting to simplify data work and improve performance.
Ask SQL-Analyst to design a normalized schema and produce a clean, optimized SQL query for PostgreSQL.
High-intent search queries and answers about installing and using this skill.
Clean SQL queries use Common Table Expressions (CTEs) to replace complex subqueries, reducing nesting and improving readability. This approach simplifies data work by breaking down logic into descriptive, well-commented steps that are easier to maintain and optimize.
Normalized SQL schema design organizes data into third normal form (3NF) with clear entity relationships and constraints. This reduces data redundancy and complexity while providing indexing guidance to improve overall query performance.
Yes, this approach supports PostgreSQL, MySQL, BigQuery, and SQLite. It generates dialect-aware SQL queries, ensuring syntax complies with specific database requirements while maintaining clean formatting and safe defaults across platforms.
SQL anti-pattern detection identifies issues like N+1 queries and SELECT * usage by flagging unsafe patterns. It recommends safe defaults and optimized joins, analyzing execution plans to guide indexing strategies and resolve performance bottlenecks.
Yes, you can handle reversible DDL changes and data transformations safely. The process includes validation steps and inline documentation to ensure reliable database migrations, preventing data loss during schema modifications.
SQL performance optimization analyzes execution plans to identify bottlenecks and optimize joins. It recommends specific indexing strategies and flags unsafe patterns, ensuring queries run efficiently across supported database dialects.
mvandermeulenDesign PostgreSQL schemas with normalization, indexing, and constraints.
weirdgmeDesign and implement scalable platform engineering patterns for internal developer platforms.
MinhmiceDesigns and migrates database schemas, policies and queries for SQL-based systems.
Veloxia-agencyWrite and optimize SQL queries with EXPLAIN-driven performance analysis.
