What parameter syntax does this skill use for MSSQL?

This skill uses the @P1, @P2, etc., convention for arguments, allowing you to name and type them using SQL comments.

How do I generate the necessary metadata for my scripts?

You can use the 'wmill script generate-metadata' command as recommended by the skill to create .script.yaml and .lock files.

Can I deploy scripts directly to Windmill with this skill?

Yes, the skill provides the 'wmill sync push' workflow to deploy your finalized MSSQL scripts to the Windmill platform.

How do I find available database resource types in Windmill?

The skill instructs you to use 'wmill resource-type list --schema' to discover available resource types and their configurations.

MS SQL Server Script Writer for Windmill

Name: MS SQL Server Script Writer for Windmill
Author: windmill-labs

bywindmill-labs

0•

データベース管理

Generates optimized MS SQL Server queries for the Windmill platform with standardized parameter handling and deployment metadata.

The write-script-mssql skill is designed to streamline the creation and deployment of Microsoft SQL Server scripts within the Windmill automation ecosystem. It ensures that all queries adhere to Windmill's specific parameterization requirements, using @P1 and @P2 notation along with structured comments for type definition. Beyond script generation, it provides the necessary CLI workflows to produce required metadata files and synchronize scripts directly to a Windmill instance, making it an essential tool for developers building database-driven automations.

主な機能

01Standardizes MSSQL query syntax using @P1, @P2 parameterization

02Automates metadata generation for .script.yaml and .lock files

03Supports typed parameter naming via SQL comment headers

04Facilitates resource type discovery for database connections

05Integrated CLI commands for seamless Windmill deployment

060 GitHub stars

ユースケース

01Creating parameterized SQL scripts for Windmill automation workflows

02Deploying database scripts to Windmill using the wmill CLI

03Defining structured database inputs with specific varchar or int types

What are Skills?·How to Install

Install with 🐟 Skill.Fish

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

For use in Claude.ai and ChatGPT

Download Skill