New Postgres Language Server: postgres-lsp

From: "Gavin M(dot) Roy via PostgreSQL Announce" <announce-noreply(at)postgresql(dot)org>
To: PostgreSQL Announce <pgsql-announce(at)lists(dot)postgresql(dot)org>
Subject: New Postgres Language Server: postgres-lsp
Date: 2026-06-21 13:24:09
Message-ID: 178204824963.766.4580228651132272271@wrigleys.postgresql.org
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-announce

Built on [tree-sitter-postgres](https://github.com/gmr/tree-sitter-postgres), [postgres-lsp](https://github.com/gmr/postgres-lsp) implements the [Language Server Protocol](https://en.wikipedia.org/wiki/Language_Server_Protocol) for PostgreSQL SQL and PL/pgSQL. Point your editor at it for `.sql` files and get diagnostics, navigation, completion, and formatting backed by real PostgreSQL grammar rather than regex heuristics.

## Features

- **Diagnostics** — Parse errors from tree-sitter reported as LSP diagnostics
- **Semantic Tokens** — Syntax highlighting via semantic token classification
- **Document Symbols** — Outline of DDL statements (tables, functions, views, etc.)
- **Workspace Symbols** — Search across all open files
- **Go to Definition** — Navigate to table, function, type, and column definitions
- **Find References** — Find all usages of a symbol across the workspace
- **Hover** — Show definition source on hover
- **Completion** — Context-aware completion for keywords, tables, columns, and functions
- **Signature Help** — Parameter hints for function calls
- **Folding Ranges** — Collapse multi-line statements
- **Rename** — Rename symbols across the workspace
- **Code Actions** — Quick fixes and refactor rewrites
- **Formatting** — Reformat SQL using the styles supported by [libpgfmt](https://github.com/gmr/libpgfmt): river, mozilla, aweber, dbt, gitlab, kickstarter, mattmc3, pg_dump
- **PL/pgSQL Support** — Parses PL/pgSQL function bodies with language injection

Binaries and Installation instructions are available @ [https://github.com/gmr/postgres-lsp](https://github.com/gmr/postgres-lsp).

Browse pgsql-announce by date

  From Date Subject
Next Message PGX, Inc. via PostgreSQL Announce 2026-06-25 11:54:56 PGX announces support for EOL versions of PostgreSQL
Previous Message Julien Rouhaud via PostgreSQL Announce 2026-06-20 19:40:49 HypoPG 1.4.3 is out!