What is gram.y and why is it important?

gram.y is the primary Bison/Yacc grammar file in the PostgreSQL source code. It defines the definitive syntax for all SQL statements that PostgreSQL can parse.

Is this useful for Go developers using pg_query_go?

Absolutely. Since pg_query_go wraps the actual Postgres parser, understanding the grammar rules in gram.y allows you to navigate the resulting JSON parse tree effectively.

Does it help with parsing third-party SQL?

While focused on core PostgreSQL, it provides the methodology to trace how any SQL construct is transformed into a parse tree, which is essential for building parsers.

How does this skill assist with DDL generation?

It provides the exact ordering and optional components of statements like CREATE TABLE or ALTER INDEX, ensuring that your generated SQL is always valid.

Can this skill identify reserved keywords?

Yes, it guides you to reference keywords.c to determine if an identifier is a reserved keyword that must be quoted in your DDL.

PostgreSQL Syntax & Grammar Reference

Name: PostgreSQL Syntax & Grammar Reference
Author: Activer007

byActiver007

0•

데이터베이스 관리

Consults PostgreSQL's internal parser and grammar rules to provide precise guidance on SQL syntax and DDL structure.

This skill provides an expert-level bridge between the PostgreSQL source code and practical SQL tool development. By referencing the internal Bison/Yacc grammar (gram.y) and lexical scanner (scan.l), it helps developers understand the exact structure of DDL statements, operator precedence, and keyword classification. It is particularly useful for those building schema management tools, SQL parsers, or migration engines that require 100% compatibility with PostgreSQL's native parsing logic.

주요 기능

01Mapping of SQL statements to internal PostgreSQL production rules

02Detailed analysis of complex constructs like triggers and expression indexes

03Reserved and unreserved keyword identification for identifier quoting

04Workflow guidance for implementing SQL parsers and schema diffing logic

05Interpretation of Yacc/Bison grammar syntax for DDL statements

060 GitHub stars

사용 사례

01Generating valid DDL for complex PostgreSQL features like identity columns or constraint triggers

02Implementing custom SQL parsing in Go using pg_query_go and libpg_query

03Debugging syntax errors in automated schema migration and comparison tools

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add activer007/ordinary-claude-skills postgresql-syntax-reference

For use in Claude.ai and ChatGPT

Download Skill