Does it support resource type discovery?

Yes, it includes instructions for using the 'wmill resource-type list --schema' command to find available resource types in your environment.

Is this for standard PostgreSQL or just Windmill?

While it generates valid PostgreSQL, it specifically formats the code and metadata to work within the Windmill orchestration platform.

Can this skill help me deploy my scripts?

Yes, it provides specific wmill CLI commands like 'wmill script generate-metadata' and 'wmill sync push' to prepare and deploy your scripts.

How are parameters defined in this Windmill PostgreSQL skill?

Parameters are defined using comments at the start of the script for naming and default values, while the SQL body uses $1::{type} syntax for type casting.

Windmill PostgreSQL Scripting

Name: Windmill PostgreSQL Scripting
Author: windmill-labs

bywindmill-labs

0•

Database Management

Streamlines the creation and deployment of PostgreSQL scripts optimized for the Windmill orchestration platform.

This skill provides Claude with the specific patterns and syntax required to write PostgreSQL scripts compatible with Windmill. It ensures that SQL queries utilize the correct parameter mapping convention (using comment headers for naming and $1::{type} for casting) and includes guidance for the Windmill CLI (wmill). It is particularly useful for developers building serverless workflows, data processing pipelines, or backend services where SQL tasks need to be deployed and managed via the Windmill platform.

Key Features

01Implements comment-based parameter naming and default values

020 GitHub stars

03Includes CLI commands for syncing and deploying scripts to Windmill

04Generates Windmill-compliant PostgreSQL query syntax

05Assists in discovering available resource types via schema listing

06Provides instructions for generating script metadata and lock files

Use Cases

01Converting standard SQL queries into Windmill-specific parameterized scripts

02Creating serverless database tasks for Windmill automation workflows

03Managing PostgreSQL deployments using the wmill CLI tool

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add windmill-labs/windmill-claude-plugin write-script-postgresql

For use in Claude.ai and ChatGPT

Download Skill