{"type":"mcp_server","name":"mssql_mcp_server","description":"The MSSQL MCP Server enables secure interaction with MSSQL databases for AI assistants by listing tables, reading data, and executing controlled SQL queries. It ensures safer database exploration with permission","category":"Database","language":"Python","stars":55,"forks":4,"owner":"JexinSam","github_url":"https://github.com/JexinSam/mssql_mcp_server","homepage":null,"setup":"## Setup\n\n1.  Install the package: `pip install mssql-mcp-server`\n2.  Configure database access by setting environment variables: `MSSQL_DRIVER`, `MSSQL_HOST`, `MSSQL_USER`, `MSSQL_PASSWORD`, and `MSSQL_DATABASE`.\n3.  For Claude Desktop integration, add the provided configuration to `claude_desktop_config.json`.\n4.  To run as a standalone server, install dependencies with `pip install -r requirements.txt` and run the server with `python -m mssql_mcp_server`.\n5.  For development, clone the repository, set up a virtual environment, install development dependencies with `pip install -r requirements-dev.txt`, and run tests with `pytest`.","tools":"## Available Tools\n\n1. Secure MSSQL Database Access (through environment variables)\n2. Controlled Query Execution (with error handling)\n3. Table Listing & Data Retrieval\n4. Comprehensive Logging (for monitoring queries and operations)","faq":null,"created_at":"2025-01-30T07:49:04+00:00","updated_at":"2025-03-28T11:14:48+00:00","source_url":"https://model-context-protocol.com/servers/mssql-secure-database-interaction-mcp-server","related_articles":[]}