mssql-pyodbc-mcp
Click on "Deploy Server".
Wait a few minutes for the server to deploy. Once ready, it will show a "Started" state.
In the chat, type
@followed by the MCP server name and your instructions, e.g., "@mssql-pyodbc-mcp list all tables"
That's it! The server will respond to your query, and you can continue using it as needed.
Here is a step-by-step guide with screenshots.
mssql-pyodbc-mcp
Local stdio MCP server for read-only Microsoft SQL Server access through Python and pyodbc.
Features
test_connection: validates configuration and checks DB connectivity.list_tables: lists accessible user tables.describe_table: returns simple column metadata.query: executes read-onlySELECTqueries and returns at most 100 rows.
The first release supports one configured MSSQL database and SQL username/password authentication only.
Related MCP server: SQL Query Tools MCP Server
Environment Variables
Required:
MSSQL_SERVERMSSQL_DATABASEMSSQL_USERMSSQL_PASSWORD
Optional defaults:
MSSQL_DRIVER=ODBC Driver 18 for SQL ServerMSSQL_PORT=1433MSSQL_TRUST_SERVER_CERTIFICATE=yes
The implementation sets Encrypt=no and passes TrustServerCertificate from the environment. For production-like environments, use a properly trusted server certificate and tighten encryption settings before exposing the server beyond local agent usage.
Some older SQL Server instances only support legacy TLS settings. If pyodbc fails with unsupported protocol, run the MCP server with:
export OPENSSL_CONF="$PWD/scripts/openssl-legacy.cnf"Install
python -m venv .venv
. .venv/bin/activate
pip install -e ".[dev]"You also need a Microsoft SQL Server ODBC driver installed on the host, such as ODBC Driver 18 for SQL Server.
Run
export MSSQL_SERVER=localhost
export MSSQL_DATABASE=MyDatabase
export MSSQL_USER=my_user
export MSSQL_PASSWORD=my_password
export MSSQL_DRIVER="ODBC Driver 18 for SQL Server"
export MSSQL_PORT=1433
export MSSQL_TRUST_SERVER_CERTIFICATE=yes
export OPENSSL_CONF="$PWD/scripts/openssl-legacy.cnf"
mssql-pyodbc-mcpLive DB Checks
After exporting the environment variables, verify the local setup with:
python scripts/check_odbc_connection.py
python scripts/check_mcp_tools.pyCodex MCP Example
Configure your MCP client to run the command:
mssql-pyodbc-mcpPass the environment variables through your MCP client configuration or shell environment.
Safety Notes
The
querytool accepts generalSELECTand CTE-style read queries.Mutating, schema-changing, administrative,
EXEC, and multi-statement SQL are rejected by policy.Query results are limited to 100 rows.
Use a read-only SQL Server account whenever possible.
Passwords and full connection strings are not returned in tool responses.
Tests
pytestThe unit tests do not require a live MSSQL instance.
Available Tools
4 toolsdescribe_tableA
Return column_name, data_type, and nullable for a table.
Inputs: table_name (required). Returns: object
list_tablesA
List accessible user tables in the configured MSSQL database.
Inputs: no named parameters. Returns: object
queryA
Execute a read-only SELECT query and return at most 100 rows.
Inputs: sql (required). Returns: object
test_connectionA
Validate MSSQL environment configuration and test database connectivity.
Inputs: no named parameters. Returns: object
Tool Schema Changelog
Recent tool additions, removals, and schema changes observed during successful MCP inspections.
Loading tool schema changelog…
TDQS
Scored across 4 tools
Each tool has a distinct purpose: listing tables, describing a table's schema, executing a SELECT query, and testing connectivity. No overlap in functionality.
Most tools follow a verb_noun snake_case pattern (describe_table, list_tables, test_connection). The 'query' tool is a single verb but still clear and fits the general pattern.
With 4 tools, the server covers essential read-only database operations. The count is slightly thin but appropriate for the focused scope of querying and exploring a MSSQL database.
The set covers connection testing, table listing, schema description, and querying. Missing tools for exploring views, stored procedures, or other metadata, which are minor gaps for a read-only server.
Maintenance
Related MCP Connectors
Read-only MCP server for ClassQuill, a tutoring-business-management platform.
Text-to-SQL MCP server: read-only queries on PostgreSQL, MySQL and SQL Server with your real schema
2,000+ MCP servers read at source level. Know what one does before you connect. Free, no key.
Hosted SQL Server MCP server for Claude, ChatGPT and Cursor, with each action switched per account.
Related MCP Servers
- AlicenseNot gradedqualityDmaintenanceA Python MCP server that connects to any ODBC data source and exposes schema discovery + query tools. Read-only by default, write access available per-connection.2MIT
- AlicenseAqualityDmaintenanceMCP server for connecting to SQL Server in readonly mode. Allows any MCP client to explore the schema and run SELECT queries against a SQL Server database.6MIT
- AlicenseAqualityCmaintenanceProduction-oriented MCP server for Microsoft SQL Server, enabling query execution, database discovery, schema introspection, and metadata inspection via MCP clients.64MIT
- AlicenseNot gradedqualityCmaintenanceMCP server that connects to SQL databases (SQLite, PostgreSQL, MSSQL, MySQL) and provides tools to run read-only queries, list schemas/tables, and manage connections via stdio transport.Apache 2.0