sql-patterns
Installation
SKILL.md
SQL Patterns Skill
Write efficient SQL queries and maintainable database migrations.
Scope and Notes
- Use this skill for raw SQL, indexing, and migration strategy.
- Verify query advice with
EXPLAIN/actual plans on the target database; optimizer behavior differs across PostgreSQL, MySQL, Oracle, and others. - For ORM-specific issues, prefer
spring-boot-engineer→references/data.md.
When to Use
- Writing SQL queries or migrations
- Reviewing database schema design
- Optimizing slow queries
Flyway Migrations
Related skills
More from jetbrains/junie-extensions
java-engineer
Java 21 language features, idioms, and coding standards. Use when writing Java code involving records, sealed classes, virtual threads, streams, or generics.
1redis-best-practices
Redis development best practices for caching, data structures, and high-performance key-value operations
1spring-boot-engineer
Generates Spring Boot 3.x configurations, creates REST controllers, implements Spring Security 6 authentication flows, sets up Spring Data JPA repositories, configures reactive WebFlux endpoints, and applies Resilience4j fault-tolerance patterns. Use when building Spring Boot 3.x applications, microservices, or reactive Java/Kotlin applications.
1