sqlmigration-objects-review

sqlmigration-objects-review is a skill for Claude Code, Codex from vanterx/mssql-performance-skills. It costs 133 tokens per session (3,485 once invoked), scanned A, original, MIT.

A migration checklist for SQL Server instance-level operational objects. These are jobs, alerts, linked servers, mail settings, triggers, and similar objects that are stored outside the database itself.

In plain words
What is it for?
Use it when moving SQL Server to check SQL Agent jobs and schedules, operators and alerts, linked servers, Database Mail, backup paths, custom errors, server triggers, Extended Events sessions, and endpoints.
Why use it?
A database backup or restore does not carry these objects to the new SQL Server instance. The review helps find the jobs, connections, notifications, and settings that could be missing or misconfigured after migration.

Skill for Claude CodeCodex

Part of the mssql-performance-skills plugin — 26 skills, 3 hooks, 1 MCP server shipped together

Install

Getting it into your agent

One page per mod, every tool's command on it. A separate URL per tool would split the same page into five that compete with each other.

agentmods
npx agentmods add skills/vanterx/mssql-performance-skills/sqlmigration-objects-review
Any agent
npx skills add vanterx/mssql-performance-skills --skill sqlmigration-objects-review
Clone the repo
git clone --depth 1 https://github.com/vanterx/mssql-performance-skills

Made for: Claude Code, Codex.

Or install mssql-performance-skills, the plugin that ships this one along with the rest of its 26 skills, 3 hooks, 1 MCP server.

Wrote this? Show the measurements

A badge with what this costs and how it scanned, read live from this page, so it follows the numbers instead of freezing them. Markdown for a README, HTML for a documentation site or a project page.

agentmods badge for sqlmigration-objects-review

