skills.rest
Nixdorfer
NixdorferCOMMUNITY
Explore all skills by this author →
GitHub

postgres-patterns

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

3|Updated Feb 8, 2026
Search Tags:#performance#indexing#schema design#database#postgresql#optimization#sql
One-click install
npx skills add https://github.com/Nixdorfer/ClaudeCodeTool --skill postgres-patterns-nixdorfer
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: postgres-patterns
Source: https://github.com/Nixdorfer/ClaudeCodeTool/tree/main/plugins/cache/everything-claude-code/everything-claude-code/1.4.1/.cursor/skills/postgres-patterns
Command: npx skills add https://github.com/Nixdorfer/ClaudeCodeTool --skill postgres-patterns-nixdorfer

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, and security, helping developers write more efficient and robust SQL.

Core Features & Use Cases

  • Query Optimization: Guidance on writing efficient SQL queries.
  • Schema Design: Best practices for data types and table structures.
  • Indexing Strategies: Recommendations for creating effective indexes.
  • Security: Tips for implementing Row Level Security (RLS).
  • Use Case: When encountering slow query performance, consult this Skill for index recommendations or anti-pattern detection.

Quick Start

Use the postgres-patterns skill to generate an optimized index for a table with a WHERE clause on a timestamp column.

Frequently Asked Questions about postgres-patterns

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

FAQPage Schema
What is the best way to optimize slow PostgreSQL query performance?▼

To optimize slow PostgreSQL query performance, apply best practices for query optimization, schema design, and indexing. Detecting common SQL anti-patterns and generating effective indexes helps resolve performance bottlenecks efficiently.

How do I design an effective indexing strategy for a PostgreSQL database?▼

Design an effective PostgreSQL indexing strategy by following best practices for creating indexes based on common query patterns. Generating optimized indexes for specific WHERE clauses, like timestamp columns, ensures efficient database operations.

How do I implement Row Level Security in PostgreSQL?▼

Implement PostgreSQL Row Level Security (RLS) by applying provided security best practices and configuration templates. These guidelines facilitate robust application development by ensuring proper data access controls at the database level.

What are common PostgreSQL schema design anti-patterns I should avoid?▼

Common PostgreSQL schema design anti-patterns involve improper data type selection and inefficient table structures. Detecting these anti-patterns through best practice references ensures robust data modeling and prevents slow query performance.

Does this PostgreSQL optimization guidance work with Supabase best practices?▼

Yes, the PostgreSQL optimization guidance incorporates configuration templates and best practices based directly on Supabase. This ensures the query optimization, schema design, and security recommendations fit Supabase database workflows.

Related Skills

Explore More Software Engineering Skills→
AngelP17AngelP17
1

sql-optimization-patterns

Analyze EXPLAIN output and apply indexing strategies to optimize slow SQL queries.

Community
Advanced
kivo360kivo360
1

moai-domain-database

Optimize domain database schemas, indexing, and versioned migrations.

Community
Advanced
jayantrohila57jayantrohila57

drizzle-orm

Define TypeScript database schemas and write type-safe SQL queries.

Community
Intermediate
cenjiecenjie

database-query-optimization

Analyze EXPLAIN ANALYZE diagnostics and apply indexing to optimize database queries.

Community
Advanced