How does this skill improve query performance?

It applies a set of prioritized rules to identify missing indexes, inefficient joins, and sub-optimal data access patterns, providing corrected SQL examples.

Does it help with database security?

Yes, it includes specific guidelines for implementing and auditing Row-Level Security (RLS) to ensure data privacy at the database level.

Is this skill useful for database migrations?

Absolutely, it provides schema design best practices that are essential when planning or reviewing database migrations to avoid future performance debt.

Can I use this with non-Supabase Postgres databases?

Yes, while maintained by Supabase, the core optimization rules and schema design principles apply to any standard PostgreSQL environment.

Postgres Best Practices

Name: Postgres Best Practices
Author: claudiodearaujo

byclaudiodearaujo

•

Database Management

Optimizes PostgreSQL performance, schema design, and security using Supabase-vetted standards and implementation patterns.

This skill provides a comprehensive suite of rules and guidelines for PostgreSQL optimization, drawing from Supabase's production experience. It assists developers in writing efficient SQL queries, designing robust database schemas, and implementing secure Row-Level Security (RLS) policies. By integrating these prioritized best practices directly into the development workflow, the skill helps prevent performance bottlenecks, improve connection management, and ensure data integrity across various database workloads, from small projects to enterprise-scale applications.

Key Features

01Best practices for efficient connection pooling and management

02Standardized patterns for secure Row-Level Security (RLS) implementation

031 GitHub stars

04Prioritized query performance optimization and index recommendations

05Guidance for high-performance schema design and data modeling

06Advanced diagnostics for resolving concurrency and locking issues

Use Cases

01Auditing existing database schemas for performance anti-patterns and missing indexes

02Optimizing complex SQL queries to reduce execution time and resource consumption

03Implementing secure multi-tenant data access using Postgres RLS policies

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add claudiodearaujo/sistema-de-narra-o-de-livro postgres-best-practices

For use in Claude.ai and ChatGPT

Download Skill