README.md
[![agentmods](https://agentmods.dev/badge/skills/vanterx/mssql-performance-skills/sqlmigration-objects-review.svg)](https://agentmods.dev/skills/vanterx/mssql-performance-skills/sqlmigration-objects-review)
Your own site
<a href="https://agentmods.dev/skills/vanterx/mssql-performance-skills/sqlmigration-objects-review"><img src="https://agentmods.dev/badge/skills/vanterx/mssql-performance-skills/sqlmigration-objects-review.svg" alt="Measured on agentmods" height="20"></a>
Per session 133 Skills are progressive disclosure: only the name and description are preloaded; the body loads when the skill is used.
When invoked 3,485 The whole file, excluding the scripts and references it only reads on demand.
Security scan A 0 findings. Scan, not verified.
Origin original No closer match found in the catalogue.
Token cost

What it costs to keep this loaded

Counted locally with the o200k_base tokenizer, which is exact for GPT models; Claude uses its own tokenizer and its counts differ. Treat this as one consistent yardstick across the catalogue rather than a bill. Prices are per million input tokens.

ModelPer sessionOnce invoked
Fable 5 $0.00133 $0.03485
Opus 5 $0.00067 $0.01742
Sonnet 5 $0.00027 $0.00697
Haiku 4.5 $0.00013 $0.00348

Measured 3d ago against content hash 7bebe5f64027, method: parsed. Prices are Anthropic first-party input rates as of 2026-08-30, from the pricing page.

Security

Grade A, and why

sqlmigration-objects-review scanned grade A with 0 findings against 26 rules in 11 categories — prompt injection, anti-refusal, data exfiltration, privilege escalation, supply chain, agent snooping, system-prompt leakage, SSRF and excessive agency — measured 3d ago.

A static scan of the body, not an audit. Every finding is printed with the line that produced it so you can judge whether it matters here. A mod is markdown that instructs an agent; that is exactly why what it instructs is worth reading.

Nothing flagged

None of the 26 patterns this scan looks for appear in this file: no shell pipes, no recursive deletes, no credential paths, no hidden text, no instruction-override or anti-refusal phrasing, no agent-config snooping. That is not a guarantee, it is the absence of the things that are checkable.

skills/sqlmigration-objects-review/SKILL.md · 298 lines

How it starts

The opening of the file, as written. The whole thing — 298 lines — stays where its author put it; the contents beside it link to each section on GitHub.

sqlmigration-objects-review

Purpose

Reviews the operational-object family of a SQL Server migration — the slice sqlmigration-review dispatches here rather than checking itself. This skill owns 16 checks (M1–M16) covering whether instance-level operational objects survive a backup/restore or log shipping/Always On AG seeding migration, since none of these objects travel with a database backup/restore — they live in msdb/master at the instance level and must be migrated separately.

  • SQL Agent (M1–M6) — jobs referencing the wrong database, job owner login missing, operators with stale notification addresses, alerts tied to error numbers not raised on target, proxy account credential mapping, job schedule timezone drift
  • Linked Servers (M7–M9) — provider availability on target, data source connectivity, collation-compatible setting
  • Database Mail (M10–M11) — mail profile/account not migrated, SMTP relay allow-list missing the new instance
  • Backup Infrastructure (M12) — backup device path unreachable from target
  • Custom Errors (M13)sys.messages custom error definitions not migrated
  • Server Triggers (M14) — server-level DDL/logon triggers not migrated
  • XE Sessions (M15) — Extended Events session definitions not migrated
  • Endpoints (M16) — non-AG endpoints (Service Broker, SOAP legacy) not migrated

All fix recipes use native T-SQL system objects/scripts, the in-box SqlServer PowerShell module, and sqlcmd/bcp — no third-party module is referenced or required.

Input

Accepts any of the following:

  1. Source and target server facts pasted as text — job definitions, linked server lists, mail profile names, target platform
  2. Capture script output (.txt/.csv) — see scripts/capture-objects-facts.sql
  3. Natural-language description — "migrating 15 Agent jobs and 3 linked servers to a new instance"
  4. File path to a directory of exported artifacts — SSMS Generate Scripts output for Agent jobs/linked servers, sp_helplinkedsrvlogin dumps

Read the full file on GitHub · 298 lines

Files

What ships with it

6 files beside SKILL.md in the same directory: the scripts, references and assets a skill reads on demand. Not counted in the per-session cost; read them before you install if any of them is executable.

Changes

What this file has done since we first saw it

Hashed on every crawl. A supply-chain change to an agent config is a question of when, not whether, so the history is kept rather than the latest state alone.

  1. 3d ago First seen · 298 lines · 133 tokens per session scan A 7bebe5f64027

Subscribe to this mod's changes

sqlmigration-objects-review is a skill published in the GitHub repository vanterx/mssql-performance-skills (5 stars, last pushed 1mo ago), licensed MIT. It adds 133 tokens to every session and 3,485 once invoked, about $0.0007 per session on Opus 5. A static security scan graded it A with 0 findings. No closer match exists in the catalogue, so it is treated as the original; first seen 2026-08-31.

Related

Other skills, from other repositories

PostgreSQL Database Administration

Comprehensive PostgreSQL database administration skill for customer support tech enablement, covering database design, optimization, performance tuning, backup/recovery, and advanced query techniques.

manutej/luxor-claude-marketplace · 37 tokens

schema-exploration

Lists tables, describes columns and data types, identifies foreign key relationships, and maps entity relationships in a database. Use when the user asks about database schema, table structure, column types, what tables exist, ERD, foreign keys, or how entities relate.

langchain-ai/deepagents · 57 tokens

agent-platform-rag-engine-management

Manage and query Agent Platform RAG Engine Corpora and retrieve grounded contexts using the Google GenAI SDK. Use when listing RAG corpora or files, inspecting a corpus, retrieving contexts, or generating content grounded in a RAG corpus. Do not use for standard database queries (use SQL/Spanner skills), Google…

google/skills · 85 tokens

deploy-docker-compose

Run the Omnigent server as a Docker compose stack (server + Postgres) on any Docker host — your laptop, a VPS, EC2 by hand, or as the base layer of any container-platform deploy. Invoke when the user wants to build the image, bring up the compose stack, debug the stack on a host they already have, or extend the stack…

omnigent-ai/omnigent · 84 tokens

dsql

Build with Aurora DSQL — manage schemas, execute queries, handle migrations, diagnose query plans, diagnose cluster performance, load data, and develop applications with a serverless, distributed SQL database. Covers IAM auth, multi-tenant patterns, MySQL-to-DSQL and PostgreSQL-to-DSQL schema conversion, foreign key…

awslabs/agent-plugins · 229 tokens

sql-translate

Translate SQL queries between database dialects (Snowflake, BigQuery, PostgreSQL, MySQL, etc.).

AltimateAI/altimate-code · 26 tokens