Does this skill support specific PostgreSQL versions?

It is designed for modern PostgreSQL versions and follows universal best practices applicable to standard PostgreSQL and Supabase environments.

How does it handle naming conventions?

It enforces snake_case for all identifiers, plural names for tables, and specific prefixes like 'is_' or 'has_' for boolean columns for maximum clarity.

Does it assist with query optimization?

While primarily focused on style and readability, it encourages patterns like CTEs and explicit joins which lead to more maintainable and often more performant queries.

Is this skill compatible with Supabase?

Yes, it is highly compatible with Supabase development, emphasizing schema prefixes and modern data types like UUIDs and TIMESTAMPTZ.

Postgres SQL Style Guide

Name: Postgres SQL Style Guide
Author: linehaul-ai

bylinehaul-ai

•

Database Management

Standardizes PostgreSQL development with comprehensive rules for naming conventions, schema design, and query formatting.

This skill provides Claude with a rigorous set of standards for writing high-quality PostgreSQL code. It covers everything from naming conventions—such as using snake_case and plural table names—to complex query structures using Common Table Expressions (CTEs). By enforcing consistent patterns like ISO 8601 date formats, explicit schema prefixes, and mandatory audit columns, it ensures that database schemas remain maintainable, readable, and performant throughout the application lifecycle. It is particularly useful for teams using Supabase or standard PostgreSQL who want to maintain a unified code style across their migrations and queries.

Key Features

01Standardized naming conventions for tables, columns, and custom enum types

02Best practices for code readability using lowercase reserved words and indentation

03Guidance on data types, including text over varchar and numeric for currency

04Formatting patterns for complex queries and Common Table Expressions (CTEs)

05Strict rules for primary keys, foreign keys, and mandatory audit columns

061 GitHub stars

Use Cases

01Generating new database migrations or schema definitions from scratch

02Refactoring existing SQL queries to improve readability and maintainability

03Automating code reviews for PostgreSQL logic to ensure style compliance

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add linehaul-ai/linehaulai-claude-marketplace postgres-style-guide

For use in Claude.ai and ChatGPT

Download Skill