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

•

数据库管理

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

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.

主要功能

01Deep analysis of gram.y Bison grammar production rules

02Guidance on complex constructs like functional indexes and constraint triggers

03Precedence and operator rule validation for complex expressions

04Mapping of SQL statements to internal C transformation functions

05Identification of reserved, non-reserved, and type-specific keywords

0681 GitHub stars

使用场景

01Debugging syntax errors in programmatically generated DDL statements

02Implementing custom SQL parsers or schema migration engines like pgschema

03Understanding the underlying parse tree structure for use with pg_query_go

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