sbdchd/squawk

View on GitHub

🐘 Linter for Postgres migrations & SQL

Stars: 1.2k
Forks: 70
Open beginner issues: 0
Indexed issues: 41
Avg merge: 52m
Merged PRs (30d): 47

Dominant language: Rust
License: Apache-2.0
Last GitHub push: Sep 19, 2026
Latest indexed: Sep 20, 2026
Contributing guide: Contributing guide
Code of conduct: No code of conduct
Beginner labels: No beginner labels indexed

Beginner friendly Everything

Open All

41 open issues indexed

New rule: Dropping a foreign key constraint requires an access exclusive lock on the referenced table. Open

enhancement

Difficulty 4/5 3-5 days Newbie friendliness 48/100

sbdchd/squawk#1294 · 1 comment · Opened Aug 19, 2026
Enforcing RequireTableSchema for SELECT, INSERT, UPDATE, DELETE? Open

enhancement

Difficulty 3/5 1-2 days Newbie friendliness 58/100

sbdchd/squawk#1278 · 2 comments · Opened Aug 11, 2026
New Rule: Block "multiple assignments to same column" for UPDATE statement Open

enhancement

Difficulty 3/5 1-2 days Newbie friendliness 56/100

sbdchd/squawk#1261 · 2 comments · Opened Jul 28, 2026
CREATE INDEX CONCURRENTLY IF NOT EXISTS could be invalid Open

Difficulty 4/5 3-5 days Newbie friendliness 35/100

sbdchd/squawk#1230 · 2 comments · Opened Jul 8, 2026
New rule: do something about the workarounds to "no subqueries in check constraints" Open

enhancement

Difficulty 5/5 Over a week Newbie friendliness 35/100

sbdchd/squawk#1228 · 1 comment · Opened Jul 7, 2026
New rule: check constraints can not have subqueries Open

enhancement

Difficulty 3/5 1-2 days Newbie friendliness 58/100

sbdchd/squawk#1226 · Opened Jul 4, 2026
Configure trusted publishing for Cargo Open

enhancement

Difficulty 3/5 1-2 days Newbie friendliness 48/100

sbdchd/squawk#1166 · Opened May 23, 2026
New rule: warn when ON DELETE SET NULL targets a NOT NULL column Open

enhancement

Difficulty 4/5 3-5 days Newbie friendliness 55/100

sbdchd/squawk#1136 · 1 reaction · Opened May 13, 2026
adding-foreign-key-constraint shouldn't warn if the constraint and tables are created in the same transaction Open

enhancement

Difficulty 3/5 1-2 days Newbie friendliness 45/100

sbdchd/squawk#973 · 1 comment · Opened Feb 27, 2026
Suggested solution for adding-not-nullable-field is a breaking change Open

enhancement

Difficulty 5/5 Over a week Newbie friendliness 28/100

sbdchd/squawk#937 · 3 comments · 2 reactions · Opened Feb 18, 2026
Vendored OpenSSL Open

enhancement

Difficulty 4/5 3-5 days Newbie friendliness 45/100

sbdchd/squawk#905 · Opened Feb 1, 2026
Check optimal column order Open

enhancement

Difficulty 4/5 3-5 days Newbie friendliness 42/100

sbdchd/squawk#860 · 2 comments · Opened Jan 18, 2026
Include per rule documentation website links to github comments Open

enhancement

Difficulty 3/5 1-2 days Newbie friendliness 52/100

sbdchd/squawk#717 · 1 comment · Opened Dec 2, 2025
ERROR: access method "hash" does not support unique indexes Open

enhancement

Difficulty 3/5 1-2 days Newbie friendliness 45/100

sbdchd/squawk#706 · 1 comment · Opened Nov 13, 2025
atlas conflict with ban-concurrent-index-creation-in-transaction Open

question

Difficulty 3/5 1-2 days Newbie friendliness 35/100

sbdchd/squawk#705 · 6 comments · Opened Nov 12, 2025
Improvement : ability to split DDL in the same file without triggering warnings Open

enhancement

Difficulty 4/5 3-5 days Newbie friendliness 35/100

sbdchd/squawk#703 · 2 comments · Opened Nov 11, 2025
VSCode Extension shows errors ignored by the config file. Open

bug

Difficulty 3/5 1-2 days Newbie friendliness 48/100

sbdchd/squawk#679 · 2 comments · 2 reactions · Opened Oct 8, 2025
Allow opt-in configuration to invert `require-timeout-settings` Open

enhancement

Difficulty 3/5 1-2 days Newbie friendliness 45/100

sbdchd/squawk#678 · 2 comments · Opened Oct 6, 2025
Flag unused ignores with a warning Open

enhancement

Difficulty 3/5 1-2 days Newbie friendliness 35/100

sbdchd/squawk#648 · 1 comment · Opened Sep 15, 2025
Add `--filenames-only` argument to cli Open

