# T-SQL Analyzer

> Use this tool when you need to analyze and optimize T-SQL code for improved performance and readability. It solves problems related to query optimization, error detection, and code refinement, taking T-SQL scripts as input and producing detailed analysis reports as output. Ideal for database administrators and developers working with Microsoft SQL Server, it helps streamline database operations and resolve performance bottlenecks.

Canonical page: https://skillsregistry.net/skills/erikej-sqlserver-rules  
JSON: https://api.skillsregistry.net/v1/skills/erikej-sqlserver-rules

## Description

140+ T-SQL static code analysis rules for SQL Database Projects

## Trust

- **Trust score (0–1):** 0.99
- **Verification tier:** verified
- **Last scanned:** 2026-09-19

## Facts

- **Version:** 1.0.0
- **Skill type:** atomic
- **Execution layer:** mcp-remote
- **Runtime environment:** api
- **Category:** database
- **Updated:** 2026-09-19

## Source

- **Source listing:** [Glama](https://glama.ai/mcp/servers/o4amtv90ib)
- **Repository:** <https://github.com/ErikEJ/SqlServer.Rules>

## Use it

Resolve this record through the SkillsRegistry MCP server (no auth, read-only):

```
claude mcp add --transport http --scope user skillsregistry https://api.skillsregistry.net/mcp
```

```json
{
  "jsonrpc": "2.0",
  "id": 1,
  "method": "tools/call",
  "params": {
    "name": "get_skill",
    "arguments": {
      "slug": "erikej-sqlserver-rules"
    }
  }
}
```

REST: `GET https://api.skillsregistry.net/v1/skills/erikej-sqlserver-rules` · pull for local use: `GET https://api.skillsregistry.net/v1/skills/erikej-sqlserver-rules/pull`

---
SkillsRegistry indexes agent skills from public registries and GitHub. Skills we have analysed are scanned with Circle-IR and scored on six dimensions; each listing states its scan coverage. More: https://skillsregistry.net/llms.txt