postgres-syntax

Reference PostgreSQL SQL syntax and DDL grammar rules.

1|Updated Nov 13, 2023
One-click install
npx skills add https://github.com/LeoTechPro/intTools --skill postgres-syntax
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: postgres-syntax
Source: https://github.com/LeoTechPro/intTools/tree/main/codex/assets/codex-home/skills/postgres-syntax
Command: npx skills add https://github.com/LeoTechPro/intTools --skill postgres-syntax

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes references (resource) components.

What problem does it solve?

This Skill provides a comprehensive reference for PostgreSQL's SQL syntax, DDL statement structure, and grammar rules, enabling accurate SQL parsing and generation.

Core Features & Use Cases

  • Syntax Reference: Detailed information on DDL statements like CREATE TABLE, ALTER TABLE, CREATE INDEX, etc.
  • Grammar Exploration: Understand the structure of PostgreSQL's grammar (gram.y) and parser implementation (parse_utilcmd.c).
  • Use Case: When implementing new SQL statement parsing in ir/go, use this Skill to understand the exact syntax for CREATE TRIGGER statements to ensure correct parsing and DDL generation.

Quick Start

Consult the postgres-syntax skill for the grammar rule of a PostgreSQL CREATE TABLE statement.

Frequently Asked Questions about postgres-syntax

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I find the exact PostgreSQL syntax for DDL statements like CREATE TABLE?

To find the exact PostgreSQL syntax for DDL statements like CREATE TABLE, this reference provides detailed grammar rules and statement structures to facilitate accurate SQL parsing and DDL generation.

How does the PostgreSQL grammar in gram.y define SQL statement structures?

The PostgreSQL grammar in gram.y defines SQL statement structures through parser implementation rules, which this syntax reference explores alongside parse_utilcmd.c to help you understand exact SQL constructs for accurate parsing.

Can I use this PostgreSQL syntax reference to implement CREATE TRIGGER parsing?

Yes, you can use this PostgreSQL syntax reference to implement CREATE TRIGGER parsing by providing the exact syntax rules needed to ensure correct parsing and DDL generation in your development tasks.

What is the best way to understand PostgreSQL DDL statement structure for accurate parsing?

The best way to understand PostgreSQL DDL statement structure for accurate parsing is to reference grammar rules from gram.y and parse_utilcmd.c, which this reference provides to support SQL parsing and DDL creation tasks.

Does this PostgreSQL syntax reference cover ALTER TABLE and CREATE INDEX grammar rules?

Yes, this PostgreSQL syntax reference covers ALTER TABLE and CREATE INDEX grammar rules, providing detailed information on DDL statement structures to facilitate accurate SQL parsing and DDL generation.