postgres-queries

What problem does it solve?

This Skill provides developers with a comprehensive set of pre-written, best-practice SQL query patterns for PostgreSQL, reducing the time spent on writing common and complex queries.

Core Features & Use Cases

• CRUD Operations: Examples for INSERT, UPDATE, DELETE, and SELECT statements with various conditions and return clauses.
• Advanced SQL: Demonstrates CTEs, Window Functions, JSONB operations, Full-Text Search, and Array manipulations.
• Use Case: Quickly implement efficient queries for data aggregation, hierarchical data traversal, or complex filtering based on JSON or array data within your PostgreSQL database.

Quick Start

Use the postgres-queries skill to generate a SQL query for selecting active users created in the last 30 days, ordered by creation date.