--- title: New Postgres Language Server: postgres-lsp | daily.dev description: postgres-lsp is a new Language Server Protocol implementation for PostgreSQL SQL and PL/pgSQL, built on tree-sitter-postgres. It brings IDE-grade features to... canonical: https://daily.dev/posts/new-postgres-language-server-postgres-lsp-yok0fzzyu twitter:card: summary_large_image twitter:site: @dailydotdev og:type: website og:site_name: daily.dev og:title: New Postgres Language Server: postgres-lsp | daily.dev og:description: postgres-lsp is a new Language Server Protocol implementation for PostgreSQL SQL and PL/pgSQL, built on tree-sitter-postgres. It brings IDE-grade features to... og:url: https://daily.dev/posts/new-postgres-language-server-postgres-lsp-yok0fzzyu og:image: https://api.daily.dev/og/posts/yoK0fzzyU.png og:image:alt: New Postgres Language Server: postgres-lsp og:image:width: 1200 og:image:height: 630 og:locale: en --- > ## Documentation Index > Fetch the complete documentation index at: https://daily.dev/llms.txt > Use this file to discover all available pages before exploring further. # New Postgres Language Server: postgres-lsp **[PostgreSQL](https://daily.dev/sources/postgres)** · 2 min read · 46 upvotes · 3 comments ## Summary postgres-lsp is a new Language Server Protocol implementation for PostgreSQL SQL and PL/pgSQL, built on tree-sitter-postgres. It brings IDE-grade features to .sql files including diagnostics, semantic tokens, go-to-definition, find references, context-aware completion, signature help, rename refactoring, code actions, and SQL formatting with multiple style presets (river, mozilla, dbt, gitlab, etc.). All parsing is backed by real PostgreSQL grammar rather than regex heuristics. ## Full article daily.dev links to this article rather than hosting it. Read it at the original source: ## Community discussion Top comments from developers on daily.dev. **@abdelfattahradwan** · 14 upvotes > Yeah, I don't know about this one. It seems to be completely AI-generated. Almost all commits have Claude as a co-author. The ones that don't are merge commits, which are probably just AI work being merged... Also, there are zero tests. I am not a testing fanatic, but when your work is mostly AI, it helps raise the almost zero confidence people have in such work. I hope the official PostgreSQL website starts vetting these announcements so we are not fed slop that looks legit. **@hdnelson2024** · 3 upvotes > Buena información y excelente herramienta ## Similar posts on daily.dev - [Explainer: Tree-sitter vs. LSP](https://daily.dev/posts/explainer-tree-sitter-vs-lsp-yhbughb6b) · Hacker News · 0 upvotes · 0 comments - [Announcing Symfony Language Tools, the Official Symfony LSP Server \(Symfony Blog\)](https://daily.dev/posts/announcing-symfony-language-tools-the-official-symfony-lsp-server-symfony-blog--ni87i9xqz) · Symfony · 4 upvotes · 0 comments --- Tags: [#sql](https://daily.dev/tags/sql), [#postgresql](https://daily.dev/tags/postgresql) [View this post on daily.dev](https://daily.dev/posts/new-postgres-language-server-postgres-lsp-yok0fzzyu) ```json {"@context":"https://schema.org","@graph":[{"@type":"Organization","@id":"https://daily.dev/#organization","name":"daily.dev","url":"https://daily.dev","logo":{"@type":"ImageObject","url":"https://daily.dev/apple-touch-icon.png","width":180,"height":180},"sameAs":["https://twitter.com/dailydotdev","https://github.com/dailydotdev","https://www.linkedin.com/company/daily-dev-ltd"]},{"@type":"WebSite","@id":"https://daily.dev/#website","url":"https://daily.dev","name":"daily.dev","publisher":{"@id":"https://daily.dev/#organization"},"potentialAction":{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https://daily.dev/search?q={search_term_string}"},"query-input":"required name=search_term_string"}}]} {"@context":"https://schema.org","@type":"TechArticle","headline":"New Postgres Language Server: postgres-lsp","url":"https://daily.dev/posts/new-postgres-language-server-postgres-lsp-yok0fzzyu","mainEntityOfPage":{"@type":"WebPage","@id":"https://daily.dev/posts/new-postgres-language-server-postgres-lsp-yok0fzzyu"},"datePublished":"2026-06-21T13:25:13.011Z","dateModified":"2026-06-21T13:25:28.890Z","description":"postgres-lsp is a new Language Server Protocol implementation for PostgreSQL SQL and PL/pgSQL, built on tree-sitter-postgres. It brings IDE-grade features to...","image":"https://media.daily.dev/image/upload/s--VDukGCjf--/f_auto/v1722860399/public/Placeholder%2002","thumbnailUrl":"https://media.daily.dev/image/upload/s--VDukGCjf--/f_auto/v1722860399/public/Placeholder%2002","isAccessibleForFree":true,"articleSection":"PostgreSQL","inLanguage":"en","publisher":{"@type":"Organization","name":"daily.dev","url":"https://daily.dev","logo":{"@type":"ImageObject","url":"https://daily.dev/apple-touch-icon.png","width":180,"height":180}},"author":{"@type":"Organization","name":"PostgreSQL","logo":"https://media.daily.dev/image/upload/t_logo,f_auto/v1/logos/8dab534748a94108858df41b7ef7fe86","url":"https://daily.dev/sources/postgres"},"commentCount":3,"discussionUrl":"https://daily.dev/posts/new-postgres-language-server-postgres-lsp-yok0fzzyu","interactionStatistic":[{"@type":"InteractionCounter","interactionType":{"@type":"LikeAction"},"userInteractionCount":46},{"@type":"InteractionCounter","interactionType":{"@type":"CommentAction"},"userInteractionCount":3}],"keywords":"sql,postgresql","timeRequired":"PT2M"} {"@context":"https://schema.org","@type":"BreadcrumbList","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https://daily.dev"},{"@type":"ListItem","position":2,"name":"PostgreSQL","item":"https://daily.dev/sources/postgres"},{"@type":"ListItem","position":3,"name":"New Postgres Language Server: postgres-lsp"}]} {"@context":"https://schema.org","@type":"WebPage","@id":"https://daily.dev/posts/new-postgres-language-server-postgres-lsp-yok0fzzyu","comment":[{"@type":"Comment","text":"Yeah, I don’t know about this one. It seems to be completely AI-generated. Almost all commits have Claude as a co-author. The ones that don’t are merge commits, which are probably just AI work being merged… Also, there are zero tests. I am not a testing fanatic, but when your work is mostly AI, it helps raise the almost zero confidence people have in such work. I hope the official PostgreSQL website starts vetting these announcements so we are not fed slop that looks legit.","datePublished":"2026-06-21T15:59:42.940Z","url":"https://daily.dev/posts/yoK0fzzyU#c-T6onucko9","author":{"@type":"Person","name":"Abdelfattah Radwan","url":"https://daily.dev/abdelfattahradwan","image":"https://media.daily.dev/image/upload/s--Zf0i8E2O--/f_auto/v1719427053/avatars/avatar_goLsd8jwvwG92WvRIqOvu"},"interactionStatistic":{"@type":"InteractionCounter","interactionType":{"@type":"LikeAction"},"userInteractionCount":14}},{"@type":"Comment","text":"Buena información y excelente herramienta","datePublished":"2026-06-22T13:18:07.078Z","url":"https://daily.dev/posts/yoK0fzzyU#c-1ajl76HyW","author":{"@type":"Person","name":"Nelson Herrera Diaz","url":"https://daily.dev/hdnelson2024","image":"https://lh3.googleusercontent.com/a/ACg8ocKBbRj88TYlOaJ4kRFbdoL0_hVu8B7CsygaLZTYDOGF4ONVmw=s96-c"},"interactionStatistic":{"@type":"InteractionCounter","interactionType":{"@type":"LikeAction"},"userInteractionCount":3}}]} ```