We and selected third parties use cookies or similar technologies for technical purposes and, with your consent, to analyze how the site is used.

You can freely give, refuse or withdraw your consent at any time.

SqlServer.Rules T-SQL Analyzer

MCP server by ErikEJ

Analyze T-SQL scripts for design, naming and performance problems using more than 140 static code analysis rules.

Runs locally (Runs on your machine: its page has the install command)Runs with dnx

Install SqlServer.Rules T-SQL Analyzer

Runs on your machine. Your client starts it with this command:

dnx ErikEJ.DacFX.TSQLAnalyzer.Cli --yes -- -mcp

Needs .NET 10 on your computer. The setup steps below show where the command goes in each client.

Share this server

Opens this page, with the install command and setup steps.

mcp.tc/i/sqlserver-rules-t-sql-analyzer

About

Runs the SqlServer.Rules static analysis rule set against T-SQL scripts from your AI assistant. The rules check for design, naming and performance issues and flag bad practices, so you can get feedback on SQL code in chat, for example in GitHub Copilot Chat.

It runs locally over stdio as the .NET tool ErikEJ.DacFX.TSQLAnalyzer.Cli, started with dnx and the -mcp argument. The README lists one-click setup for VS Code and Visual Studio. No sign-in or API key is mentioned.

What you can do

  • Analyze T-SQL scripts against more than 140 code analysis rules
  • Find design, naming and performance issues in SQL code
  • Get SQL feedback inside GitHub Copilot Chat
  • Install from VS Code or Visual Studio with one click

Tools

Local servers list their tools once they’re running, and this one doesn’t publish its list in advance. Your client shows them after you add it.

Example prompts

  • Analyze this T-SQL script for bad practices

  • Check my stored procedure for naming and performance issues

  • Review the SQL files in this project with the T-SQL analyzer

  • Which design problems does this CREATE TABLE script have?

Set up

Every client starts SqlServer.Rules T-SQL Analyzer on your machine with the same command. Pick yours; the page remembers your choice.

Claude Code

  1. Run this in a terminal, in your project folder:
claude mcp add --transport stdio sqlserver-rules-t-sql-analyzer -- dnx ErikEJ.DacFX.TSQLAnalyzer.Cli --yes -- -mcp
  1. Start Claude Code and type /mcp. sqlserver-rules-t-sql-analyzer should show as connected.

Add --scope user to make it available in every project.

Claude Desktop

  1. Open Settings → Developer → Edit Config. It opens claude_desktop_config.json. Add:
claude_desktop_config.json
{
  "mcpServers": {
    "sqlserver-rules-t-sql-analyzer": {
      "command": "dnx",
      "args": [
        "ErikEJ.DacFX.TSQLAnalyzer.Cli",
        "--yes",
        "--",
        "-mcp"
      ]
    }
  }
}
  1. Save the file and restart Claude Desktop.

Needs .NET 10 on your computer. The file lives in ~/Library/Application Support/Claude/ on macOS and %APPDATA%\Claude\ on Windows.

Cursor

Or add it by hand to ~/.cursor/mcp.json (all projects) or .cursor/mcp.json (this project):

mcp.json
{
  "mcpServers": {
    "sqlserver-rules-t-sql-analyzer": {
      "command": "dnx",
      "args": [
        "ErikEJ.DacFX.TSQLAnalyzer.Cli",
        "--yes",
        "--",
        "-mcp"
      ]
    }
  }
}

Needs .NET 10 on your computer.

VS Code

Or from a terminal:

code --add-mcp '{"name":"sqlserver-rules-t-sql-analyzer","type":"stdio","command":"dnx","args":["ErikEJ.DacFX.TSQLAnalyzer.Cli","--yes","--","-mcp"]}'

Or commit it to the repo in .vscode/mcp.json:

.vscode/mcp.json
{
  "servers": {
    "sqlserver-rules-t-sql-analyzer": {
      "type": "stdio",
      "command": "dnx",
      "args": [
        "ErikEJ.DacFX.TSQLAnalyzer.Cli",
        "--yes",
        "--",
        "-mcp"
      ]
    }
  }
}

