postgresql

PostgreSQL schema design involves choosing appropriate data types, creating indexes strategically, and normalizing tables to reduce redundancy. The Skill provides guidance on schema structure, index selection, and query optimization aligned with official PostgreSQL documentation to improve performance for your workload.

Efficient SQL queries use proper joins, indexes, and query planning. This Skill covers SQL fundamentals through advanced concepts, including how to analyze query execution plans and apply optimization techniques from PostgreSQL documentation to write performant queries.

PostgreSQL connections are configured using libpq functions like PQconnectdb, PQconnectdbParams, and PQsetdbLogin. The Skill provides secure schema usage practices and connection patterns from official PostgreSQL documentation to establish and manage database connections safely.

Hypertables are specialized PostgreSQL structures for time-series data management. The Skill covers getting started with hypertables, including their creation, indexing strategies, and query optimization based on PostgreSQL documentation for handling large time-series datasets.

Performance tuning involves configuring connection parameters, optimizing indexes, and analyzing query plans. This Skill provides administration and tuning guidance from PostgreSQL documentation to identify bottlenecks and implement optimizations for production environments.

Yes. PostgreSQL administration covers configuration, maintenance, and monitoring. The Skill provides comprehensive administration guidance aligned with PostgreSQL documentation for managing connections, indexes, and database health in production.