skill-database-postgresql

What problem does it solve?

PostgreSQL database design and performance often suffer from poor schema design, missing or suboptimal indexes, inefficient queries, unoptimized transactions, and unmanaged connection pools. This skill provides best practices to design scalable schemas, apply effective indexing strategies, optimize queries, ensure reliable transactions, and configure connections for production workloads.

Core Features & Use Cases

• Schema Design Guidelines: Normalize appropriately, use appropriate data types, create meaningful constraints and foreign keys, and plan for migrations.
• Indexing & Query Optimization: Choose right index types, build composite and partial indexes, and optimize common query patterns with explain plans.
• Transactions & Pooling: Implement safe transactional boundaries and configure connection pooling for high-concurrency apps.
• Use Case: A SaaS app with growing user data can benefit from a well-designed schema, proper indexing, and robust transaction handling to maintain performance and data integrity at scale.

Quick Start

Design a robust PostgreSQL schema and indexing plan for a new app and optimize a sample query.