Needs .NET 10 on your computer.

Devin Desktop

  1. Add it to ~/.config/devin/mcp_config.json (macOS and Linux) or %APPDATA%\devin\mcp_config.json (Windows):
mcp_config.json
{
  "mcpServers": {
    "sqlserver-rules-t-sql-analyzer": {
      "command": "dnx",
      "args": [
        "ErikEJ.DacFX.TSQLAnalyzer.Cli",
        "--yes",
        "--",
        "-mcp"
      ]
    }
  }
}
  1. Refresh the MCP server list in Cascade.

Devin Desktop is the new name for Windsurf.

Codex

codex mcp add sqlserver-rules-t-sql-analyzer -- dnx ErikEJ.DacFX.TSQLAnalyzer.Cli --yes -- -mcp

Or edit ~/.codex/config.toml directly:

config.toml
[mcp_servers.sqlserver-rules-t-sql-analyzer]
command = "dnx"
args = ["ErikEJ.DacFX.TSQLAnalyzer.Cli", "--yes", "--", "-mcp"]

Needs .NET 10 on your computer.

Gemini CLI

gemini mcp add sqlserver-rules-t-sql-analyzer dnx -- ErikEJ.DacFX.TSQLAnalyzer.Cli --yes -- -mcp

This adds it to the current project. Add -s user to use it everywhere.

Any client

Most clients that start local servers accept this shape:

{
  "mcpServers": {
    "sqlserver-rules-t-sql-analyzer": {
      "command": "dnx",
      "args": [
        "ErikEJ.DacFX.TSQLAnalyzer.Cli",
        "--yes",
        "--",
        "-mcp"
      ]
    }
  }
}

Zed puts servers under context_servers in its settings, with the same command, args and env fields.

Needs .NET 10 on your computer.

Embed

Show SqlServer.Rules T-SQL Analyzer in a README or on your site. Each embed links to this page, uses the server’s own install command, and sets no cookies. How embeds work

The card, the iframe and the JSON are in English. Add ?lang=it, fr, de or es to their address for another language.

README badge

