supabase-postgres-best-practices
This skill provides a structured set of Postgres performance optimization rules and best practices maintained by Supabase. It guides developers in writing, reviewing, and optimizing SQL queries, schema designs, and database configurations.
Is supabase-postgres-best-practices safe to install?
Safe to install: our audit of supabase-postgres-best-practices's source files found 0 shell commands, 0 external URLs, file reads and writes (low risk). Every command and URL listed appears verbatim in the skill's source. The skill reads local reference files to provide optimization guidelines. It does not execute commands or make network requests.
How we audit skills: our security review methodology.
Who is this skill for?
Developers and database administrators working with Postgres and Supabase.
What can you do with it?
- Writing SQL queries
- Designing database schemas
- Implementing indexes
- Optimizing query performance
- Configuring connection pooling
- Implementing Row-Level Security
How good is this skill?
Quality score: 9/10. The skill provides clear, categorized documentation for Postgres optimization. It lacks automated execution capabilities, which limits its utility for direct database interaction but ensures safety.
What does the skill file contain?
# Supabase Postgres Best Practices Comprehensive performance optimization guide for Postgres, maintained by Supabase. Contains rules across 8 categories, prioritized by impact to guide automated query optimization and schema design. ## When to Apply Reference these guidelines when: - Writing SQL queries or designing schemas - Implementing indexes or query optimization - Reviewing database performance issues - Configuring connection pooling or scaling - Optimizing for Postgres-specific features - Working with Row-Level Security (RLS) ## Rule Categories by Priority | Priority | Category | I...
Frequently asked questions
What categories of Postgres optimization does this skill cover?
It covers eight categories: Query Performance, Connection Management, Security & RLS, Schema Design, Concurrency & Locking, Data Access Patterns, Monitoring & Diagnostics, and Advanced Features.
How does the skill structure its optimization advice?
Each rule includes an explanation, incorrect and correct SQL examples, query plan analysis, performance metrics, and Supabase-specific notes.
Related skills
aso
15.8KApp developers, marketers, and product managers looking to improve app store visibility and conversion rates
The aso skill audits and optimizes App Store and Google Play listings by analyzing metadata, visuals, and ratings against platform best practices. It classifies apps by brand maturity to provide tailored recommendations and generates a prioritized action plan.
audit-speed
2.2KSEO professionals, web developers, and site owners investigating page speed, Core Web Vitals, and resource optimization
The audit-speed skill provides a framework for diagnosing Core Web Vitals and page speed issues. It includes root-cause analysis trees for LCP, CLS, and INP metrics, resource weight benchmarks, and a structured reporting format for performance optimization recommendations.
seo-images
2.2KSEO specialists, web developers, and content managers optimizing website image performance and search engine visibility
The seo-images skill provides image optimization analysis and file processing for SEO. It audits HTML for alt text, file sizes, formats, lazy loading, and CLS prevention. It also performs image file conversions to WebP/AVIF, injects IPTC/XMP metadata for Google Images rich results, and audits AI-generated image labeling requirements.
seo-content-auditor
386Content creators, SEO specialists, and editors who need to audit text for quality and search engine optimization
The seo-content-auditor skill evaluates text content for SEO best practices, E-E-A-T signals, and readability. It provides structured audit reports with scoring and improvement recommendations.