Provide SQL query patterns and best practices for PostgreSQL, MySQL, and SQLite.
npx skills add https://github.com/eous/dotclaude --skill sql-patterns-eous
Please help me install this Agent Skill. Skill: sql-patterns Source: https://github.com/eous/dotclaude/tree/main/skills/sql-patterns Command: npx skills add https://github.com/eous/dotclaude --skill sql-patterns-eous
Helps developers write efficient and correct SQL by providing proven patterns for querying, optimization, and schema design across PostgreSQL, MySQL, and SQLite.
Provide an optimized rewrite of a given SQL query and explain the indexing and join choices behind the optimization.
High-intent search queries and answers about installing and using this skill.
Optimize slow SQL queries by applying proper indexing strategies, selecting explicit columns instead of SELECT *, and choosing correct join types to avoid N+1 issues. Rewriting queries with modern SQL features like CTEs and window functions also improves data retrieval performance.
The best way to write SQL aggregations is leveraging GROUP BY for grouped summaries and window functions for row-level calculations across partitions. This approach ensures correct data retrieval while maintaining query efficiency across PostgreSQL, MySQL, and SQLite.
Yes, the SQL query optimization patterns apply to PostgreSQL, MySQL, and SQLite. The guidance covers indexing strategies, schema design, and modern SQL features tailored for application code and analytics work across these specific database platforms.
Use CTEs in SQL query performance tuning when breaking down complex SELECT statements into readable, modular blocks. CTEs help structure intricate data retrieval logic and aggregations, making query optimization and maintenance significantly easier.
Avoid N+1 queries by using proper JOIN types to fetch related data in a single database round-trip. Effective schema design and indexing strategies ensure these JOIN operations perform efficiently without repeated data retrieval calls.
tinkermonkeyDefine physical database schemas with SQL DDL for PostgreSQL, MySQL, and SQLite.
EstomOptimize SQL queries and database schemas for PostgreSQL, MySQL, SQL Server, and Oracle.
vix-4800Review database schemas, migrations, and ORM query strategies for safe data evolution.
giadaf-booshaGuide writing optimized SQL queries across Snowflake, BigQuery, Databricks, PostgreSQL, and Redshift.
