write-script-postgresql
CommunityEfficient, safe PostgreSQL query scripting.
Authoradamkingsbury
Version1.0.0
Installs0
System Documentation
What problem does it solve?
PostgreSQL developers often write ad-hoc queries with inline literals and untyped placeholders, which leads to type mismatches, SQL injection risks, and hard-to-maintain scripts. This Skill standardizes parameter usage and typing to improve reliability.
Core Features & Use Cases
- Inline parameter declarations using $N::{TYPE} and a preceding comment line to name the parameter, e.g. -- $1
- Support for typed parameters (TEXT, INT, DATE, etc.) to ensure correct casting and comparisons
- Produces deterministic SQL scripts that are easy to read, review, and reuse as templates for common tasks like data retrieval and updates
Quick Start
Use a PostgreSQL script that declares parameters with $N::TYPE and comments like -- $1 user_id before the statement to create a reusable, typed query template.
Dependency Matrix
Required Modules
None requiredComponents
Standard package💻 Claude Code Installation
Recommended: Let Claude install automatically. Simply copy and paste the text below to Claude Code.
Please help me install this Skill: Name: write-script-postgresql Download link: https://github.com/adamkingsbury/unified-data-model/archive/main.zip#write-script-postgresql Please download this .zip file, extract it, and install it in the .claude/skills/ directory.
Agent Skills Search Helper
Install a tiny helper to your Agent, search and equip skill from 223,000+ vetted skills library on demand.