question

Difficulty 2/5 1-3 hours Newbie friendliness 48/100

sbdchd/squawk#627 · 2 comments · Opened Aug 25, 2025
allow specific tables to be ignored Open

enhancement

Difficulty 3/5 1-2 days Newbie friendliness 35/100

sbdchd/squawk#625 · 2 comments · Opened Aug 24, 2025
Fails to detect ACCESS EXCLUSIVE lock risk when DDL is inside DO $$...$$; PL/pgSQL block Open

enhancement

Difficulty 4/5 3-5 days Newbie friendliness 35/100

sbdchd/squawk#528 · 1 comment · Opened Jun 3, 2025
Squawk Not Detecting Errors in PostgreSQL Function Body Open

enhancement

Difficulty 4/5 3-5 days Newbie friendliness 35/100

sbdchd/squawk#411 · 2 comments · Opened Feb 18, 2025
Add option to not warn about int references to existing int columns Open

enhancement

Difficulty 4/5 3-5 days Newbie friendliness 35/100

sbdchd/squawk#407 · Opened Jan 17, 2025
Failed to find files for provided patterns with pre-commit Open

bug

Difficulty 2/5 1-3 hours Newbie friendliness 52/100

sbdchd/squawk#363 · 5 comments · 1 reaction · Opened Jun 28, 2024
Is require-concurrent-index-creation necessary straight after table creation? Open

enhancement

Difficulty 4/5 3-5 days Newbie friendliness 35/100

sbdchd/squawk#349 · 5 comments · 2 reactions · Opened May 24, 2024
Exit code 1 for warnings (warning vs error handling) Open

enhancement

Difficulty 4/5 3-5 days Newbie friendliness 42/100

sbdchd/squawk#348 · 2 comments · 1 reaction · Opened May 22, 2024
Squawk ignores excludes in the config file when excludes are passed on the cli Open

enhancement

Difficulty 3/5 1-2 days Newbie friendliness 35/100

sbdchd/squawk#344 · Opened Mar 13, 2024
Warn about unindexed foreign key constraints. Open

enhancement

Difficulty 5/5 Over a week Newbie friendliness 25/100

sbdchd/squawk#334 · 1 comment · 3 reactions · Opened Dec 22, 2023
Assume in transaction still warns about concurrent index creation Open

Difficulty 3/5 1-2 days Newbie friendliness 45/100

sbdchd/squawk#331 · 3 comments · 3 reactions · Opened Dec 21, 2023
Only warn once about error in GitHub per statement Open

enhancement

Difficulty 3/5 1-2 days Newbie friendliness 35/100

sbdchd/squawk#319 · Opened Sep 23, 2023
Search for specified delimeter to split transactions Open

enhancement

Difficulty 4/5 3-5 days Newbie friendliness 35/100

sbdchd/squawk#317 · 3 comments · Opened Sep 15, 2023
Allow to exclude all rules that break clients Open

enhancement

Difficulty 4/5 3-5 days Newbie friendliness 35/100

sbdchd/squawk#316 · 2 comments · 1 reaction · Opened Sep 15, 2023
calling `validate` in a transaction with `not valid` should be an error Open

enhancement

Difficulty 3/5 1-2 days Newbie friendliness 42/100

sbdchd/squawk#250 · Opened Aug 24, 2022
`adding-foreign-key-constraint` shouldn't warn about foreign keys when creating table Open

Difficulty 3/5 1-2 days Newbie friendliness 45/100

sbdchd/squawk#220 · 3 comments · 1 reaction · Opened Jun 22, 2022
Support for automatically fixing errors. Open

enhancement

Difficulty 5/5 Over a week Newbie friendliness 28/100

sbdchd/squawk#204 · 2 comments · 1 reaction · Opened Apr 27, 2022
Display row counts, table size, etc in output messages Open

enhancement

Difficulty 5/5 Over a week Newbie friendliness 25/100

sbdchd/squawk#197 · 3 comments · Opened Apr 5, 2022
Apply linter only on migrations after specific version Open

enhancement

Difficulty 3/5 1-2 days Newbie friendliness 38/100

sbdchd/squawk#191 · 2 comments · 3 reactions · Opened Mar 25, 2022
improve docs around creating a foreign key constraint Open

Difficulty 2/5 1-3 hours Newbie friendliness 45/100

sbdchd/squawk#150 · Opened Jun 17, 2021
warn about UPDATE or SELECT after ALTER TABLE within a transaction Open

enhancement

Difficulty 4/5 3-5 days Newbie friendliness 35/100

sbdchd/squawk#123 · Opened Apr 19, 2021
Display detailed explanation about tables affected by statement Open

enhancement

Difficulty 4/5 3-5 days Newbie friendliness 35/100

sbdchd/squawk#116 · 2 reactions · Opened Apr 18, 2021

sbdchd/squawk

Get new issues in your inbox