windmill-labs / write-script-postgresql
Install for your project team
Run this command in your project directory to install the skill for your entire team:
mkdir -p .claude/skills/write-script-postgresql && curl -L -o skill.zip "https://fastmcp.me/Skills/Download/3300" && unzip -o skill.zip -d .claude/skills/write-script-postgresql && rm skill.zipProject Skills
This skill will be saved in .claude/skills/write-script-postgresql/ and checked into git. All team members will have access to it automatically.
Important: Please verify the skill by reviewing its instructions before using it.
MUST use when writing PostgreSQL queries.
0 views
0 installs
Skill Content
---
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 script 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):
```sql
-- $1 name1
-- $2 name2 = default_value
SELECT * FROM users WHERE name = $1::TEXT AND age > $2::INT;
```