Unfragile

pglast is a Python library that parses PostgreSQL SQL into an AST, and it is not among the candidate products; no candidate source shows it or a direct equivalent. The closest matches that do SQL parsing or PostgreSQL-related work are SQLFluff, a SQL linter with dialect support 7, and the Psycopg PostgreSQL adapter for Python 5, which does not parse SQL.

1
SQLFluffsqlfluff.comverified and signed
SQLFluff is a dialect-flexible SQL linter that finds style and syntax issues in SQL code 7.
Website Docs
+3 community tools built for it
for agents: linter · formatter · clickhouse
2
Psycopgpsycopg.orgwebsite read, tools not yet checked
Psycopg is a PostgreSQL adapter for Python that connects to PostgreSQL databases and runs queries 5.
Website Docs

Sources

5Psycopg - PostgreSQL adapter for Pythonpsycopg.org · read 2026-10-29
7SQLFluffsqlfluff.com · read 2026-10-29

For agents: the 10 actions behind this answer

postgresql-code-review · postgresql-code-review verified and signed
PostgreSQL-specific code review assistant focusing on PostgreSQL best practices, anti-patterns, and unique quality standards. Covers JSONB operations, array usage, custom types, schema design, function optimization, and PostgreSQL-exclusive security features like Row Level Security (RLS).
chdb-sql · chdb-sql verified and signed
Use when the user wants to run SQL — especially analytical SQL — on local files (parquet/csv/json), URLs, S3 paths, or remote databases (Postgres, MySQL, MongoDB, ClickHouse Cloud, Iceberg, Delta Lake) without setting up a server. Provides chDB — embedded ClickHouse SQL in Python with 1000+ function
· async-std website read, tools not yet checked
A Rust library for easy and understandable async programming
SQL · duckdb verified and signed
· Psycopg website read, tools not yet checked
Psycopg is the most popular PostgreSQL adapter for the Python programming language.
Manage alerts · Pydantic verified and signed
Configure SQL-based alerts that periodically run and notify channels when results match. Inspect alert history and current firing state.
linter · sqlfluff verified and signed
syntax · Pygments verified and signed
· SQLAlchemy website read, tools not yet checked
The Database Toolkit for Python
execute_query · Gel MCP Server found in code, not yet checked
Execute a query and return the result as JSON

Labels are the instruments' verdict and are never changed by ranking. Agents and robots get this same answer as JSON at /api/v1/find?q=…&answer=1 and through the MCP server.