How does this skill help with SQL performance?

It applies specific rules for missing indexes, partial indexing, and query refactoring to minimize execution time and reduce resource consumption.

What kind of schema advice does it provide?

It offers guidance on efficient indexing strategies, data types, and structural patterns that prevent common database locking and concurrency issues.

Is this skill only for Supabase users?

While maintained by Supabase, these best practices apply to any standard PostgreSQL environment, including general schema design, query optimization, and connection management.

Can it help with database security?

Yes, it includes specialized categories for Security and Row-Level Security (RLS) to ensure your data access patterns are both performant and secure.

Postgres Performance & Best Practices

Name: Postgres Performance & Best Practices
Author: claudiodearaujo

byclaudiodearaujo

•

Gestión de Bases de Datos

Optimizes PostgreSQL database performance and schema design using Supabase-vetted best practices and implementation patterns.

This skill provides a comprehensive set of performance-driven guidelines and implementation patterns for PostgreSQL, curated by the experts at Supabase. It helps developers automate the process of identifying inefficient queries, optimizing schema designs, and configuring robust Row-Level Security (RLS) policies. By referencing categorized rules prioritized by impact, this skill ensures your database is built for scale, security, and high-performance data access patterns, reducing the likelihood of production bottlenecks and connection issues.

Características Principales

011 GitHub stars

02Automated query performance analysis and optimization

03Expert schema design and indexing recommendations

04Comprehensive Row-Level Security (RLS) configuration rules

05Concurrency control and locking prevention patterns

06Connection pooling and scaling management strategies

Casos de Uso

01Auditing database security policies and RLS implementation

02Refactoring slow SQL queries for improved execution times

03Designing scalable database schemas for high-traffic applications

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