supabase-community/postgres-language-server
Postgres Language Server
This project is a Language Server Protocol implementation for PostgreSQL that provides autocompletion, syntax diagnostics, and type checking for SQL and PL/pgSQL. It functions as a database schema validator and a static analysis engine designed to detect security vulnerabilities, performance bottlenecks, and dangerous migration patterns in database scripts.
The server differentiates itself by using live database connections to provide schema-aware intelligence, allowing it to verify that tables, columns, and data types actually exist. It performs static analysis on procedural functions to detect type mismatches, unused variables, and injection vulnerabilities, and utilizes explain-based insights to validate syntax and types.
Broad capability areas include IDE integration for context-aware identifier suggestions and object inspection, as well as CLI tooling for automating migration linting within CI pipelines. The toolset also covers database performance analysis to identify inefficient indexing and table bloat, and provides SQL code formatting to standardize script layouts.
Connection strings and project behavior are managed through environment variables and project-specific configuration files.
Features
- Language Server Integrations - Implements the Language Server Protocol to provide IDE-agnostic code intelligence for PostgreSQL.
- Language Servers - Provides a full Language Server Protocol implementation for PostgreSQL SQL and PL/pgSQL with diagnostics and type checking.
- Database Schema Linting - Scans schema change files in CI pipelines to detect dangerous operations or syntax errors before deployment.
- SQL Static - Validates column and table types by analyzing execution plans to find runtime errors before execution.
- Database Connectivity - Establishes live connections to a Postgres instance to provide real-time schema intelligence.
- Schema Object Inspection - Displays detailed schema information, such as data types and parameters, when hovering over objects.
- PL/pgSQL Static Analysis - Analyzes procedural functions and stored procedures to find logic errors, type mismatches, and security vulnerabilities.
- Explain-Based Validation - Performs type checking through explain-based error insights to lint database schemas and migrations.
- LSP Integrations - Implements a standardized LSP interface to provide database-aware intelligence and formatting across compatible code editors.
- Schema-Aware Autocompletion - Provides real-time autocompletion for tables, columns, and functions based on the connected PostgreSQL schema.
- SQL Static Analyzers - Analyzes SQL scripts to detect security vulnerabilities, performance bottlenecks, and dangerous migration patterns.
- SQL Syntax Checking - Identifies syntax errors and provides diagnostics using a native database parser to ensure compatibility.
- Procedural Language Tooling - Applies language-aware tooling and diagnostics to procedural functions and stored procedures.
- Database Identifier Autocompletion - Provides real-time autocompletion for tables, columns, and functions based on the connected database.
- Procedural Language Diagnostics - Provides real-time language server diagnostics specifically for procedural database functions.
- SQL Intelligence Engines - Offers autocompletion, hover information, and syntax diagnostics using a native parser to ensure compatibility.
- Hover Information Displays - Displays detailed information about database objects when hovering over identifiers in the editor.
- Database Schema Validators - Checks SQL scripts against a running database to ensure tables, columns, and data types exist.
- Strongly-Typed Query Validation - Checks query validity using the database engine to ensure type correctness and object resolution.
- PL/pgSQL - Analyzes PL/pgSQL function bodies to detect type mismatches, unused variables, and injection vulnerabilities.
- SQL Schema Validators - Verifies that tables, columns, and data types exist by checking queries against a live database schema.
- Performance Analysis - Scans database schemas to identify inefficient indexes, missing primary keys, and table bloat.
- SQL Analysis and Linting - Scans scripts using rule sets to identify performance bottlenecks, dangerous migrations, and syntax anti-patterns.
- SQL Safety Analysis - Analyzes code to identify dangerous operations that cause table rewrites, long locks, or accidental data loss.
- SQL and Database Analysis - Scans SQL files and versioned changes for syntax and logic errors using database connection details.
- Security and Vulnerability Scanning - Identifies misconfigured security policies and exposed sensitive data within database scripts to prevent unauthorized access.
- SQL Query Editors - Provides an interactive environment for writing and refining SQL queries with real-time autocompletion.
- Procedural Logic Inspection - Analyzes procedural code using specialized extensions to identify logic errors and potential bugs.
- Editor Integrations - Integrates standardized SQL capabilities and syntax checks directly into various code editors.
- SQL Formatters - Standardizes the layout and style of SQL files to ensure consistent presentation.
- Database Schema Explorers - Inspects running databases to detect performance issues, security vulnerabilities, and configuration problems.
- In-Editor Statement Execution - Runs SQL statements directly from the code editor using context-aware actions.
