mcpField
M
mcp-server-mssql

mcp-server-mssql

Local
github.com/daedalusDatabases0Updated 27w ago
Repository

About mcp-server-mssql

mcp-server-mssql connects MCP clients to Microsoft SQL Server using mssql-python. Its tools cover queries, stored procedures, transactions, bulk copy, and database metadata.

Key features

  1. 01Connect to and manage database connections
  2. 02Execute queries and scalar statements
  3. 03Call stored procedures
  4. 04Commit or roll back transactions
  5. 05Bulk copy data
  6. 06Inspect tables, columns, and keys

Use cases

  1. 01Run SQL queries against Microsoft SQL Server
  2. 02Call stored procedures and manage transactions
  3. 03Review database tables and key metadata

MCP support

It exposes Microsoft SQL Server connection and database operations to MCP clients through tools for queries, transactions, bulk copy, and schema inspection.

Configuration

Local server config is the same for every client. Copy it into your client’s MCP config file.

mcp.json · Universal config
{
  "mcpServers": {
    "daedalus-mcp-server-mssql": {
      "command": "uvx",
      "args": [
        "mcp-server-mssql"
      ]
    }
  }
}
Run commanduvx mcp-server-mssql

Local servers need a runtime on your machine (e.g. Node.js 18+). Config file locations differ by client; see your client’s docs.

Packages
pypimcp-server-mssql0.1.0

Tools

No tool list yet

Local servers expose tools only once running on your machine, and the maintainer has not provided a tool list.

Details

From the project README

mcp-server-mssql

MCP server for Microsoft SQL Server using mssql-python.

PyPI Python Ruff

mcp-name: io.github.daedalus/mcp-server-mssql

Install

pip install mcp-server-mssql

Usage

Run as MCP Server
mcp-server-mssql
Configure 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 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
  • parse_connection_string - Parse connection string
  • build_connection_string - Build connection string
  • set_connection_timeout - Set connection timeout
  • set_login_timeout - Set login timeout
  • set_autocommit - Set autocommit mode
  • get_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/

Comments

Markdown supported

New to MCP?

From what the protocol is to installing your first server, these answers cover most first questions.

An open protocol that defines how AI applications connect to external tools and data in a uniform way. Clients talk to the model; MCP servers provide tools, resources and prompt templates. They exchange standard messages, so one server can be reused by many clients.