PgSqlParserThe real PostgreSQL parser, for .NET

Parse, deparse, format, analyse and rewrite PostgreSQL SQL with the parser the server itself uses, through libpg_query.

Parse and deparse

Turn SQL into the PostgreSQL parse tree, walk it, edit it, and turn it back into SQL, plain or pretty printed.

Format SQL, replace constants with placeholders, and fingerprint queries so that the same query shape always gets the same id.

Classify statements, find the tables, columns and functions a query uses, and see which locks a statement takes.

Get the tokens of a query with their positions, and split a script into statements.

Parse function bodies and reach the SQL statements inside them.

Native libraries for Linux (glibc and musl), macOS and Windows on x64 and ARM64. Targets .NET 8 and later and is Native AOT compatible.

shell

dotnet add package pgsqlparser

csharp

using PgSqlParser;

var tree = Parser.Parse("SELECT id, name FROM users WHERE id = $1").GetValueOrThrow();
Console.WriteLine(tree.Stmts.Count);