mssql-mcp-python

lorenzouriel/mssql-mcp-python

3.4

If you are the rightful owner of mssql-mcp-python 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.

This is a Model Context Protocol (MCP) server implementation in Python that safely exposes SQL Server database capabilities to LLM clients.

Tools

Functions exposed to the LLM to take actions

execute_sql

Execute SELECT queries (or write operations if enabled).

list_schemas

List all database schemas.

list_tables

List tables with optional schema filter.

schema_discovery

Get full schema metadata (tables, columns, types).

get_database_info

Get server/database metadata.

get_policy_info

Get current security policy settings.

check_db_connection

Health check for database connectivity.

Prompts

Interactive templates invoked by user choice

No prompts

Resources

Contextual data attached and managed by the client

No resources