Does it cover PostgreSQL-specific extensions?

It covers all syntax defined in the core PostgreSQL source, including specialized triggers, indexing methods, and utility commands.

Can it help with schema migration tools?

Yes, it provides the exact syntax requirements and keyword ordering needed to generate valid DDL for automated migration and diffing tools.

How does this skill help with SQL parsing?

It references the actual PostgreSQL Bison grammar (gram.y) to explain exactly how SQL strings are tokenized and parsed into statement nodes.

Is it useful for pg_query_go developers?

Absolutely. It helps map the parse trees returned by libpg_query/pg_query_go back to the original grammar rules they were derived from.

Why use this instead of standard SQL documentation?

Standard docs describe the 'what', but this skill explains the 'how' by showing the underlying parser rules, precedence, and internal C transformation logic.

PostgreSQL Syntax Expert

Name: PostgreSQL Syntax Expert
Author: Microck

byMicrock

•

Database Management

Navigates PostgreSQL internal grammar and parser rules to help developers write precise DDL and implement robust SQL parsing logic.

About

The PostgreSQL Syntax Reference skill provides deep access to the core PostgreSQL grammar (gram.y) and parser implementation. It is designed for developers building schema migration tools, custom SQL parsers, or complex database integrations that require absolute syntax precision. By cross-referencing internal source files like scan.l and parse_utilcmd.c, this skill allows users to understand exactly how PostgreSQL interprets SQL constructs, handles keyword precedence, and processes DDL statements, ensuring that generated SQL is always valid and native to the engine.

Key Features

Deep analysis of gram.y Bison grammar production rules
Guidance on complex constructs like functional indexes and constraint triggers
Precedence and operator rule validation for complex expressions
Mapping of SQL statements to internal C transformation functions
Identification of reserved, non-reserved, and type-specific keywords
81 GitHub stars

Use Cases

Debugging syntax errors in programmatically generated DDL statements
Implementing custom SQL parsers or schema migration engines like pgschema
Understanding the underlying parse tree structure for use with pg_query_go

About

Key Features

Deep analysis of gram.y Bison grammar production rules
Guidance on complex constructs like functional indexes and constraint triggers
Precedence and operator rule validation for complex expressions
Mapping of SQL statements to internal C transformation functions
Identification of reserved, non-reserved, and type-specific keywords
81 GitHub stars

Use Cases

Debugging syntax errors in programmatically generated DDL statements
Implementing custom SQL parsers or schema migration engines like pgschema
Understanding the underlying parse tree structure for use with pg_query_go