Skip to main content
Glama
mssql-pyodbc-mcp

mssql-pyodbc-mcp

by tsod

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-only SELECT queries 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_SERVER

  • MSSQL_DATABASE

  • MSSQL_USER

  • MSSQL_PASSWORD

Optional defaults:

  • MSSQL_DRIVER=ODBC Driver 18 for SQL Server

  • MSSQL_PORT=1433

  • MSSQL_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-mcp

Live DB Checks

After exporting the environment variables, verify the local setup with:

python scripts/check_odbc_connection.py
python scripts/check_mcp_tools.py

Codex MCP Example

Configure your MCP client to run the command:

mssql-pyodbc-mcp

Pass the environment variables through your MCP client configuration or shell environment.

Safety Notes

  • The query tool accepts general SELECT and 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

pytest

The unit tests do not require a live MSSQL instance.

Available Tools

4 tools
describe_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

    A3.7/5.0

    Scored across 4 tools

    Disambiguation5/5

    Each tool has a distinct purpose: listing tables, describing a table's schema, executing a SELECT query, and testing connectivity. No overlap in functionality.

    Naming Consistency4/5

    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.

    Tool Count4/5

    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.

    Completeness3/5

    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

    ActivityInactive
    ResponsivenessNo recent community issues

    Related MCP Connectors

    Related MCP Servers

    • A
      license
      Not graded
      quality
      D
      maintenance
      A 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.
      2
      MIT
    • A
      license
      A
      quality
      D
      maintenance
      MCP 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.
      6
      MIT
    • A
      license
      A
      quality
      C
      maintenance
      Production-oriented MCP server for Microsoft SQL Server, enabling query execution, database discovery, schema introspection, and metadata inspection via MCP clients.
      6
      4
      MIT
    • A
      license
      Not graded
      quality
      C
      maintenance
      MCP 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