mcp-server-mssql
This server does not currently have a deployable release on Glama. Follow the repository's setup instructions to install and configure it for your MCP client, including any required credentials and local dependencies.
mcp-server-mssql
MCP server for Microsoft SQL Server using mssql-python.
mcp-name: io.github.daedalus/mcp-server-mssql
Install
pip install mcp-server-mssqlRelated MCP server: mssql-mcp-server
Usage
Run as MCP Server
mcp-server-mssqlConfigure in Claude Desktop
Add to your claude_desktop_config.json:
{
"mcpServers": {
"mcp-server-mssql": {
"command": "mcp-server-mssql"
}
}
}Available Tools
connect_tool- Connect to Microsoft SQL Serverclose_connection- Close an existing connectionlist_connections- List all active connectionsexecute_query- Execute SQL query and return resultsexecute_scalar- Execute SQL and return single valuefetch_results- Fetch results from a cursorcall_procedure- Call a stored procedurecommit- Commit current transactionrollback- Rollback current transactionbulk_copy- Perform bulk copy operationget_tables- List database tablesget_columns- List table columnsget_procedures- List stored proceduresget_foreign_keys- List foreign keysget_primary_keys- List primary keysparse_connection_string- Parse connection stringbuild_connection_string- Build connection stringset_connection_timeout- Set connection timeoutset_login_timeout- Set login timeoutset_autocommit- Set autocommit modeget_connection_info- Get connection information
Development
git clone https://github.com/daedalus/mcp-server-mssql.git
cd mcp-server-mssql
pip install -e ".[test]"
# run tests
pytest
# format
ruff format src/ tests/
# lint
ruff check src/ tests/
# type check
mypy src/Tool Schema Changelog
Recent tool additions, removals, and schema changes observed during successful MCP inspections.
Loading tool schema changelog…
This server cannot be deployed
Maintenance
Related MCP Connectors
Hosted SQL Server MCP server for Claude, ChatGPT and Cursor, with each action switched per account.
MCP server for interacting with the Supabase platform
MCP registry & directory: search, find & install 31k+ MCP servers & tools. Catalog and marketplace.
PostgreSQL, MySQL, and SQL Server in one session. 26 read-only MCP tools for AI agents.
Related MCP Servers
- AlicenseNot gradedqualityDmaintenanceA comprehensive MCP server for SQL Server database operations, enabling CRUD operations, schema exploration, and stored procedure execution through natural language.11 npmMIT
- AlicenseNot gradedqualityDmaintenanceMCP server for executing SQL queries and managing connections to Microsoft SQL Server databases.2,101 npm1MIT
- AlicenseAqualityCmaintenanceProduction-oriented MCP server for Microsoft SQL Server, enabling query execution, database discovery, schema introspection, and metadata inspection via MCP clients.64MIT
- FlicenseNot gradedqualityFmaintenanceProvides MCP tools to query and inspect Microsoft SQL Server databases via a Streamable HTTP transport, including tools for running T-SQL queries, previewing tables, and retrieving schema context.-