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.
