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

•

Database Management

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.

Key Features

01Explains operator precedence and complex expression parsing rules

02Provides implementation patterns for pgschema and Go-based SQL parsing

0381 GitHub stars

04Identifies reserved vs. unreserved keywords to ensure correct identifier quoting

05Decodes Yacc/Bison grammar patterns for optional elements, lists, and alternatives

06Maps SQL statements to specific gram.y production rules and C transformation functions

Use Cases

01Developing database migration engines or schema diffing tools like pgschema

02Debugging syntax errors and parsing issues when using tools like pg_query_go

03Generating valid DDL for complex objects such as constraint triggers and expression indexes

What are Skills?·How to Install

Install with 🐟 Skill.Fish

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

For use in Claude.ai and ChatGPT

Download Skill