Agent-Skills.md

Agent Skills: PostgreSQL

MUST use when writing PostgreSQL queries.

UncategorizedID: windmill-labs/windmill/write-script-postgresql

Repository

windmill-labs/windmill
windmill-labsLicense: NOASSERTION
16,266927

Install this agent skill to your local

pnpm dlx add-skill https://github.com/windmill-labs/windmill/tree/HEAD/system_prompts/auto-generated/skills/write-script-postgresql

Skill Files

Browse the full folder contents for write-script-postgresql.

Download Skill

Loading file tree…

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

Skill Metadata

Name
write-script-postgresql
Description
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;