Can it help me choose the right data types?

Absolutely. It includes a quick reference guide recommending modern types like bigint over int, text over varchar(255), and timestamptz for global applications.

How does this skill help with database performance?

It provides specific indexing recommendations for different query patterns, identifies unindexed foreign keys, and offers templates for efficient cursor-based pagination.

Does it include security best practices?

Yes, it covers RLS policy optimization, security default configurations, and scripts to revoke public access from schemas for hardened security.

Is this skill compatible with Supabase?

Yes, the patterns are specifically modeled after Supabase best practices, including high-performance Row-Level Security (RLS) policies and modern schema design.

PostgreSQL Patterns & Best Practices

Name: PostgreSQL Patterns & Best Practices
Author: Nixdorfer

byNixdorfer

•

Database Management

Optimizes PostgreSQL database architecture, indexing, and security using Supabase-inspired best practices.

This skill provides a comprehensive set of design patterns and optimization strategies for PostgreSQL, drawing from industry-leading best practices. It assists developers in designing efficient schemas, implementing high-performance indexing strategies, securing data with Row-Level Security (RLS), and troubleshooting performance bottlenecks. Whether you're setting up a new database, writing complex migrations, or tuning slow queries, this tool offers immediate access to proven SQL patterns, correct data type usage, and anti-pattern detection scripts to ensure a robust and scalable database environment.

Key Features

01Standardized Data Type and System Configuration templates

02Performance Anti-Pattern Detection for unindexed keys and query bloat

03High-Performance Pagination and Queue Processing logic

041 GitHub stars

05Advanced Indexing Strategies including GIN, BRIN, Compound, and Partial indexes

06Row-Level Security (RLS) Optimization for secure data access

Use Cases

01Designing scalable database schemas for production-grade applications

02Implementing secure multi-tenant access using optimized Row-Level Security

03Refactoring slow SQL queries and identifying missing indexes in existing tables

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add nixdorfer/claudecodetool postgres-patterns

For use in Claude.ai and ChatGPT

Download Skill