MCP Servers / database / MSSQL MCP Server

MSSQL MCP Server

none★ 15database

Connect to and interact with Microsoft SQL Server databases.

Install

How to run this server

[ { "cmd": "npx -y @smithery/cli", "imports": [] } ]

server path: mssql-mcp-server-2

Tools

What this server exposes

query

Execute a read-only SQL query on the MSSQL database

execute

Execute a SQL statement that modifies data (INSERT, UPDATE, DELETE, etc.)

list_tables

List all tables in the database

describe_table

Get schema information for a specific table

Configuration

Environment & auth

authnone

envMSSQL_HOST

envMSSQL_PORT

envOPENAI_API_KEY

Resources