write-script-postgresql

What problem does it solve?

Writing PostgreSQL queries safely and consistently can be error-prone. This Skill provides guidance on constructing parameterized queries, naming parameters clearly, and using explicit types to avoid mistakes and security risks.

Core Features & Use Cases

• Parameterized Query Construction: Write SQL statements with $1, $2 etc. and attach explicit types.
• In-Comment Parameter Naming: Define parameter meanings at the top of scripts using simple comments for clarity.
• Safe, Reusable Snippets: Create templates that can be adapted for common data-access patterns (filters, joins, and aggregations) while maintaining safety.

Quick Start

Provide a PostgreSQL snippet and parameter names at the top, then embed your query in the script and reference $1, $2, etc. Example: -- $1 user_id -- $2 min_age = 18 SELECT * FROM users WHERE id = $1::INT AND age > $2::INT;