Agent skill

Write Script Postgresql

by windmill-labs in windmill-labs/windmill

MUST use when writing PostgreSQL queries. An agent skill from windmill-labs/windmill.

Custom licenceAuto-check passedDatabases

Install Write Script Postgresql

skills CLI
$ npx skills add windmill-labs/windmill --skill write-script-postgresql -a claude-code

Project install by default; add -g for ~/.claude/skills/.

GitHub CLI
$ gh skill install windmill-labs/windmill write-script-postgresql --agent claude-code

Project scope by default; add --scope user for a personal install. Needs GitHub CLI 2.90.0 or later (public preview).

Manual copy
$ git clone --depth 1 https://github.com/windmill-labs/windmill.git skills-src && mkdir -p .claude/skills && cp -r skills-src/system_prompts/auto-generated/skills/write-script-postgresql .claude/skills/write-script-postgresql && rm -rf skills-src

Use ~/.claude/skills/ instead of .claude/skills for a personal install. The folder must contain SKILL.md.

Claude Code skills documentation · loads skills from .claude/skills/

Facts

Skill name
write-script-postgresql
GitHub stars
18k
Token cost
~2.2k tokens
SKILL.md length
1,293 words
Files
1
Skills in repo
42
Repo updated
First seen
Licence
Custom licence

At a glance

MUST use when writing PostgreSQL queries. An agent skill from windmill-labs/windmill.

  • Writing PostgreSQL queries
  • SKILL.md covers CLI Commands, General Principles, Return Values and Preprocessor Scripts, plus 2 more sections
  • Calls git

What it does

Write Script Postgresql is an agent skill from windmill-labs/windmill. MUST use when writing PostgreSQL queries.

Its SKILL.md is about 2.2k tokens, which your agent loads only when the skill is triggered. It is a single SKILL.md file with no bundled scripts.

It sits in Databases. It works with PostgreSQL. The repository describes itself as: Open-source developer platform to power your entire infra and turn scripts into webhooks, workflows and UIs. Fastest workflow engine (13x vs Airflow). Open-source alternative to…

When your agent uses it

  • Writing PostgreSQL queries

Example prompts

  • “/write-script-postgresql”

What it can do on your machine

Read from SKILL.md and the folder at commit f40eea2. It shows what the files ask for, not the result of running them.

  • Tool permissions

    Pre-approves nothing: there is no allowed-tools line, so your agent's usual permission prompts apply.

    From allowed-tools in the SKILL.md frontmatter.

  • Runs code

    Shell commands in SKILL.md call:

    • git

    From the folder's file list and the shell code blocks in SKILL.md.

  • Network

    No URLs in SKILL.md. Its commands use git, which can reach the network depending on how they are called.

    From URLs in SKILL.md, links to its own repository left out.

  • Credentials

    Names no API keys, tokens, secrets or passwords.

    From names ending in _API_KEY, _TOKEN, _SECRET, _KEY or _PASSWORD in SKILL.md.

Context cost

Write Script Postgresql loads about 2.2k tokens when it runs. Until then it costs about 16 tokens; SKILL.md has 1,293 words of instructions outside code blocks.

Always · name and description, kept in context so the agent knows when to use it
~16
When it runs · the whole SKILL.md, loaded when a task matches
~2.2k

Estimates: characters ÷ 4, the usual rule of thumb; real counts depend on the model's tokenizer. Scripts and assets cost tokens only if the agent reads them.

Safety

Auto-check passed

The automated check found no risky patterns in SKILL.md.

Automated static check — not a guarantee. Review scripts before installing. It scans the text of SKILL.md for risky patterns (piping downloads into a shell, reading credential files, hidden Unicode, destructive commands); files beside SKILL.md are not scanned.

SKILL.md

Its licence (Custom licence) doesn't allow us to republish the file, so here is its outline and opening line. It has 1,293 words (~2,231 tokens).

name
write-script-postgresql

Read the full SKILL.md on GitHub

Files

Just SKILL.md in system_prompts/auto-generated/skills/write-script-postgresql of windmill-labs/windmill.

