SQL Patterns

SQL policy & pitfalls — query correctness, indexing strategy, safe migrations. Use when writing SQL, diagnosing slow queries, designing schemas, or reviewing Flyway/Liquibase migrations. Covers the traps LLMs miss by default: NOT IN with NULLs, function-on-column breaking indexes, OFFSET on large tables, NOT NULL column lock, CREATE INDEX blocking writes, immutable migrations.

jetbrains Updated 1.7k repo stars

File contents

jetbrains/junie-extensions commit e05299f55b

Frequently asked questions

npx get-skill add jetbrains/sql-patterns