pyodbc-mcp-server
Verified Safeby jjones-wps
Overview
Provides read-only access to Microsoft SQL Server databases for AI assistants and other clients via the Model Context Protocol (MCP), using Windows Authentication.
Installation
pyodbc-mcp-serverEnvironment Variables
- MSSQL_SERVER
- MSSQL_DATABASE
- ODBC_DRIVER
- MSSQL_CONNECTION_TIMEOUT
- MSSQL_QUERY_TIMEOUT
- MSSQL_MAX_RETRIES
- MSSQL_RETRY_DELAY
Security Notes
Designed with robust security: strictly read-only (blocking INSERT, UPDATE, DELETE, etc., even in subqueries), uses Windows Authentication (no credentials stored), enforces row limiting, and communicates via stdio only (no network exposure). A documented local API token exposure was confirmed never to have been committed to git or involved actual project tokens; mitigation is complete.
Similar Servers
DatabaseMcpServer
Provides a robust and secure database access layer for AI assistants, supporting 19 types of databases with single-instance multi-database dynamic switching and over 50 tools for data and schema management.
MsSqlMCP
Provides an MCP Server for SQL Server database schema inspection and safe, read-only query execution to AI clients.
warp-sql-server-mcp
An MCP server for SQL Server, enabling AI assistants to securely interact with databases for schema discovery, data retrieval, query execution, performance monitoring, and optimization.
mssql-read-only-mcp
This server provides a lightweight, read-only interface for interacting with an MSSQL database, allowing users to list tables, describe their structure, and execute SELECT queries.