SqlServer.Rules T-SQL Analyzer

listing.by

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

state.local.long (state.local.title)listing.badge.runs_with

listing.install

listing.local.explain

dnx ErikEJ.DacFX.TSQLAnalyzer.Cli --yes

listing.local.needs listing.local.note

act.add_to a11y.new_tabact.add_to a11y.new_tab

listing.share.h

listing.share.p_local

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

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

listing.can

  • 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

listing.tools

listing.notools.local

listing.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?

listing.setup.h

listing.setup.local

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
  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"
      ]
    }
  }
}
  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

Add to Cursor a11y.new_tab

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"
      ]
    }
  }
}

Needs .NET 10 on your computer.

VS Code

Install in VS Code a11y.new_tab

Or from a terminal:

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

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"
      ]
    }
  }
}

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"
      ]
    }
  }
}
  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

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

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

Needs .NET 10 on your computer.

Gemini CLI

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

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"
      ]
    }
  }
}

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

Needs .NET 10 on your computer.

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

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

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.

listing.em.h

listing.em.lead_local listing.em.how

listing.em.badge

em.prev_lightem.prev_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>

listing.em.badge_note

listing.em.widget

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

listing.em.widget_note

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>

listing.em.iframe_note

JSON

listing.em.json_local

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

listing.em.fields

listing.related

listing.more_in

  • pgEdge Postgres

    pgEdge

    state.local.label (state.local.title)

    Query PostgreSQL databases from MCP clients with read-only SQL, hybrid pgvector and BM25 search, and a natural language agent.

    mcp.tc/i/pgedge-postgres

  • DBConvert Streams

    DBConvert

    state.local.label (state.local.title)

    Run read-only SQL across PostgreSQL, MySQL, S3 buckets and local Parquet, CSV or JSON files in a single query.

    mcp.tc/i/dbconvert-streams

  • ClickHousevf.sr

    Databases & Backend

    state.local.label (state.local.title)

    Run read-only SQL and explore databases and tables on any ClickHouse cluster or in the embedded chDB engine.

    mcp.tc/i/clickhouse

  • DBX

    t8y2

    state.local.label (state.local.title)

    Query databases from AI agents using the connections already configured in the DBX database client.

    mcp.tc/i/dbx

  • Convex

    Databases & Backend

    state.local.label (state.local.title)

    Inspect tables, query data and run functions in Convex deployments from your AI assistant.

    mcp.tc/i/convex

  • dbt

    dbt Labs

    state.local.label (state.local.title)

    Give assistants dbt project context: models, lineage, Semantic Layer metrics, Discovery API data and dbt CLI commands.

    mcp.tc/i/dbt

listing.disclaimer_checked