postgres-patterns

Provide PostgreSQL guidance for query optimization, indexing, and Row Level Security.

Updated Feb 1, 2026

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

Ready to run

npx skills add https://github.com/2good4me/JobNow --skill postgres-patterns-2good4me

💬 Prompt for ChatGPT / Claude Chat▼

Please help me install this Agent Skill.
Skill: postgres-patterns
Source: https://github.com/2good4me/JobNow/tree/main/.agents/skills/postgres-patterns
Command: npx skills add https://github.com/2good4me/JobNow --skill postgres-patterns-2good4me

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes references (resource) components.

What problem does it solve?

This Skill provides best practices and quick references for optimizing PostgreSQL database performance, schema design, indexing strategies, and security configurations.

Core Features & Use Cases

Query Optimization: Learn efficient SQL patterns for better query performance.
Schema Design: Understand best practices for data types and table structures.
Indexing Strategies: Implement effective indexing for faster data retrieval.
Security: Apply Row Level Security (RLS) and other security measures.
Use Case: When encountering slow-running SQL queries or designing new database schemas, consult this Skill for proven patterns and anti-patterns.

Quick Start

Use the postgres-patterns skill to generate a composite index for a table with status and creation date columns.

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 using indexing strategies?▼

Optimize slow PostgreSQL queries by implementing composite and covering indexes. This skill guides you through effective indexing strategies for faster data retrieval and detects anti-patterns like unindexed foreign keys.

What are the best practices for PostgreSQL schema design and data types?▼

PostgreSQL schema design best practices involve selecting appropriate data types and structuring tables efficiently. This skill provides recommendations for optimal data type usage and table structures to improve database performance.

How does Row Level Security work in PostgreSQL for database security?▼

Row Level Security (RLS) in PostgreSQL restricts data access at the row level based on user roles. This skill provides guidance on applying RLS and other security configurations to protect your database.

What are common PostgreSQL anti-patterns for unindexed foreign keys?▼

Common PostgreSQL anti-patterns include unindexed foreign keys and inefficient SQL patterns causing slow queries. This skill helps detect these issues and offers proven patterns to resolve them.

How do I configure PostgreSQL connection limits and monitoring settings?▼

Configure PostgreSQL connection limits and monitoring using provided configuration templates. This skill includes templates for setting connection limits and monitoring setups to maintain database stability.

When should I use a composite index versus a covering index in PostgreSQL?▼

Use a composite index in PostgreSQL for queries filtering on multiple columns and a covering index to avoid table access. This skill explains indexing strategies to implement the right approach for faster data retrieval.