postgres_lsp is a dedicated Language Server for Postgres, developed by the supabase community. It aims to enhance the developer experience by providing features such as code completion, syntax highlighting, linting, hover information, type checking, syntax error diagnostics, inlay hints, and various code actions. Unlike generic SQL Language Servers that treat Postgres syntax as a "flavor," postgres_lsp focuses exclusively on Postgres, leveraging the PostgreSQL source through the libpg_query library to parse SQL code reliably.
The project is actively being developed and is not yet ready for production use. It is designed to support Postgres SQL and PL/pgSQL function bodies, addressing the limitations of existing tools and IDEs that offer incomplete support for Postgres. Developers can contribute to the project by setting up the server for local development using tools like Cargo, Node, and npm, or by using GitHub CodeSpaces for a streamlined development environment.
The ultimate goal is to provide a robust and scalable data model that not only offers basic features like semantic highlighting and code completion but also serves as a comprehensive interface for the Postgres ecosystem's tooling.
Pricing
Pricing information is not available