Mcp Server Mssql
by daedaluscommunityv0.1.0
MCP server for Microsoft SQL Server using mssql-python that allows interaction with SQL databases through various tools.
From the registry: MCP server for Microsoft SQL Server using mssql-python
Install & configure
Prerequisites
- requiredInstall from PyPIInstall the mcp-server-mssql package.
https://pypi.org/project/mcp-server-mssql/$ pip install mcp-server-mssql
Install in your client
Paste into the AI you're chatting with — it will figure out the rest
Please install the `mcp-server-mssql` MCP server into my current AI client (that's you).
Required prerequisites (do these first if not already done):
- **Install from PyPI** — Install the mcp-server-mssql package. Run: `pip install mcp-server-mssql` (https://pypi.org/project/mcp-server-mssql/)
Canonical MCP server config (stdio transport):
- command: `mcp-server-mssql`
- args: []
Note: Connection details are supplied via the connect_tool at runtime, not as env vars.
Add this MCP server to my current client's config in the correct format for you. If you need secrets or credentials I haven't provided, ASK me — do not invent values or leave raw placeholders. After adding it, tell me how to verify the server is connected.Note: Connection details are supplied via the connect_tool at runtime, not as env vars.
Tools (21)
connect_tool
Connect to Microsoft SQL Server
close_connection
Close an existing connection
list_connections
List all active connections
execute_query
Execute SQL query and return results
execute_scalar
Execute SQL and return single value
fetch_results
Fetch results from a cursor
call_procedure
Call a stored procedure
commit
Commit current transaction
rollback
Rollback current transaction
bulk_copy
Perform bulk copy operation
get_tables
List database tables
get_columns
List table columns
get_procedures
List stored procedures
get_foreign_keys
List foreign keys
get_primary_keys
List primary keys
Packages
mcp-server-mssql
pypiv0.1.0transport: stdio
Details
- Language
- Python
- License
- MIT
- Released
- Apr 3, 2026
- Last commit
- Apr 21, 2026
- Registry name
- io.github.daedalus/mcp-server-mssql