pre-commit CI fails on hooks with 'local' dependencies

[alyssadai]

See https://results.pre-commit.ci/run/github/567874792/1704917018.maEjX3MAQWuRwegTX2LaDw for example.

One of the pre-commit hooks we have in this repo is docker-compose-check which checks for valid compose files by running docker compose config.

This works fine when pre-commit is run locally, but errors out in CI because docker compose can't be found.

One option would be to use the skip config option in the pre-commit-config.yaml to skip docker-compose-check in CI:
https://pre-commit.ci/#configuration-skip

• in theor,y it should be possible to install docker compose in a github runner, but pre-commit CI itself doesn't actually use a GH workflow

Other options:

• A no-longer-maintained pre-commit GH action: https://github.com/pre-commit/action
  • superseded by pre-commit.ci
  • cons: seems like there's little to no configurability? although from piecing together some of the git history (e.g., remove pushing behaviour pre-commit/action#164), it looks like it doesn't make automatic pushes to PRs at least, which I think is what we want
• pre-commit.ci lite action: https://pre-commit.ci/lite
  • cons: only provides auto-fixing of PRs, which we don't need (and I can't find documentation on turning this option off/whether that is possible)

Relevant open issues in pre-commit.ci:

• [feature request]: docker support pre-commit-ci/issues#11
• Support for manual dependency management for local repos, system or script entry-points pre-commit-ci/issues#13

We should also ensure autofix_prs is False in this repo https://pre-commit.ci/#configuration-autofix_prs.