Open the folder on GitHubat commit f40eea2

Compare with similar skills

Write Script Postgresql next to the 5 skills that share the most tags, products or categories with it. Stars are the repository's; “used in” counts other GitHub owners with a copy.

Write Script Postgresql compared with similar skills
SkillStarsUsed inTokensAuto-checkLicenceRepo updated
Write Script Postgresql this skillwindmill-labs/windmill18k—~2.2kAutomated safety check: PassCustom licence
Backend Test WorkerCorrectRoadH/OpenTickly306—~1.3kAutomated safety check: PassAGPL-3.0
Ef Core Migrationsjihadkhawaja/Egroo178—~673Automated safety check: PassApache-2.0
Add Oliphaunt Extensionf0rr0/oliphaunt105—~1.4kAutomated safety check: PassMIT
Diagnose Cloud SessionFreakStudioCN/mpy-hardware-extension132—~809Automated safety check: NotesCustom licence
DB AdminEliasOulkadi/shokunin114—~2kAutomated safety check: NotesMIT

Similar skills

  • Backend Test Worker

    CorrectRoadH/OpenTickly

    Build and verify real-Postgres Go tests and thin transport smoke for tracking behavior.

    306 GitHub stars~1.3k tokensUpdated 5 days ago
    DatabasesAuto-check passed
  • Ef Core Migrations

    jihadkhawaja/Egroo

    Handle EF Core schema changes in Egroo. An agent skill from jihadkhawaja/Egroo.

    178 GitHub stars~673 tokensUpdated 6 mo ago
    DatabasesAuto-check passed
  • Add, update, or remove an Oliphaunt PostgreSQL contrib or external extension, including source pins, build recipes, target support, SDK metadata, release products, carrier identities, and package…

    105 GitHub stars~1.4k tokensUpdated today
    DatabasesAuto-check passed
  • Diagnose Cloud Session

    FreakStudioCN/mpy-hardware-extension

    用户报告 Blockless 扩展在云端实测时出问题(卡死/灰屏/跳步/构建失败),但本地复现不了、日志不在本地文件里时,用这个从云端托管数据库拉真实 session 定位症状与根因 / Use when a user reports an in-product Blockless bug from live cloud-backend testing and the real session…

    132 GitHub stars~809 tokensUpdated 9 days ago
    DatabasesAuto-check: notes
  • DB Admin

    EliasOulkadi/shokunin

    PostgreSQL database administration — backup/restore (pgdump, PITR, WAL archiving), health monitoring (connections, bloat, cache hit ratio, dead tuples), connection pooling (PgBouncer), replication…

    114 GitHub stars~2k tokensUpdated 3 days ago
    DatabasesAuto-check: notes
  • Postgresql Table Design

    ynulihao/AgentSkillOS

    Design a PostgreSQL-specific schema. An agent skill from ynulihao/AgentSkillOS.

    617 GitHub starsUsed in 15 repos~4k tokens
    DatabasesAuto-check passed

More from windmill-labs/windmill

All 42 skills in this repo
  • Windmill Trigger Type Checklist

    windmill-labs/windmill

    Checklist of every backend, frontend, CLI and capture change needed to add a new TriggerCrud-based trigger type, such as Azure, GCP or Kafka, to Windmill.

    18k GitHub stars~4.7k tokensUpdated today
    Auto-check passed
  • Windmill AI Evals

    windmill-labs/windmill

    Writes and runs black-box benchmark cases for Windmill's flow, app, script, CLI and global AI generation modes, including before-and-after comparisons.

    18k GitHub stars~969 tokensUpdated today
    Auto-check: notes
  • Domain Modeling and Glossary

    windmill-labs/windmill

    Actively challenges vague or conflicting terminology as you design, and keeps a living domain glossary file up to date in real time.

    18k GitHub stars~622 tokensUpdated today
    Auto-check passed
  • Local PR Review

    windmill-labs/windmill

    Runs the same code review locally that GitHub's auto-review actions run on a PR, delegating to a fresh-context subagent so the review isn't biased by the main session's own reasoning.

    18k GitHub stars~995 tokensUpdated today
    Auto-check passed
  • Draft PR with CI Rounds

    windmill-labs/windmill

    Opens a draft GitHub pull request with a conventional title and explicit body, then drives CI review rounds before marking it ready.

    18k GitHub stars~3.4k tokensUpdated today
    Auto-check passed
  • Windmill Dev Page Preview

    windmill-labs/windmill

    Opens the Windmill dev page to preview a flow, script or app, choosing between proxy and direct mode and deciding whether the agent or the runtime starts the wmill dev server.

    18k GitHub stars~1.8k tokensUpdated today
    Auto-check passed

