Skip to main content

Supabase Postgres Best Practices

Skill Verified Active
Part of:Supabase

Postgres performance optimization and best practices from Supabase. Use this skill when writing, reviewing, or optimizing Postgres queries, schema designs, or database configurations.

Purpose

To help developers write, review, and optimize Postgres queries, schema designs, and database configurations by providing expert-level best practices and actionable examples.

Features

  • Postgres performance optimization rules
  • Detailed SQL examples for correct and incorrect patterns
  • Guidance on schema design and indexing
  • Connection management and security best practices
  • Prioritized categories of optimization rules

Use Cases

  • Writing performant SQL queries
  • Designing efficient database schemas
  • Troubleshooting slow database performance
  • Implementing security best practices like RLS

Non-Goals

  • Writing application code
  • Managing database infrastructure
  • Providing generic SQL tutorials

Installation

First, add the marketplace

/plugin marketplace add supabase/agent-skills
/plugin install agent-skills@supabase-agent-skills

Quality Score

Verified
99 /100
Analyzed about 12 hours ago

Trust Signals

Last commitabout 17 hours ago
Stars2.1k
LicenseMIT
Status
View Source

Similar Extensions

Sql Optimization

100

Universal SQL performance optimization assistant for comprehensive query tuning, indexing strategies, and database performance analysis across all SQL databases (MySQL, PostgreSQL, SQL Server, Oracle). Provides execution plan analysis, pagination optimization, batch operations, and performance monitoring guidance.

Skill
github

Dsql

100

Build with Aurora DSQL — manage schemas, execute queries, handle migrations, diagnose query plans, and develop applications with a serverless, distributed SQL database. Covers IAM auth, multi-tenant patterns, MySQL-to-DSQL migration, DDL operations, query plan explainability, and SQL compatibility validation. Triggers on phrases like: DSQL, Aurora DSQL, create DSQL table, DSQL schema, migrate to DSQL, distributed SQL database, serverless PostgreSQL-compatible database, DSQL query plan, DSQL EXPLAIN ANALYZE, why is my DSQL query slow.

Skill
awslabs

Neon Postgres

100

Guides and best practices for working with Neon Serverless Postgres. Covers getting started, local development with Neon, choosing a connection method, Neon features, authentication (@neondatabase/auth), PostgREST-style data API (@neondatabase/neon-js), Neon CLI, and Neon's Platform API/SDKs. Use for any Neon-related questions.

Skill
neondatabase

Performance Analysis

100

Comprehensive performance analysis, bottleneck detection, and optimization recommendations for Claude Flow swarms

Skill
ruvnet

MongoDB Connection Optimizer

100

Optimize MongoDB client connection configuration (pools, timeouts, patterns) for any supported driver language. Use this skill when working/updating/reviewing on functions that instantiate or configure a MongoDB client (eg, when calling `connect()`), configuring connection pools, troubleshooting connection errors (ECONNREFUSED, timeouts, pool exhaustion), optimizing performance issues related to connections. This includes scenarios like building serverless functions with MongoDB, creating API endpoints that use MongoDB, optimizing high-traffic MongoDB applications, creating long-running tasks and concurrency, or debugging connection-related failures.

Skill
mongodb

Core Web Vitals

100

Optimize Core Web Vitals (LCP, INP, CLS) for better page experience and search ranking. Use when asked to "improve Core Web Vitals", "fix LCP", "reduce CLS", "optimize INP", "page experience optimization", or "fix layout shifts".

Skill
addyosmani

© 2025 SkillRepo · Find the right skill, skip the noise.