libpg_query
C library that provides PostgreSQL's SQL parser and scanner as a standalone component for external tools.
What is libpg_query?
libpg_query is a C library that packages PostgreSQL's SQL parser and scanner as a standalone component. It allows external tools to parse PostgreSQL-compatible SQL queries and PL/pgSQL functions, returning the exact internal parse tree or tokenized output. This enables deep SQL analysis, formatting, linting, and tooling without requiring a running PostgreSQL server.
Developers building database tooling, SQL linters, query analyzers, syntax highlighters, or language servers that need accurate PostgreSQL SQL parsing. It's also used by projects that require query normalization or fingerprinting.
It provides the only way to get PostgreSQL's exact parser logic outside the server, ensuring full syntax compatibility. The library is battle-tested, supports multiple PostgreSQL versions, and serves as the foundation for many popular tools and language bindings.
Overview
C library for accessing the PostgreSQL parser outside of the server environment
Use Cases
Best For
- Building SQL linters and formatters for PostgreSQL
Related Projects
Found a gem we're missing?
Open-Awesome is built by the community, for the community. Submit a project, suggest an awesome list, or help improve the catalog on GitHub.
