The Postgres Language Server is an ongoing project that aims to enhance the developer experience for those using Postgres by providing code intelligence tools. While there are some generic SQL language servers available, they often fall short when it comes to the specific syntax and complexity of PostgreSQL. This Language Server is designed exclusively for Postgres and uses libpg_query to parse SQL code reliably. The project is still in active development and is seeking input from the community. Once complete, the language server will offer features such as semantic highlighting, code completion, and syntax error diagnostics. It is not ready for production use yet, but developers are encouraged to contribute to its development.
https://github.com/supabase/postgres_lsp