Can this skill help me fix slow database queries?

Yes, it includes an indexing cheat sheet and anti-pattern detection scripts to help identify missing indexes and optimize execution plans.

Does this skill provide security recommendations?

Absolutely. It includes patterns for optimized Row Level Security (RLS) and security-focused configuration templates like revoking public schema access.

Is this skill useful for managing JSON data in Postgres?

Yes, it provides specific indexing patterns for jsonb types using GIN indexes to ensure efficient querying of unstructured data.

What database platforms is this skill compatible with?

While it is specifically optimized for PostgreSQL and follows Supabase best practices, the patterns are applicable to any standard PostgreSQL environment.

Postgres Patterns

Name: Postgres Patterns
Author: Nixdorfer

byNixdorfer

•

Database Management

Optimizes PostgreSQL database schemas, queries, and security configurations using industry-proven patterns and Supabase best practices.

Postgres Patterns provides Claude with a comprehensive knowledge base for designing and maintaining high-performance PostgreSQL databases. It equips the AI with specialized guidance on indexing strategies (B-tree, GIN, BRIN), correct data type selection, and advanced SQL patterns like UPSERT, cursor pagination, and queue processing. This skill is essential for developers looking to implement robust Row Level Security (RLS), troubleshoot slow queries via performance monitoring tools, and avoid common anti-patterns like unindexed foreign keys or table bloat.

Key Features

01Optimized Row Level Security (RLS) policy implementation patterns

02Anti-pattern detection for identifying slow queries and table bloat

03Comprehensive indexing cheat sheet for optimized query execution

041 GitHub stars

05Best practice guides for data types and schema design

06Production-ready configuration templates for performance and security

Use Cases

01Designing high-performance database schemas and migration scripts

02Implementing secure, multi-tenant data access layers using RLS

03Troubleshooting and refactoring slow-running SQL queries

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