skills.rest
Tibsfox
TibsfoxCOMMUNITY
Explore all skills by this author →
WebsiteGitHub

sql-patterns

Analyzes and optimizes SQL queries for improved performance and security across PostgreSQL and MySQL.

69|9|Updated Jan 30, 2026
Search Tags:#indexing#migrations#sql#best-practices#query-optimization#database-design
One-click install
npx skills add https://github.com/Tibsfox/gsd-skill-creator --skill sql-patterns-tibsfox
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: sql-patterns
Source: https://github.com/Tibsfox/gsd-skill-creator/tree/main/examples/skills/sql-patterns
Command: npx skills add https://github.com/Tibsfox/gsd-skill-creator --skill sql-patterns-tibsfox

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

SQL patterns and best practices to help you write safe, efficient, and maintainable queries across schemas, migrations, and indexing tasks.

Core Features & Use Cases

  • Parameterized queries and safe input handling to prevent SQL injection.
  • Query optimization guidance, indexing strategies, and schema design tips.
  • Use cases include designing scalable schemas, performing migrations safely, and tuning slow queries in PostgreSQL, MySQL, and other relational databases.

Quick Start

Craft a parameterized SQL query to retrieve a user's id and name by email.

Frequently Asked Questions about sql-patterns

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I optimize slow SQL queries in PostgreSQL or MySQL?▼

To optimize slow SQL queries, you need query tuning, indexing strategies, and schema design adjustments. This Skill provides best practices for analyzing and improving query performance safely across PostgreSQL, MySQL, and other relational databases.

What is the best way to write parameterized SQL queries for safe input handling?▼

Parameterized SQL queries prevent SQL injection by safely handling input data. This Skill offers patterns and best practices to help you write secure, efficient queries that protect against vulnerabilities during database interactions.

How do I perform safe database migrations and schema design?▼

Safe database migrations require guidelines for schema design and careful execution to avoid data loss. This Skill provides best practices for designing scalable schemas and performing migrations safely across relational databases.

What are the default indexing strategies for maintaining fast database queries?▼

Default indexing strategies ensure fast query retrieval without compromising safety. This Skill applies safe default indexing strategies and query optimization techniques to maintain high performance in relational databases.

Does this SQL query optimization approach work across different relational databases?▼

Yes, this query optimization approach works across PostgreSQL, MySQL, and other relational databases. It provides generalized SQL patterns and best practices for performance tuning, indexing, and schema design rather than focusing on a single platform.

Related Skills

Explore More Software Engineering Skills→
dtsongdtsong
1

Schema Design

Design relational database schemas with normalization, indexes, and migration-ready SQL.

Community
Advanced
FlorianRiquelmeFlorianRiquelme

Backend Queries

Enforce parameterized queries and optimize Eloquent and raw SQL database access.

Community
Basic
salverius-techsalverius-tech

database-workflow

Provide database best practices for migrations, schema design, and query optimization.

Community
Advanced
PriyanshKuniyalPriyanshKuniyal

sql-optimization-patterns

Analyzes SQL queries and applies indexing strategies using EXPLAIN output.

Community
Advanced