- Home
- Skills
- Data & Databases
- SQL Rig Free: SQL Server Starter Kit for AI Agents
SQL Rig Free: SQL Server Starter Kit for AI Agents
Safe SQL Server defaults for your AI agent: DBA rules, read-only diagnostics, and dry-run templates for Agent jobs and stored procedures.
Free
Works with the AI Agents you already use
SQL Rig Free: SQL Server Starter Kit for AI Agents
Example session with this skill installed
The order database is slow right now. Find out why.
- Read your context and instructions
- Compiled the sql rig free
The agent runs wait-stats-delta.sql, blocking-chain.sql, and expensive-queries.sql, all read-only. It summarizes the top waits since the last snapshot, identifies the head blocker and the sessions it is holding up, and lists the heaviest queries by CPU, duration, and reads with their plan handles. It then proposes next steps, such as reviewing the blocking session's open transaction or adding a covering index, and states that any change would start from a dry-run template with @DryRun = 1. It does not run any write, kill any session, or change any setting without explicit confirmation.
Connects securely to your tools. The creator never sees your data.
About this skill
AI agents write T-SQL fast and break production just as fast. SQL Rig Free gives your agent a set of rules and tested scripts to work from, so the first thing it reaches for is a read-only diagnostic or a dry-run template, not an unfiltered DELETE.
What it does
- Loads DBA rules into the agent: preferred toolchain, required shape for every write (NOCOUNT, XACT_ABORT, TRY/CATCH, idempotent guards), and a list of actions that need your explicit confirmation.
- Routes common requests to tested scripts instead of improvised SQL.
- Keeps every write behind
@DryRun = 1or-WhatIfuntil you read the plan and flip the flag.
What's included (13 working files)
- Agent rules: SQL Server DBA system prompt.
- Read-only T-SQL: blocking chains and head blockers, top queries by CPU, duration, and reads, wait stats delta, linked-server connectivity test, surface-area audit.
- Templates: Agent job with category and schedule (idempotent, dry-run default), production-safe stored procedure, orphaned-user detection with optional remap.
- PowerShell: connection smoke test, blocking snapshot to CSV.
- Guardrails: production safety rules and a pre-change review checklist.
Requirements
- SQL Server 2016 or later, or Azure SQL Managed Instance. Each script states its minimum version and required permissions in its header.
- PowerShell 5.1 or later for the .ps1 files.
- You run the scripts yourself (SSMS, sqlcmd, Azure Data Studio, PowerShell). The skill never connects to a server.
Built by Scott Coffey, sqlrig.com. Source and MIT license: https://github.com/scottkcoffey-a11y/sqlrig-free
Does not connect directly to servers. Only supports SQL Server/T-SQL. Requires user execution via SSMS, sqlcmd, or PowerShell.
How to use
- 1
Connect your agent to the Agensi MCP
Copy the prompt and paste it into Claude, ChatGPT, Cursor or any agent that supports MCP. It sets up the connection for you. Manual setup
- 2
Sign in to Agensi
Your agent shows a sign-in link. Sign in and click Allow.
- 3
Ask for what you need
Your agent loads this skill and uses it on your task. It always asks before any payment.
Reviews
No reviews yet
Be one of the first to try it. Every listed skill goes through the trust checks below.
Security scanned
Checked by our 8-point scan before listing
1 use
Times used to date
Free forever
No account required to browse
Trust & safety
Security scan
Security scan passed 14 days ago
- Free with an Agensi account
Requires
Permissions
The skill never connects to a server. You run the scripts yourself.