SQL Rig: SQL Server Toolkit for AI Agents

SQL Rig is the toolkit I use to let AI agents work on production-adjacent SQL Server without guessing. It gives the agent strict rules, a task prompt for each common job, and tested T-SQL and PowerShell to start from. Every write defaults to dry run, every create is idempotent, and every script header states purpose, minimum version, permissions, and rollback.

What it does

• Loads DBA rules and a forbidden-patterns list. The agent rejects and rewrites output that matches a known bad pattern.
• Routes each request to a task prompt with defined steps and deliverables: blocking, Agent jobs, linked servers, proc refactors, index review, backup and restore, security audit.
• Starts from tested scripts instead of improvised SQL, and gives rollback steps for every change.

What's included (47 files)

• Prompts (10): DBA system prompt, Cursor rules, CLAUDE.md block, and 7 task prompts.
• T-SQL (19): blocking chains, expensive queries (plan cache and Query Store), wait stats delta, Agent job inventory and template, multi-step Agent jobs (T-SQL, PowerShell, and CmdExec steps with explicit success and failure flow), failure alerts and operators, linked-server add, test, and OPENQUERY patterns, batched DELETE and UPDATE with row caps, idempotent upsert, safe stored procedure template, least-privilege permission checks, orphaned users, unused indexes, sampled fragmentation with REORGANIZE or REBUILD plans, statistics maintenance, surface-area audit.
• PowerShell (7): smoke test, backup with CHECKSUM and VERIFYONLY, Agent job export, script-folder runner with per-file transactions, blocking snapshot to CSV or JSON, linked-server test, Agent alert installer. All support -WhatIf and never hardcode passwords.
• Guardrails (4): production safety rules, forbidden patterns, human review checklist, rollback templates.
• SQL Server 2025 vector preview (3): version-gated VECTOR column and DiskANN demo, RAG retrieval prompt, and notes that stop the agent from inventing vector syntax.
• Quickstart, changelog, license.

Requirements

• SQL Server 2016 or later, or Azure SQL Managed Instance. Most scripts target 2019 and later; headers state the minimum. Vector files need SQL Server 2025 or Azure SQL.
• PowerShell 5.1 or later. The SqlServer module and dbatools are optional.
• You run the scripts yourself. The skill never connects to a server.

Updates ship through Agensi to every buyer. Built by Scott Coffey, sqlrig.com.