Provide reusable SQL patterns and templates for PostgreSQL and MySQL.
npx skills add https://github.com/tomlupo/ai-playground --skill sql-patterns-tomlupo
Please help me install this Agent Skill. Skill: sql-patterns Source: https://github.com/tomlupo/ai-playground/tree/main/.claude/skills/sql-patterns Command: npx skills add https://github.com/tomlupo/ai-playground --skill sql-patterns-tomlupo
This Skill provides ready-to-use SQL patterns, templates, and best practices to accelerate query writing, schema exploration, and data analysis.
Apply the provided PostgreSQL/MySQL patterns to your database by adapting the sample queries to your schema and running them in your environment.
High-intent search queries and answers about installing and using this skill.
SQL patterns for data analysis provide ready-to-use templates for complex joins, aggregations, and window analytics. These templates accelerate query writing and help uncover insights, performance issues, and data quality across PostgreSQL and MySQL environments.
To write window functions in PostgreSQL and MySQL, apply reusable SQL templates designed for advanced analytics. These best-practice patterns guide you through executing complex aggregations and window analytics safely within standard database environments.
Yes, these SQL templates work with both MySQL and PostgreSQL. The patterns are built for standard SQL environments, allowing you to adapt sample queries for schema exploration and robust data retrieval across both database systems.
To explore a database schema using SQL, apply common exploratory query patterns. These templates speed up schema understanding and data retrieval in PostgreSQL and MySQL, helping you quickly map out and navigate database structures.
The best way to structure performance-oriented SQL queries is by applying established best practices and reusable templates. These patterns optimize data retrieval, include safety guidance, and improve query performance in standard SQL environments.
You should use advanced SQL aggregations when standard queries cannot handle complex analytics or multi-level data grouping. Applying window functions and reusable templates helps uncover deeper insights and resolve data quality issues efficiently.
jieni777Connect to PostgreSQL or MySQL databases to execute SQL queries and inspect schema.
CellCogAnalyze messy datasets to produce insights, charts, and data-driven reports.
iankikuDesign analytics systems, generate SQL queries, plan event tracking, and build dashboards.
rajitsahaConvert natural language business questions into executable SQL queries for multiple database systems.
