Does it support complex objects like triggers and functions?

Absolutely. It provides detailed mappings for CREATE TRIGGER, CREATE FUNCTION, materialized views, and intricate index definitions.

Is this skill specific to the Go programming language?

While it includes examples for Go-based tools like pgschema, the underlying syntax and grammar knowledge applies to any language used for PostgreSQL development.

Can this skill help with database migrations?

Yes, it is specifically designed to help generate correct DDL for schema diffing and migration tools by following PostgreSQL's internal syntax requirements.

What is the primary source of truth for this skill?

This skill uses the official PostgreSQL source code, specifically the gram.y and parse_utilcmd.c files, as the definitive reference for syntax and parsing rules.

How does it handle SQL keywords?

It references keywords.c to identify which words are reserved or unreserved, helping you determine when identifiers must be quoted in generated SQL.

PostgreSQL Syntax Reference

Name: PostgreSQL Syntax Reference
Author: Microck

byMicrock

•

データベース管理

Consults PostgreSQL's internal grammar and parser source code to provide precise SQL syntax and DDL implementation guidance.

概要

This skill provides deep technical insights into PostgreSQL internals by referencing the core grammar files (gram.y) and parser implementation (parse_utilcmd.c). It is designed to help developers understand exactly how PostgreSQL interprets SQL constructs, making it an essential resource for building database migration tools, custom parsers, or complex schema management utilities. By mapping SQL statements to their underlying Bison/Yacc rules, it ensures high-fidelity DDL generation and accurate parsing of even the most obscure PostgreSQL extensions.

主な機能

Explains operator precedence and complex expression parsing rules
Provides implementation patterns for pgschema and Go-based SQL parsing
81 GitHub stars
Identifies reserved vs. unreserved keywords to ensure correct identifier quoting
Decodes Yacc/Bison grammar patterns for optional elements, lists, and alternatives
Maps SQL statements to specific gram.y production rules and C transformation functions

ユースケース

Developing database migration engines or schema diffing tools like pgschema
Debugging syntax errors and parsing issues when using tools like pg_query_go
Generating valid DDL for complex objects such as constraint triggers and expression indexes

概要

主な機能

Explains operator precedence and complex expression parsing rules
Provides implementation patterns for pgschema and Go-based SQL parsing
81 GitHub stars
Identifies reserved vs. unreserved keywords to ensure correct identifier quoting
Decodes Yacc/Bison grammar patterns for optional elements, lists, and alternatives
Maps SQL statements to specific gram.y production rules and C transformation functions

ユースケース

Developing database migration engines or schema diffing tools like pgschema
Debugging syntax errors and parsing issues when using tools like pg_query_go
Generating valid DDL for complex objects such as constraint triggers and expression indexes