Microsoft SQL Server MCP Server

Server Configuration

Describes the environment variables required to run the server.

NameRequiredDescriptionDefault
MSSQL_USERYesSQL Server username
MSSQL_SERVERYesSQL Server address/hostnamelocalhost
MSSQL_DATABASEYesSQL Server database name
MSSQL_PASSWORDYesSQL Server password

Schema

Prompts

Interactive templates invoked by user choice

NameDescription

No prompts

Resources

Contextual data attached and managed by the client

NameDescription

No resources

Tools

Functions exposed to the LLM to take actions

NameDescription
execute_sql

Execute an SQL query on the SQL Server