windmill/system_prompts/auto-generated/skills/write-script-postgresql/SKILL.md

name, description

name	description
write-script-postgresql	MUST use when writing PostgreSQL queries.

CLI Commands

Place scripts in a folder. After writing, tell the user they can run:

• wmill generate-metadata - Generate .script.yaml and .lock files
• wmill sync push - Deploy to Windmill

Do NOT run these commands yourself. Instead, inform the user that they should run them.

Use wmill resource-type list --schema to discover available resource types.

PostgreSQL

Arguments are obtained directly in the statement with $1::{type}, $2::{type}, etc.

Name the parameters by adding comments at the beginning of the script (without specifying the type):

-- $1 name1
-- $2 name2 = default_value
SELECT * FROM users WHERE name = $1::TEXT AND age > $2::INT;