The server expects sqlfluff to be installed and added to the PATH. If that is not feasible, pass the absolute path via --sqlfluff-path flag, e.g. sqlfluff-lsp serve ...

Don't just test if it runs - automate so it lasts. Most data teams working with dbt already have some form of code verification in place. Usually, this involves a GitHub Action or a Jenkins pipeline ...