How do I use this during code reviews?

You can ask Claude to review your SQL migrations or repository code against the skill's category-based rules to identify potential performance bottlenecks or security risks.

Can this help with Supabase-specific configurations?

Yes, it includes specialized guidance for Supabase environments, including Row-Level Security (RLS) and connection pooling via PgBouncer or Supavisor.

How does this skill improve query performance?

It analyzes your SQL against optimized patterns, recommending specific index types and query restructuring to reduce execution time and resource consumption.

Does it help with database locking issues?

Yes, it includes a specific priority category for concurrency and locking to help diagnose, prevent, and resolve complex deadlocks.

Does it support complex schema design?

Absolutely, it provides rules for data access patterns and schema design to ensure your database scales efficiently as your data volume increases.

PostgreSQL Best Practices

Name: PostgreSQL Best Practices
Author: bbaktaeho

bybbaktaeho

0•

Database Management

Optimizes PostgreSQL performance and security using expert-level guidelines for schema design, indexing, and query execution.

This skill integrates Supabase's comprehensive PostgreSQL optimization guidelines directly into Claude, enabling high-performance database management and architectural design. It provides specialized rules across eight categories, including query performance, connection pooling, Row-Level Security (RLS), and locking mechanisms. By applying these standards, developers can prevent common bottlenecks, secure their data access layers, and ensure their database remains scalable and maintainable as it grows.

Key Features

01Detailed guidance for implementing effective partial and missing indexes

02Automated SQL query plan analysis and optimization suggestions

03Security auditing for Row-Level Security (RLS) policies

040 GitHub stars

05Best practices for connection management and pooling configurations

06Diagnostic support for identifying and resolving database locks and deadlocks

Use Cases

01Optimizing database migrations to ensure zero-downtime schema changes

02Refactoring slow-running SQL queries to improve application responsiveness

03Designing secure multitenant database architectures using RLS

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add bbaktaeho/bbaktaeho-agent-skills postgres-best-practices

For use in Claude.ai and ChatGPT

Key Features

01Detailed guidance for implementing effective partial and missing indexes

02Automated SQL query plan analysis and optimization suggestions

03Security auditing for Row-Level Security (RLS) policies

040 GitHub stars

05Best practices for connection management and pooling configurations

06Diagnostic support for identifying and resolving database locks and deadlocks

Use Cases

01Optimizing database migrations to ensure zero-downtime schema changes

02Refactoring slow-running SQL queries to improve application responsiveness

03Designing secure multitenant database architectures using RLS

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add bbaktaeho/bbaktaeho-agent-skills postgres-best-practices

For use in Claude.ai and ChatGPT