sql-server-optimizer SKILL.md skillA

sql-server-optimizer from procesio-externals/procesio-cli is an agent skill: a SKILL.md folder an AI agent loads when a task calls for it.

Install it, pinned
mdr add procesio-externals/procesio-cli/sql-server-optimizer@v1.0.1

Pins v1.0.1 in mdr.lock. Pin the fingerprint instead.

Audit grade
A, 17 of 17 checks passed
Kind
SKILL.md skill
Repository
procesio-externals/procesio-cli
Path
skills/sql-server-optimizer/SKILL.md
Versions recorded
3
Latest version
v1.0.1, committed Sep 13, 2026
First version recorded
Sep 2, 2026
Size
7,054 bytes
Repository stars
4
License
Apache-2.0

Analyze and optimize SQL Server T-SQL, including SQL executed by PROCESIO. Use when reviewing a query, procedure, function, execution plan, index strategy, sargability, parameter sniffing, implicit conversions, logical reads, blocking, reporting-query performance, result semantics, isolation safety, or PROCESIO inline/native SQL parameters; do not use for PostgreSQL, MySQL, or repository maintenance.

Collected from public GitHub. Every version is saved exactly as it was and never changes. Install it at an exact version with the mdr tool, and every file is checked before it reaches your agent. The main file is checked against the SHA-256 fingerprint recorded here, and the others against the fingerprints GitHub keeps for its source commit. The automatic checks below grade the latest version, and the same checks always give the same file the same grade.

What the file says

# Optimize SQL Server with evidence

Optimize **measured bottlenecks while preserving semantics**. A shorter query, a new index, or a passing syntax check is not proof of improvement.

## Boundary

- PostgreSQL, MySQL, Oracle, or generic database design without SQL Server: do not use this skill.
- Operating the surrounding PROCESIO process belongs to `procesio-cli`; this skill owns the T-SQL analysis.
- Authoring or evaluating this skill belongs to `agent-skill-engineer`; repository code and skill integration belong to `procesio-cli-maintainer`.

## Required workflow

1. **Define correctness.** Identify expected rows, duplicates, ordering guarantees, NULL behavior, transaction/write behavior, acceptable staleness, and representative parameters. Preserve these unless the user explicitly changes them.
…

Read the whole file at its exact version.

How to install

The exact contents, by fingerprint
mdr add procesio-externals/procesio-cli/sql-server-optimizer@sha256:d3390665c4fc1098

The line at the top of this page pins the label v1.0.1, which is what most people want. This one pins the sha256 fingerprint of the contents instead, so it survives a label being moved. Either way the exact version is written to mdr.lock, and mdr install downloads and checks those contents again, so it installs them exactly or stops with an error.

Badge

mdr badge

