postgres-patterns

Provide PostgreSQL patterns for query optimization, schema design, indexing, and security.

Updated Mar 9, 2026

Search Tags:#indexing #schema design #database #postgresql #rls #optimization #sql

Ready to run

npx skills add https://github.com/drxaibi/vibe-setup --skill postgres-patterns-drxaibi

💬 Prompt for ChatGPT / Claude Chat▼

Please help me install this Agent Skill.
Skill: postgres-patterns
Source: https://github.com/drxaibi/vibe-setup/tree/main/.github/skills/postgres-patterns
Command: npx skills add https://github.com/drxaibi/vibe-setup --skill postgres-patterns-drxaibi

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes references (resource) components.

What problem does it solve?

This Skill provides best practices and quick reference guides for optimizing PostgreSQL database performance, schema design, indexing, and security.

Core Features & Use Cases

Query Optimization: Learn efficient SQL query patterns and indexing strategies.
Schema Design: Understand best practices for data types and table structures.
Security: Implement Row Level Security (RLS) effectively.
Use Case: When encountering slow-running SQL queries, consult this Skill for common optimization patterns and index recommendations.

Quick Start

Use the postgres-patterns skill to find unindexed foreign keys in the database.

Frequently Asked Questions about postgres-patterns

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

FAQPage Schema

How do I optimize slow PostgreSQL queries?▼

To optimize slow PostgreSQL queries, apply efficient SQL patterns and indexing strategies. This Skill provides reference guides for troubleshooting slow queries and recommending appropriate database indexes to improve performance.

What are the best practices for PostgreSQL schema design?▼

PostgreSQL schema design best practices involve selecting appropriate data types and table structures. This Skill provides reference patterns for designing efficient schemas based on Supabase best practices to ensure optimal data operations.

How do I implement Row Level Security in PostgreSQL?▼

Implement Row Level Security (RLS) in PostgreSQL by applying established security patterns. This Skill provides guidance on setting up RLS policies to secure database operations based on Supabase best practices.

How do I find unindexed foreign keys in my PostgreSQL database?▼

Find unindexed foreign keys in your PostgreSQL database by consulting this Skill's quick reference guides. It provides specific patterns and queries to identify missing indexes on foreign keys for performance tuning.

Does this Skill cover connection pooling setup for PostgreSQL?▼

Yes, this Skill covers connection pooling setup for PostgreSQL. It addresses scenarios including setting up connection pooling alongside query optimization, schema design, and security to ensure efficient database operations.