PostgreSQL Syntax Reference
OfficialMaster PostgreSQL grammar for reliable DDL.
Authorpgschema
Version1.0.0
Installs0
System Documentation
What problem does it solve?
PostgreSQL's parser and grammar are complex, and understanding gram.y and related parser code helps implement and validate DDL generation and SQL parsing in pgschema.
Core Features & Use Cases
- Provides a structured map of grammar rules (gram.y, parse utilities) to guide DDL generation and SQL interpretation.
- Serves as a reference for debugging, extending support across PostgreSQL versions 14-18, and aligning internal diff logic with actual parser behavior.
- Use cases include understanding CREATE/ALTER/DROP statement syntax, exploring tokenization, and validating SQL structures when implementing pgschema features.
Quick Start
Consult the grammar reference before implementing or reviewing SQL parsing logic to confirm syntax and token rules for your target DDL statements.
Dependency Matrix
Required Modules
None requiredComponents
Standard package💻 Claude Code Installation
Recommended: Let Claude install automatically. Simply copy and paste the text below to Claude Code.
Please help me install this Skill: Name: PostgreSQL Syntax Reference Download link: https://github.com/pgschema/pgschema/archive/main.zip#postgresql-syntax-reference Please download this .zip file, extract it, and install it in the .claude/skills/ directory.
Agent Skills Search Helper
Install a tiny helper to your Agent, search and equip skill from 471,000+ vetted skills library on demand.