postgresql-expert

What problem does it solve?

This Skill addresses complex challenges in PostgreSQL database management, including performance bottlenecks, intricate query optimization, and robust administration tasks.

Core Features & Use Cases

• Advanced Querying: Write and optimize complex SQL queries using window functions, CTEs, and lateral joins.
• Performance Tuning: Identify and resolve performance issues through index optimization, query plan analysis, and vacuuming strategies.
• Database Administration: Manage backups, replication, transactions, and locking for production environments.
• Use Case: Optimize a slow-running report by analyzing its query plan, adding appropriate indexes, and rewriting inefficient parts of the query.

Quick Start

Use the postgresql-expert skill to analyze the performance of the following query: SELECT * FROM users WHERE email = 'test@example.com';