Optimize database queries and schema
sql-patternsskillsetup L2★64
Tibsfox/gsd-skill-creator ↗What it does
Write safe, performant SQL with parameterized inputs and indexes
Best for
When optimizing queries, designing schemas, or ensuring SQL injection prevention via parameterized queries.
Inputs
- · SQL query or schema, database name (PostgreSQL/MySQL)
Outputs
- · Parameterized queries, EXPLAIN analysis, optimization recommendations
Requires
- · PostgreSQL
- · MySQL
Preconditions
- · Necessary tools or libraries available
Failure modes
- · Misunderstanding of requirements
- · Incomplete or outdated examples
Trust signals
- · Peer reviewed
- · Applied successfully to similar context
- · Source documented