Pgpm Sql Conventions

What it does

This skill ensures SQL queries adhere to PostgreSQL's naming and formatting conventions. It automatically applies consistent capitalization, uses underscores for multi-word identifiers, and enforces other best practices. The goal is improved readability, maintainability, and consistency across database schemas and scripts.

When to use it

• Generating new SQL code: Automatically format newly created tables, views, or stored procedures.
• Refactoring existing SQL: Standardize the formatting of legacy SQL codebases for better clarity.
• Collaborative development: Enforce consistent coding standards across a team working on PostgreSQL databases.
• Automated database deployments: Guarantee that deployment scripts adhere to established conventions.

Key capabilities

• Automatic capitalization of keywords and identifiers.
• Replacement of spaces with underscores in identifiers (e.g., first name becomes first_name).
• Enforcement of PostgreSQL naming conventions for objects.

Example prompts

• "Format this SQL query: SELECT * FROM First Name WHERE Last_Name = 'Smith'"
• "Generate a table creation statement for a table called 'Customer Details' adhering to PostgreSQL conventions."
• “Standardize the formatting of this SQL script.”

Tips & gotchas

This skill requires access to the SQL code being processed. It is most effective when integrated into an automated workflow or used as part of a larger development pipeline.