Does it provide templates for triggers?

Yes, it includes standardized PL/pgSQL functions and triggers for automatically updating 'updated_at' columns on row modifications.

Does this skill work with existing databases?

Yes, the skill includes logic to audit existing schemas and respect established patterns before suggesting or applying new conventions.

What version of PostgreSQL does this skill support?

This skill is specifically optimized for PostgreSQL 15 and newer, utilizing modern features like identity columns and improved jsonb handling.

Why does it prefer timestamptz over timestamp?

Using timestamptz ensures timezone information is correctly handled and preserved, preventing ambiguous data interpretation when users connect from different timezones.

Why are plural table names recommended?

Plural table names (e.g., 'users' instead of 'user') are a common SQL convention and help avoid conflicts with reserved keywords like USER or ORDER.

PostgreSQL Conventions

Name: PostgreSQL Conventions
Author: jsamuelsen11

byjsamuelsen11

0•

Database Management

Enforces modern PostgreSQL best practices, naming conventions, and schema design patterns for robust database development.

This skill provides Claude with a comprehensive set of rules and best practices for PostgreSQL 15+ environments, focusing on schema architecture, data type selection, and indexing strategies. It ensures consistent snake_case naming, promotes the use of identity columns over legacy serial types, enforces the use of timestamptz for time-sensitive data, and provides standardized patterns for constraints and triggers. By integrating these conventions, developers can automate the creation of high-performance, maintainable, and standard-compliant database schemas while maintaining compatibility with existing project structures.

Key Features

01Best-practice data type selection including timestamptz and numeric for currency

02Promotion of modern PostgreSQL features like Identity Columns and JSONB

03Automated patterns for created_at and updated_at audit columns with triggers

040 GitHub stars

05Standardized snake_case naming for all identifiers and plural table names

06Enforcement of data integrity via explicit constraint naming (pk_, fk_, chk_)

Use Cases

01Scaffolding new PostgreSQL database schemas with production-grade defaults

02Reviewing and refactoring existing SQL code for performance and anti-patterns

03Standardizing database migrations and constraint naming across a development team

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add jsamuelsen11/claude-config postgres-conventions

For use in Claude.ai and ChatGPT

Download Skill