[![mdr](https://markdownregistry.com/badge/art_mdrlhr4cw5usy5ul.svg)](https://markdownregistry.com/a/art_mdrlhr4cw5usy5ul)

2 badge image fetches in 30 days. What the badge shows.

Versions

The registry has recorded 3 versions of this file, between Sep 2, 2026 and Sep 13, 2026, about one every 6 days.

versioncommittedcommitsizeaudit
v1.0.1 latest2026-09-13 61b838c 7,054 BA view · diff
git:20260909.a731baf2026-09-09 a731baf 7,379 BA view · diff
git:20260902.0fd03b32026-09-02 0fd03b3 7,396 BA view

Audit of the latest version

A  17 of 17 checks passed. Fixed automatic checks with no AI involved, so the same checks give the same answer every run.
  • pass: Frontmatter block present
  • pass: Frontmatter declares a name
  • pass: Frontmatter declares a description
  • pass: Size between 200 bytes and 200 KB (7054 bytes)
  • pass: No zero-width or bidi control characters
  • pass: No instruction hidden inside an HTML comment
  • pass: No link to an exfiltration or paste host
  • pass: No credential-shaped string
  • pass: No instruction to send local credentials anywhere
  • pass: No text hidden with inline styles
  • pass: No prompt-injection phrasing
  • pass: No curl or wget piped into a shell
  • pass: No recursive delete of root, home or parent
  • pass: No instruction to read or print local credentials
  • pass: No base64 blob over 200 characters
  • pass: No link to a raw IP address
  • pass: No script tag

Source

GitHub

procesio-externals/procesio-cli · 4 stars · license Apache-2.0 · pushed 2026-11-04 · branch main

API

GET https://markdownregistry.com/api/v1/artifacts/art_mdrlhr4cw5usy5ul
GET https://markdownregistry.com/api/v1/resolve?ref=procesio-externals/procesio-cli/sql-server-optimizer
GET https://markdownregistry.com/api/v1/blob/d3390665c4fc1098ebbeff7bf1681951dd27952dcadec379f588f59dff97c2e5

Your AI assistant does the legwork. You hear about the deals worth your word. Hand yours the standing instructions at modelranch.com and it joins the network that reads files like this one.

Guides: the SKILL.md format and its required fields · what to check before you install a skill · how to pin a skill to an exact version · where to find agent skills · keeping a team on the same skills · which agent file does what.

More from procesio-externals/procesio-cli

AGENTS.md AGENTS.md file
procesio-externals/procesio-cli · AGENTS.md
git:20260902.0fd03b3 · audit A · 4 stars
CLAUDE.md CLAUDE.md file
procesio-externals/procesio-cli · CLAUDE.md
git:20261102.7bcb3ba · audit A · 4 stars
procesio-cli SKILL.md skill
procesio-externals/procesio-cli · plugin/skills/procesio-cli/SKILL.md · Operate and troubleshoot PROCESIO resources through this repository's CLI or MCP. Use when inspecting, creating…
v1.0.4 · audit A · 4 stars
procesio-platform-advisor SKILL.md skill
procesio-externals/procesio-cli · plugin/skills/procesio-platform-advisor/SKILL.md · Assess whether PROCESIO can support a workflow and which architecture fits. Use for product capability, feasibility…
v1.0.2 · audit A · 4 stars
procesio-setup SKILL.md skill
procesio-externals/procesio-cli · plugin/skills/procesio-setup/SKILL.md · Connect this installation to a PROCESIO workspace, so the MCP server and the CLI can reach it. Use on first run, after…
v1.0.0 · audit A · 4 stars
sql-server-optimizer SKILL.md skill
procesio-externals/procesio-cli · plugin/skills/sql-server-optimizer/SKILL.md · Analyze and optimize SQL Server T-SQL, including SQL executed by PROCESIO. Use when reviewing a query, procedure…
v1.0.1 · audit A · 4 stars
agent-skill-engineer SKILL.md skill
procesio-externals/procesio-cli · skills/agent-skill-engineer/SKILL.md · Engineer reusable Agent Skill packages and SKILL.md routing and evaluation systems. Use when the primary deliverable is…
v2.0.4 · audit A · 4 stars
procesio-cli-maintainer SKILL.md skill
procesio-externals/procesio-cli · skills/procesio-cli-maintainer/SKILL.md · Change or review the procesio-cli repository source code. Use to add a new CLI action, edit a CLI manifest or…
v1.1.1 · audit A · 4 stars
procesio-cli SKILL.md skill
procesio-externals/procesio-cli · skills/procesio-cli/SKILL.md · Operate and troubleshoot PROCESIO resources through this repository's CLI or MCP. Use when inspecting, creating…
v1.0.4 · audit A · 4 stars
procesio-platform-advisor SKILL.md skill
procesio-externals/procesio-cli · skills/procesio-platform-advisor/SKILL.md · Assess whether PROCESIO can support a workflow and which architecture fits. Use for product capability, feasibility…
v1.0.2 · audit A · 4 stars
procesio-setup SKILL.md skill
procesio-externals/procesio-cli · skills/procesio-setup/SKILL.md · Connect this installation to a PROCESIO workspace, so the MCP server and the CLI can reach it. Use on first run, after…
v1.0.0 · audit A · 4 stars
connector-builder SKILL.md skill
procesio-externals/procesio-cli · tools/connector-builder/SKILL.md · AI Connector Builder (connector-builder.procesio.app): turn API documentation into a compiled PROCESIO Custom Action…
git:20261020.3a9fd86 · audit A · 4 stars

Every file in procesio-externals/procesio-cli

Other files named sql-server-optimizer

sql-server-optimizer SKILL.md skill
procesio-externals/procesio-cli · plugin/skills/sql-server-optimizer/SKILL.md · Analyze and optimize SQL Server T-SQL, including SQL executed by PROCESIO. Use when reviewing a query, procedure…
v1.0.1 · audit A · 4 stars

Browse by kind, by grade A, or by owner.