Works with

Categories

Questions about Write Script Postgresql

What does Write Script Postgresql do?

MUST use when writing PostgreSQL queries. An agent skill from windmill-labs/windmill. Write Script Postgresql is an agent skill from windmill-labs/windmill. MUST use when writing PostgreSQL queries.

When should I use Write Script Postgresql?

Write Script Postgresql fits situations like: writing PostgreSQL queries.

How do I install Write Script Postgresql in Claude Code?

Run `npx skills add windmill-labs/windmill --skill write-script-postgresql -a claude-code`. Or copy the skill folder (system_prompts/auto-generated/skills/write-script-postgresql in windmill-labs/windmill) into .claude/skills/write-script-postgresql in your project. Claude Code loads it when a task matches its description.

How do I install Write Script Postgresql in Codex?

Run `npx skills add windmill-labs/windmill --skill write-script-postgresql -a codex`. Or copy the skill folder (system_prompts/auto-generated/skills/write-script-postgresql in windmill-labs/windmill) into .agents/skills/write-script-postgresql in your project. Codex loads it when a task matches its description.

Can I use Write Script Postgresql in Cursor, Gemini CLI or GitHub Copilot?

Cursor, Gemini CLI, GitHub Copilot and OpenCode also load SKILL.md folders. With the skills CLI, run `npx skills add windmill-labs/windmill --skill write-script-postgresql -a cursor` (or -a gemini-cli, github-copilot or opencode for the others). To copy it by hand, put the folder in .cursor/skills/write-script-postgresql, .gemini/skills/write-script-postgresql, .github/skills/write-script-postgresql and .opencode/skills/write-script-postgresql in your project.

What does Write Script Postgresql need to run?

Going by SKILL.md and its folder, Write Script Postgresql needs the command-line tools its instructions call (git).

Does Write Script Postgresql access the network?

SKILL.md contains no URLs. Its commands use git, which can reach the network depending on how they are called. This is read from the text; nothing was executed.

Is Write Script Postgresql safe to install?

Our automated static check of SKILL.md found no risky patterns, such as piping downloads into a shell, reading credential files or hidden Unicode. It is not a guarantee. Review the folder before installing.

What licence does Write Script Postgresql use?

Write Script Postgresql has a licence file (the repository's licence) that doesn't match a standard licence. Read it on GitHub before reusing the skill.

How many tokens does Write Script Postgresql use?

About 2.2k tokens (SKILL.md is roughly 8.9k characters). Agents keep only the skill's name and description in context until a task matches; then they load SKILL.md in full.

What are the alternatives to Write Script Postgresql?

Skills that share tags, products or a category with Write Script Postgresql: Backend Test Worker (CorrectRoadH/OpenTickly, 306 stars), Ef Core Migrations (jihadkhawaja/Egroo, 178 stars), Add Oliphaunt Extension (f0rr0/oliphaunt, 105 stars) and Diagnose Cloud Session (FreakStudioCN/mpy-hardware-extension, 132 stars). The comparison table on this page puts their stars, adoption, token cost, safety result and licence side by side.

Who maintains Write Script Postgresql?

windmill-labs (a GitHub organization) maintains it in windmill-labs/windmill, which has 18,128 GitHub stars. The repository holds 42 skills in this directory. The repository was last updated on October 8, 2026.

Source: windmill-labs/windmill on GitHub. Facts on this page come from the repository at the commit we read; the author's words are quoted as theirs.