postgres-practices

What problem does it solve?

This Skill addresses common performance bottlenecks and security vulnerabilities in PostgreSQL databases, ensuring efficient and reliable data management.

Core Features & Use Cases

• Query Optimization: Identifies and suggests fixes for slow queries, missing indexes, and inefficient query plans.
• Schema Design: Provides best practices for data types, primary keys, and partitioning.
• Connection Management: Guides on setting up connection pooling and timeouts to handle high concurrency.
• Security: Enforces least privilege and Row-Level Security (RLS) policies.
• Use Case: When encountering slow database queries, use this Skill to analyze the query plan, identify missing indexes, and apply best practices for optimization.

Quick Start

Use the postgres-practices skill to find missing indexes on the 'orders' table.