Postgres Language Server: Initial Release
Published on: 2025-05-23 09:13:43
Postgres Language Server
A collection of language tools and a Language Server Protocol (LSP) implementation for Postgres, focusing on developer experience and reliable SQL tooling.
Docs: pgtools.dev
Install: instructions
Overview
This project provides a toolchain for Postgres development, built on Postgres' own parser libpg_query to ensure 100% syntax compatibility. It is built on a Server-Client architecture with a transport-agnostic design. This means all features can be accessed not only through the Language Server Protocol, but also through other interfaces like a CLI, HTTP APIs, or a WebAssembly module. The goal is to make all the great Postgres tooling out there as accessible as possible, and to build anything that is missing ourselves.
The following features are implemented:
Autocompletion
Syntax Error Highlighting
Type-checking (via EXPLAIN error insights)
error insights) Linter, inspired by Squawk
Our current focus is on refining and enhancing these core features wh
... Read full article.