pkg.soopen package index

brew / rank 3530

Install postgres-language-server with Homebrew, Nix, scoop

Language Server for Postgres. Version 0.28.2 via Homebrew; verified 2026-10-14. Also installable with nix: nix profile install nixpkgs#postgres-language-server.

install

Additional install commands

macOS

Homebrewverified · 100%
brew install postgres-language-server

local Homebrew formula metadata

Linux

Nixverified · 92%
nix profile install nixpkgs#postgres-language-server

nixpkgs package indexes · pkgs/by-name/po/postgres-language-server/package.nix · source: api.github.com

Windows

Scoopverified · 92%
scoop install main/postgres-language-server

Scoop official bucket manifest trees · bucket/postgres-language-server.json · source: api.github.com

overview

Package summary

Language Server for Postgres

Commands and aliases

  • postgres-language-server
  • postgrestools

history

Project history and usage

Postgres Language Server is PostgreSQL-specific editor and command-line tooling focused on reliable SQL analysis and developer experience.

Project history

Postgres Language Server is developed in the Supabase Community organization as an MIT-licensed collection of PostgreSQL language tools. The project combines a transport-agnostic language server with a command-line interface, allowing the same analysis engine to serve editors and automated checks.

Adoption history

The official installation documentation supports package-manager, standalone-binary, and editor-managed installation. The IDE guide documents first-class LSP use in VS Code and Neovim, while the CLI supports CI-oriented reporters including GitHub, GitLab, JUnit, and JSON.

How it is used

Create `postgres-language-server.jsonc` in a project's root, commonly with the `init` command, then run the LSP proxy from a supported editor or use CLI checks against SQL files. Database-independent checks can run with `--skip-db`; database-aware analysis can use a configured connection.

Why package nerds care

The project packages PostgreSQL-aware syntax checking, linting, type checking, formatting, completion, and hover support behind both LSP and CLI interfaces. Its use of PostgreSQL's parser through libpg_query makes it especially interesting to developers who want SQL tooling aligned closely with PostgreSQL syntax rather than a generic SQL dialect.

Timeline

  • The project established a combined LSP and CLI architecture for PostgreSQL-aware development workflows.
  • By 2026: Official documentation covered editor integration, standalone installation, project configuration, and CI-friendly reporting.

Related projects

  • PostgreSQL defines the SQL dialect and database behavior targeted by the language server. Editor clients consume its Language Server Protocol interface, while CI systems can invoke the same checks through the command line.

security posture

No protected-tool coverage found yet

No matching local secret-handling manifest was found for postgres-language-server. Package metadata is still published here so future coverage has a stable package URL.

Install behavior

  • No Homebrew post-install hook is recorded in formula metadata.
  • Homebrew bottle metadata is available for 5 platform targets.
  • Installs with 1 runtime dependencies.
  • Build metadata lists 5 build dependencies.

Recommended review

Before unattended agent use, check whether the tool reads plaintext credentials, writes remote state, publishes artifacts, or shells out to plugins.

local files

Configuration and credential file locations

These source-backed paths show where this package keeps local settings or durable credentials. Automic Vault can use them as review targets for secret scanning, migration, and command approval.

Configuration files

Config paths the tool may read or write during local use.

Unix
<project-root>/postgres-language-server.jsonc
Windows
<project-root>\postgres-language-server.jsonc

executables

Installed executables

CommandKindExposureNote
postgres-language-servercliglobal executable
postgrestoolscliglobal executable

freshness

Version and freshness

These signals separate page generation age, package-manager activity, and upstream release comparison. Version lag is warned only when an evidence URL and comparable versions are present.

page generated2026-11-04
manager version0.28.2
manager updated2026-10-14
local dataok
upstreamcurrent
latest detected0.28.2

https://github.com/supabase-community/postgres-language-server

  • okNo freshness warnings were generated.

install metadata

Package metadata

Package keybrew:postgres-language-server
Version0.28.2
Package managerHomebrew
Package manager pagehttps://formulae.brew.sh/formula/postgres-language-server
Homepagehttps://pg-language-server.com/
Repositoryhttps://github.com/supabase-community/postgres-language-server
Upstream docshttps://pg-language-server.com/
LicenseMIT
Source archivehttps://github.com/supabase-community/postgres-language-server/archive/refs/tags/0.28.2.tar.gz
Last updated2026-10-14T09:02:58Z
Pulseupdated
Dependencieslibpg_query
Build dependenciesllvm, node, rust, tree-sitter, tree-sitter-cli
Bottleavailable (on arm64_golden_gate, arm64_linux, arm64_sequoia, arm64_tahoe, x86_64_linux)
Homebrew post-installnot defined
Servicenone declared

registry facts

Source database details

Source DatabaseHomebrew formula API
Taphomebrew/core
Full Namepostgres-language-server
Version Scheme0
Revision0
Head VersionHEAD
Bottle Stable Root URLhttps://ghcr.io/v2/homebrew/core
Deprecatedno
Disabledno
Keg Onlyno
URL Keys
  • head
  • stable

source database matches

Other package-manager records

Matches are pulled from external package-manager indexes and kept separate from local Automic Vault package links.

Nix95%

postgres-language-server

nix profile install nixpkgs#postgres-language-server
  • normalized package name match
  • Matched by: Postgres Language Server
nixpkgs package indexes · api.github.com · nixpkgs package indexes: pkgs/by-name/po/postgres-language-server/package.nix from https://api.github.com/repos/NixOS/nixpkgs/git/trees/master?recursive=1
Scoop95%

main/postgres-language-server

scoop install main/postgres-language-server
  • normalized package name match
  • Matched by: Postgres Language Server
Scoop official bucket manifest trees · api.github.com · Scoop official bucket manifest trees: bucket/postgres-language-server.json from https://api.github.com/repos/ScoopInstaller/Main/git/trees/master?recursive=1

source trail

Generated from repository data

This page is generated by av-web from the private package SQLite artifact built by scripts/generate-pkg-sqlite.py.

Used sources

  • Geiger risk classifier
  • cross-ecosystem install command graph
  • curated configuration and credential file locations
  • curated package history
  • external package-manager database matches
  • package relationship graph
  • package version freshness
  • package-page enrichment
  • pkg.so package database
  • pkgdb category and tag curation