{"type":"mcp_server","name":"py-mcp-mssql","description":"This repository provides a Python implementation of an MCP server for accessing Microsoft SQL Server databases, enabling language models to inspect schemas and execute queries through a standardized API.","category":"Database","language":"Python","stars":27,"forks":2,"owner":"amornpan","github_url":"https://github.com/amornpan/py-mcp-mssql","homepage":null,"setup":"## Setup\n\n1.  Clone the repository: `git clone https://github.com/amornpan/py-mcp-mssql.git`\n2.  Navigate to the project directory: `cd py-mcp-mssql`\n3.  Install the required Python packages: `pip install -r requirements.txt`\n4.  Create a `.env` file in the project root with the necessary MSSQL configuration.\n5.  Add the server to your Claude Desktop configuration by modifying the `claude_desktop_config.json` file.","tools":"## Available Tools\n\n1. Asynchronous operation (utilizes Python's `asyncio`).\n2. Environment-based configuration (uses `python-dotenv`).\n3. Comprehensive logging system (provides detailed logs).\n4. Connection pooling and management (uses pyodbc).\n5. Error handling and recovery (implements robust error management).\n6. FastAPI integration (provides API endpoints).\n7. Pydantic models (used for data validation).\n8. MSSQL connection handling (uses ODBC Driver).\n9. Resource Listing (lists all available tables in the database).\n10. Resource Reading (reads data from specified table).\n11. SQL Execution (executes SQL queries).\n","faq":null,"created_at":"2025-01-26T16:54:51+00:00","updated_at":"2025-03-28T23:30:13+00:00","source_url":"https://model-context-protocol.com/servers/python-mssql-database-schema-query-api","related_articles":[]}