| 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).
| 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! |