SQL Rig Free: SQL Server Starter Kit for AI Agents

    1

    Safe SQL Server defaults for your AI agent: DBA rules, read-only diagnostics, and dry-run templates for Agent jobs and stored procedures.

    Free

    1 useSecurity scanned

    Works with the AI Agents you already use

    Claude CodeClaude CodeCursorCursorCodex CLICodex CLIMuseMuseDotsDots+21 more

    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.

    The agent runs wait-stats-delta.sql, blocking-chain.sql

    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 = 1 or -WhatIf until 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. 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. 2

      Sign in to Agensi

      Your agent shows a sign-in link. Sign in and click Allow.

    3. 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

    SSMS or sqlcmd or Azure Data Studio
    PowerShell 5.1+

    Permissions

    Read Files

    The skill never connects to a server. You run the scripts yourself.

    Listed1 month ago
    Updated14 days ago

    What's inside

    Frequently Asked Questions

    No. It gives the agent rules and scripts; you run them.

    Diagnostics are read-only. Every write script defaults to dry run.

    MIT.

    New in Data & Databases