MCP Sqlserver Pro

Name: MCP Sqlserver Pro
Author: jensenloke

by jensenloke

Comprehensive MCP Server for Microsoft SQL Server - Connect AI assistants to SQL Server databases with 23 advanced tools for schema exploration, query execution, stored procedure management, and database operations. Full CRUD support for tables, views, indexes, and procedures through the Model Context Protocol.

8 23 tools GitHub

No known CVEs

No license

Stale

Last commit 499d ago

Works with most clients

Transport: stdio, sse, http

23 tools · ~1.6k tok

Grade C · 0.8% of 200K ctx

MCPpedia last refreshed this data 1d ago

Edit this pageView history

MCP Sqlserver Pro is an MCP server that comprehensive MCP Server for Microsoft SQL Server - Connect AI assistants to SQL Server databases with 23 advanced tools for schema exploration, query execution, stored procedure management, and database operations. Full CRUD support for tables, views, indexes, and procedures through the Model Context Protocol. Its tool list has not been published yet over stdio, sse and http, requires no API key, and scores 45/100 on MCPpedia's security, maintenance and efficiency rubric.

Data

Step 1

Install in your client

Config is the same across clients - only the file and path differ.

Supported in Claude Desktopstdio, sse, http · Node 18+

Paste into ~/Library/Application Support/Claude/claude_desktop_config.json

{
  "mcpServers": {
    "mssql": {
      "cwd": "/path/to/mcp-sqlserver",
      "env": {
        "MSSQL_USER": "your-username",
        "MSSQL_SERVER": "your-server",
        "MSSQL_DATABASE": "your-database",
        "MSSQL_PASSWORD": "your-password"
      },
      "args": [
        "/path/to/mcp-sqlserver/src/server.py"
      ],
      "command": "python3"
    }
  }
}

Are you the author?

Add this badge to your README to show your security score and help users find safe servers.

Embed in your READMEAbout badges →

[![MCPpedia Score](https://mcppedia.org/api/badge/mcp-sqlserver-pro)](https://mcppedia.org/s/mcp-sqlserver-pro)

Read me

What Mcp Sqlserver Pro does

A Model Context Protocol (MCP) server that provides comprehensive access to Microsoft SQL Server databases. This enhanced server enables Language Models to inspect database schemas, execute queries, manage database objects, and perform advanced database operations through a standardized interface.

Test This Server

No automated test available for this server. Check the GitHub README for setup instructions.

Scored, not listed

Why this score

Five weighted categories - click any category to see the underlying evidence.

Score breakdown

45/100across 5 weighted dimensions

How we score →

0255075100

−55

Security

Maintenance

Efficiency

Documentation

Compatibility

Categoriesclick a row to see evidence

Security

OSV.dev

No known CVEs.

No package registry to scan.

Inventory

Tools (23)

Click any tool to inspect its schema.

~1.6k tokens total

Inventory

Resources (2)

table_data

Access table data in CSV format

mssql://{table_name}/data

view_data

Access view data in CSV format

mssql://{view_name}/data

Community

Reviews

Be the first to review

Have you used this server?

Share your experience - it helps other developers decide.

How easy was setup?Did it work reliably?How was the documentation?

Frequently Asked Questions

Is Mcp Sqlserver Pro safe to use?: Mcp Sqlserver Pro has no known CVEs as of the latest MCPpedia security scan. Authentication requirements were not detected automatically - check the project's documentation before connecting in a shared environment.
How do I install Mcp Sqlserver Pro?: Mcp Sqlserver Pro supports copy-paste install configs on its MCPpedia page for Claude Desktop, Cursor, and Claude Code. Scroll to the Quick Install section and select your client.
What can Mcp Sqlserver Pro do?: Mcp Sqlserver Pro provides 23 tools: read_query, write_query, list_tables, describe_table, create_table and 18 more. See the full tools list on the server page for descriptions and parameters.
What AI clients work with Mcp Sqlserver Pro?: Mcp Sqlserver Pro is compatible with claude-desktop, cursor, claude-code. It uses stdio and sse and http transport.
Is Mcp Sqlserver Pro actively maintained?: Mcp Sqlserver Pro is not actively maintained - last commit was 499 days ago. It has 8 GitHub stars.

Similar servers

Others in data

View all →

Dbhub96

Token-efficient database MCP server for PostgreSQL, MySQL, MariaDB, SQL Server, Oracle, SQLite

3.7k 2

Vibe Assistant95

A cross-platform desktop application for managing AI Agents and MCP Servers. 一款用于管理AI智能体与MCP服务器的跨平台桌面应用程序。

170 3

Firecrawl Mcp Server95

Firecrawl, the context API for AI agents: search, scrape, interact with the web, plus paper search.

7.7k 4

Apify Mcp Server95

Extract data from any website with thousands of scrapers, crawlers, and automations on Apify Store ⚡

12.8k 1

MCP Security Weekly

Get CVE alerts and security updates for Mcp Sqlserver Pro and similar servers.

Community

Discussion

Start a conversation

Ask a question, share a tip, or report an issue.

Has anyone used this with Cursor?How do you handle auth?Any alternatives?

{ "mcpServers": { "mssql": { "cwd": "/path/to/mcp-sqlserver", "env": { "MSSQL_USER": "your-username", "MSSQL_SERVER": "your-server", "MSSQL_DATABASE": "your-database", "MSSQL_PASSWORD": "your-password" }, "args": [ "/path/to/mcp-sqlserver/src/server.py" ], "command": "python3" } } }

Frequently Asked Questions

Is Mcp Sqlserver Pro safe to use?

Mcp Sqlserver Pro has no known CVEs as of the latest MCPpedia security scan. Authentication requirements were not detected automatically - check the project's documentation before connecting in a shared environment.

How do I install Mcp Sqlserver Pro?

Mcp Sqlserver Pro supports copy-paste install configs on its MCPpedia page for Claude Desktop, Cursor, and Claude Code. Scroll to the Quick Install section and select your client.

What can Mcp Sqlserver Pro do?

Mcp Sqlserver Pro provides 23 tools: read_query, write_query, list_tables, describe_table, create_table and 18 more. See the full tools list on the server page for descriptions and parameters.

What AI clients work with Mcp Sqlserver Pro?

Mcp Sqlserver Pro is compatible with claude-desktop, cursor, claude-code. It uses stdio and sse and http transport.

Is Mcp Sqlserver Pro actively maintained?

Mcp Sqlserver Pro is not actively maintained - last commit was 499 days ago. It has 8 GitHub stars.