skills.rest
Long-NguyenHai
Long-NguyenHaiCOMMUNITY
Explore all skills by this author →
GitHub

postgres-patterns

Provide PostgreSQL optimization best practices for indexing, schema design, and security.

Updated Jul 4, 2026
Search Tags:#query optimization#security#schema design#PostgreSQL#database optimization
One-click install
npx skills add https://github.com/Long-NguyenHai/warehouse-ai --skill postgres-patterns-long-nguyenhai
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: postgres-patterns
Source: https://github.com/Long-NguyenHai/warehouse-ai/tree/main/.agents/skills/postgres-patterns
Command: npx skills add https://github.com/Long-NguyenHai/warehouse-ai --skill postgres-patterns-long-nguyenhai

SYSTEM DOCUMENTATION & REQUIREMENTS

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

What problem does it solve?

This Skill provides quick references and best practices for optimizing PostgreSQL databases, covering query optimization, schema design, indexing, and security.

Core Features & Use Cases

  • Query Optimization: Offers index types and best practices for different query patterns.
  • Schema Design: Provides guidance on choosing the right data types and indexing strategies.
  • Indexing: Details how to create effective B-tree, composite, GIN, and BRIN indexes.
  • Security: Shares strategies for Row Level Security (RLS) and other security measures.
  • Anti-Pattern Detection: Helps identify common issues like unindexed foreign keys, slow queries, and table bloat.
  • Configuration: Offers a template for setting up PostgreSQL for performance and security.

Quick Start

Use the postgres-patterns skill to analyze your database schema and optimize your queries for better performance.

Frequently Asked Questions about postgres-patterns

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

FAQPage Schema
What are the best practices for PostgreSQL query optimization and schema design?▼

PostgreSQL query optimization and schema design best practices include selecting appropriate data types, applying effective indexing strategies like B-tree or GIN, and detecting anti-patterns such as unindexed foreign keys to improve database performance and maintain data integrity.

How do I create effective indexes for different PostgreSQL query patterns?▼

To create effective indexes for PostgreSQL query patterns, apply best practices for utilizing B-tree, composite, GIN, and BRIN indexes based on your specific queries to significantly improve database performance and execution speed.

How do I configure Row Level Security in PostgreSQL to maintain data integrity?▼

To configure Row Level Security in PostgreSQL, apply specific security configuration strategies and templates that protect data and maintain data integrity by restricting row-level access based on user roles.

What are common PostgreSQL anti-patterns that cause slow queries and table bloat?▼

Common PostgreSQL anti-patterns causing slow queries and table bloat include unindexed foreign keys and poor schema design, which you can identify and resolve using database optimization best practices to improve overall performance.

Does this PostgreSQL optimization guidance apply to database administrators managing existing databases?▼

Yes, this PostgreSQL optimization guidance applies to both developers and database administrators who need to analyze existing database schemas, configure settings for performance and security, and improve query execution.

Related Skills

Explore More Software Engineering Skills→
tankpkgtankpkg
1

@tank/relational-db-mastery

Optimize PostgreSQL and MySQL query performance with indexing and tuning strategies.

Official
Advanced
TeiNamTeiNam
12

postgres-guideline

Provide PostgreSQL guidelines for schema design, indexing, and query optimization.

Community
Advanced
haJ1thaJ1t

terraform-pro

Automate Terraform infrastructure planning and application across multi-environment setups.

Community
Advanced
mcauduro0mcauduro0
1

alireza-database-designer

Analyze SQL DDL and JSON schemas to generate ERD diagrams and migration scripts.

Community
Advanced