skills.rest
VuNguyenVietTien
VuNguyenVietTienCOMMUNITY
Explore all skills by this author →
GitHub

supabase-postgres-best-practices

Optimize PostgreSQL schemas, queries, and configurations for performance and reliability.

Updated Feb 25, 2025
Search Tags:#performance#query optimization#indexing#schema design#postgresql#vacuum
One-click install
npx skills add https://github.com/VuNguyenVietTien/task-scheduler --skill supabase-postgres-best-practices-vunguyenviettien
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: supabase-postgres-best-practices
Source: https://github.com/VuNguyenVietTien/task-scheduler/tree/main/.agents/skills/supabase-postgres-best-practices
Command: npx skills add https://github.com/VuNguyenVietTien/task-scheduler --skill supabase-postgres-best-practices-vunguyenviettien

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes scripts (resource) and references (resource) components.

What problem does it solve?

This Skill helps database administrators and developers improve Postgres performance by following best practices, reducing slow queries and inefficient schema designs.

Core Features & Use Cases

  • Structured Optimization: Provides guidelines for indexing, partitioning, and schema design.
  • Performance Tuning: Offers instructions for analyzing query plans, adjusting autovacuum, and configuring connection limits.
  • Use Case: A team struggling with slow reports can use this Skill to identify query bottlenecks and apply best practices for indexing and vacuuming.

Quick Start

Use the Postgres best practices skill to analyze slow queries and apply indexing strategies in your database environment.

Frequently Asked Questions about supabase-postgres-best-practices

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I optimize slow PostgreSQL queries in a production database?▼

To optimize slow PostgreSQL queries, analyze query plans and apply indexing strategies to reduce bottlenecks. This Skill guides database engineers in identifying performance issues and configuring schemas for efficient resource utilization.

What are the best practices for PostgreSQL schema design and partitioning at scale?▼

PostgreSQL schema design best practices involve structuring databases with proper partitioning and indexing guidelines. This Skill provides structured optimization rules for large-scale systems to ensure efficient queries and minimal downtime.

How does autovacuum management improve PostgreSQL performance and reliability?▼

Autovacuum management improves PostgreSQL performance by reclaiming storage and preventing transaction ID wraparound. This Skill offers instructions for adjusting autovacuum configurations to ensure minimal downtime and high reliability.

Can I use these PostgreSQL optimization strategies for high-traffic Supabase applications?▼

These PostgreSQL optimization strategies apply to high-traffic Supabase applications requiring production-grade reliability. The Skill focuses on indexing, query plan analysis, and security configurations for large-scale systems.

What is the best way to analyze PostgreSQL query plans for performance tuning?▼

The best way to analyze PostgreSQL query plans is by using performance tuning instructions to identify execution bottlenecks. This Skill helps you interpret query plans and adjust schemas for optimal database performance.

Why are my PostgreSQL reports running slowly and how do I fix the bottlenecks?▼

PostgreSQL reports run slowly due to inefficient schema designs or missing indexes. You can fix bottlenecks by using this Skill to identify query issues and apply indexing and vacuuming best practices.

Related Skills

Explore More Software Engineering Skills→
nimadorostkarnimadorostkar
25

database-performance

Analyze execution plans and query logs to resolve database latency and throughput issues.

Community
Advanced
irizqiirizqi

laravel-database-optimization

Optimize Laravel 13 database queries with eager loading and indexing strategies.

Community
Advanced
djankiesdjankies

configuring-connection-pools

Configure Prisma Client connection pools for PostgreSQL deployments.

Community
Advanced
sanskarbasnetsanskarbasnet
1

canary

Monitor live applications for console errors, performance degradations, and page failures.

Community
Advanced