As it stands, we just use this make target, which works well enough:

# Only lint migrations after 172, since we can't change old ones, and# 172-forward lint without errors currently.LINTED_MIGRATIONS :=$(shell fd . 'data/db/proxy/migrations' \--extension sql \--max-depth 1 \--format {/} \--exec bash -c '[[ "{/}" > "0172" ]] && echo {}')# Lint db migrations. Note that the DB must be running for this check.db-lint: .make/db-lint.PHONY: db-lint.make/db-lint:$(LINTED_MIGRATIONS) | .makeif [["$?" ]];thenpostgrestools check$?fitouch .make/db-lint

Thanks for the feedback! Did you see this part in the docs?

For pre-commit hooks and when working locally, use --staged to only lint files that have been staged. In CI environments, you most likely want to use --changed to only lint files that have been changed compared to your vcs.defaultBranch configuration. If defaultBranch is not set in your postgrestools.jsonc, use --since=REF to specify the base branch to compare against.

Stil, I will test this on the weekend, because I am quite sure we don't care about timestamps and simply parse the number. So maybe there is just a bug here and your case should work.