Badge preview, lightBadge preview, dark
Markdown
[![SqlServer.Rules T-SQL Analyzer on mcp.tc](https://mcp.tc/i/sqlserver-rules-t-sql-analyzer/badge.svg)](https://mcp.tc/i/sqlserver-rules-t-sql-analyzer)
HTML
<a href="https://mcp.tc/i/sqlserver-rules-t-sql-analyzer"><img src="https://mcp.tc/i/sqlserver-rules-t-sql-analyzer/badge.svg" alt="SqlServer.Rules T-SQL Analyzer on mcp.tc" height="20"></a>

It follows the reader’s light or dark mode. Add ?theme=light or ?theme=dark to fix it, or ?style=compact to show the mark without the word.

Website card

HTML
<script src="https://mcp.tc/w/sqlserver-rules-t-sql-analyzer.js" async></script>

The card appears where the tag is. Add data-theme="dark" or data-size="compact" to the tag to change it. The file holds everything it needs, so it makes no other requests and sets no cookies.

iframe

HTML
<iframe src="https://mcp.tc/embed/sqlserver-rules-t-sql-analyzer" title="SqlServer.Rules T-SQL Analyzer on mcp.tc" width="420" height="200" loading="lazy" allow="clipboard-write" style="border:0;border-radius:8px;max-width:100%"></iframe>

Use it on pages that don’t allow scripts. Add ?theme=light or ?theme=dark to the address to fix the colors.

JSON

The listing as data for your own pages and tools: name, tagline, install command, tools and the “Add to” links. Any site can read it (CORS is open).

https://mcp.tc/i/sqlserver-rules-t-sql-analyzer.json

What each field means

AI prompt

Paste this into an AI coding assistant, such as Claude Code or Cursor, and it adds the SqlServer.Rules T-SQL Analyzer card to your site.

Markdown
Add the mcp.tc card for SqlServer.Rules T-SQL Analyzer, an MCP server, to my website. It is one static script: no build step, no package to install, no cookies.

Put this tag where the card should appear. The card renders right before it:

```html
<script src="https://mcp.tc/w/sqlserver-rules-t-sql-analyzer.js" async></script>
```

To show the card somewhere else, put this placeholder there and load the same script once, for example before `</body>`. Keep the link inside: visitors without JavaScript see it.

```html
<div data-mcptc="sqlserver-rules-t-sql-analyzer"><a href="https://mcp.tc/i/sqlserver-rules-t-sql-analyzer">SqlServer.Rules T-SQL Analyzer on mcp.tc</a></div>
```

Options:
- `data-theme="light"` or `"dark"` on the tag or the placeholder fixes the colors. Without it, the card follows the visitor’s light or dark mode.
- `data-size="compact"` gives a smaller card without the tagline.
- The CSS variable `--mcptc-max-width` on the placeholder or a parent sets the width (default `520px`).
- `?lang=` on the script URL sets the card’s language: `en`, `it`, `fr`, `de` or `es`.

If the site has a Content Security Policy, allow `script-src https://mcp.tc` and `img-src data:` (the icon is inline).

For a README or other Markdown docs, use the badge instead:

```markdown
[![SqlServer.Rules T-SQL Analyzer on mcp.tc](https://mcp.tc/i/sqlserver-rules-t-sql-analyzer/badge.svg)](https://mcp.tc/i/sqlserver-rules-t-sql-analyzer)
```

Reference: https://mcp.tc/embed

Change history

It runs on your computer and has no package we can follow. Edits by its owner show up here.

Follow SqlServer.Rules T-SQL Analyzer and we’ll email you when something changes.

Nothing recorded yet. Edits by the server’s owner will show up here.

FAQ

Can I paste mcp.tc/i/sqlserver-rules-t-sql-analyzer into my MCP client?

No. SqlServer.Rules T-SQL Analyzer runs on your own computer, started by your client, so it has no web address to connect to. The quick link is the page to share; the install command is dnx ErikEJ.DacFX.TSQLAnalyzer.Cli --yes -- -mcp.

Does SqlServer.Rules T-SQL Analyzer need an API key?

No. It doesn’t declare any keys or environment variables. It runs with your user account’s permissions, so check what its tools can reach.

Is SqlServer.Rules T-SQL Analyzer a remote or a local server?

Local. Your client starts it as a process on your computer with dnx ErikEJ.DacFX.TSQLAnalyzer.Cli --yes -- -mcp, which needs .NET.

What can SqlServer.Rules T-SQL Analyzer do?

You can analyze T-SQL scripts against more than 140 code analysis rules, find design, naming and performance issues in SQL code and get SQL feedback inside GitHub Copilot Chat.

Which clients can use it?

Any client that starts local servers: Claude Code, Claude Desktop, Cursor, VS Code, Devin Desktop, Codex, Gemini CLI, Zed and others. claude.ai and ChatGPT only connect to remote servers.

Does mcp.tc track changes to SqlServer.Rules T-SQL Analyzer?

Partly. SqlServer.Rules T-SQL Analyzer runs on your computer and has no package we can follow, so its History tab shows only edits by its owner. Follow the listing to get an email when it changes.

Who wrote this page?

mcp.tc’s robot read SqlServer.Rules T-SQL Analyzer’s public metadata (its package and repository pages), and an AI model drafted the text from it. A person reviews anything the checks can’t confirm. The text can still be wrong, so if you spot a mistake, use Report this listing on this page.

mcp.tc isn’t affiliated with ErikEJ. This page was built from SqlServer.Rules T-SQL Analyzer’s public metadata, last checked on 4 Oct 2026, and an AI model wrote the description, so it can be wrong. Names and marks belong to their owners. Something off? Report this listing.