Mssqlclient MCP Server

Unclaimed

by aadversteeg

A Microsoft SQL Server client implementing the Model Context Protocol (MCP). This server provides SQL query capabilities through a simple MCP interface.

Install

docker run -d --name mssql-mcp -e "MSSQL_CONNECTIONSTRING=Server=your_server;Database=your_db;User Id=your_user;Password=your_password;TrustServerCertificate=True;" mssqlclient-mcp-server:latest

Unclaimed listing

Is this your MCP server?

This listing was auto-indexed from the public record. Claim it to edit the page, set compatibility and unlock growth tools. Takes under two minutes.

Claim this server

Tools (40)

DatabaseConfiguration__EnableExecuteQuery

Enable executequery / executequeryindatabase tools

DatabaseConfiguration__EnableExecuteStoredProcedure

Enable executestoredprocedure / executestoredprocedureindatabase tools

DatabaseConfiguration__EnableStartQuery

Enable startquery / startqueryindatabase session tools

DatabaseConfiguration__EnableStartStoredProcedure

Enable startstoredprocedure / startstoredprocedureindatabase session tools

DatabaseConfiguration__MaxCellOutputLength

Maximum characters displayed per cell in query results. Values longer than this are truncated with .... Set to 0 to disable truncation.

databaseName

(required): The name of the database to execute the query in.

execute_query

Executes a SQL query on the connected SQL Server database.

execute_query_in_database

Executes a SQL query in a specific database.

execute_stored_procedure

Executes a stored procedure with automatic parameter type conversion.

executionPlanXml

Actual XML execution plan (only when includeExecutionPlan was true on the start tool)

format

(optional): Output format - "table" (default) or "json".

get_command_timeout

Returns current timeout configuration settings.

get_session_results

Get results from a completed or running query/stored procedure session.

get_session_status

Check the status of a running query or stored procedure session.

get_stored_procedure_definition

Gets the SQL definition of a stored procedure.

get_stored_procedure_parameters

Gets parameter information for a stored procedure in table or JSON Schema format.

get_table_schema

Gets the schema of a table from the connected SQL Server database.

includeExecutionPlan

(optional): Include the actual XML execution plan. Default is false.

includeIoStats

(optional): Include per-table IO statistics. Default is false.

ioStats

Per-table IO statistics (only when includeIoStats was true on the start tool)

list_databases

Lists all databases on the SQL Server instance.

list_sessions

List all query and stored procedure sessions.

list_stored_procedures

Lists all stored procedures in the current database with detailed information.

list_tables

Lists all tables in the connected SQL Server database with schema and row count information.

maxCellOutputLength

(optional): Maximum characters displayed per cell. Values longer than this are truncated with .... Set to 0 to disable truncation. If not specified, uses the server default (MaxCellOutputLength, default 40).

maxRows

(optional): Maximum number of rows to return

parameters

(required): JSON string containing parameter values.

procedureName

(required): The name of the stored procedure.

query

(required): The SQL query to execute.

rowsAffected

Total rows affected by DML operations (always captured)

server_capabilities

Returns detailed information about the capabilities and features of the connected SQL Server instance.

serverElapsedTimeMs

/ serverCpuTimeMs: SQL Server-side timing (always captured)

sessionId

(required): The session ID to check

set_command_timeout

Updates the default command timeout for all new operations.

start_query

Start a SQL query in the background on the connected database. Returns a session ID to check progress. Best for long-running queries.

start_stored_procedure

Start a stored procedure execution in the background. Returns a session ID to check progress. Best for long-running procedures.

status

(optional): Filter by status - "all" (default), "running", or "completed"

stop_session

Stop a running query or stored procedure session.

tableName

(required): The name of the table to get schema information for.

timeoutSeconds

(required): New timeout in seconds (1-3600)