mssql-mcp-server

ConnorBritain/mssql-mcp-server

3.3

If you are the rightful owner of mssql-mcp-server and would like to certify it and/or have it hosted online, please leave a comment on the right or send an email to dayong@mcphub.com.

A Model Context Protocol (MCP) server for Microsoft SQL Server designed for enterprise database environments, providing AI-driven tools for schema exploration, query prototyping, and data validation.

Tools

Functions exposed to the LLM to take actions

search_schema

Wildcard/fuzzy discovery with pagination and fuzzy suggestions.

profile_table

Column stats, percentile metrics, limited sample exposure.

inspect_relationships

FK maps in both directions.

read_data

Bread-and-butter querying and schema inspection.

insert_data

Opt-in CRUD/DDL helpers for agent workflows.

Prompts

Interactive templates invoked by user choice

No prompts

Resources

Contextual data attached and managed by the client

No resources