pyodbc-mcp-server

# pyodbc MCP Server A [Model Context Protocol (MCP)](https://modelcontextprotocol.io/) server that provides **read-only** access to Microsoft SQL Server databases using **Windows Authentication**. Built for environments where: - 🔐 **Windows Authentication is required** (no username/password storage) - 🛡️ **Read-only access is mandated** by IT security policy - 🖥️ **SQL Server is accessed from Windows workstations** - 🤖 **AI assistants need safe database access** (Claude Code, etc.) ## Features - **Windows Authentication** - Uses `Trusted_Connection` via pyodbc, no credentials to manage - **Read-only by design** - Only SELECT queries allowed, dangerous keywords blocked - **Comprehensive error handling** - Typed exceptions with retry logic for transient failures - **Row limiting** - Prevents accidental large result sets (configurable, max 10,000) - **Schema exploration** - 10 tools for tables, views, indexes, constraints, relationships, and more - **MCP resources** - 5 URI-based endpoints for quick data access - **Configurable** - CLI arguments, TOML config files, or environment variables - **Production-ready** - Query timeouts, connection retries, comprehensive logging ## Available Tools | Tool | Description | |------|-------------| | `ListTables` | List all tables in the database, optionally filtered by schema | | `DescribeTable` | Get detailed column definitions, primary keys, and foreign keys | | `ReadData` | Execute SELECT queries with security filtering and row limits | | `GetTableRelationships` | Find foreign key relationships with referential actions | | `ListViews` | List all views in the database, optionally filtered by schema | | `ListIndexes` | List all indexes for a specific table with metadata | | `ListConstraints` | List all constraints (PK, FK, unique, check, default) | | `ListStoredProcedures` | List all stored procedures, optionally filtered by schema | | `ListFunctions` | List all user-defined functions, optionally filtered by schema | | …