$ loading_
Read Microsoft SQL Server data via Python and pyodbc with safe tools.
Copy the install command and let the AI configure it · recommended for beginners
No copy-paste install info for "mssql-pyodbc-mcp" yet — see the docs or source repo.
Use mssql-pyodbc-mcp to test my configured Microsoft SQL Server connection and tell me whether it succeeds.
A connection test result stating whether the database is reachable.
First list the tables in the database, then describe the columns, types, and key structural details of the customers table.
A table list plus the schema details for the customers table.
Query the orders table for the last 30 days, returning daily order counts and total sales.
Daily aggregated query results for quick analysis of recent business activity.
Developers or data analysts can use this tool through AI to test connectivity, list tables, and inspect schemas without opening a database client. It is useful for quickly understanding an unfamiliar SQL Server database.
When you need to query Microsoft SQL Server data without changing anything, this read-only MCP server provides a safer way to run queries. It fits reporting checks, data validation, and ad hoc analysis.
DevOps engineers or developers can first verify SQL Server access with the connection test, then inspect available tables and columns. This is helpful during integration work or environment troubleshooting.
It is a local stdio MCP server for read-only access to Microsoft SQL Server through Python and pyodbc. Based on the provided information, it offers test connection, list tables, describe table, and query tools.
From the description, it provides read-only access. That means it is intended for connection checks, schema inspection, and querying rather than writes or updates.
Known prerequisites include Microsoft SQL Server, Python, and pyodbc. More installation and configuration details are not provided in the current materials; see the source repository.
Safely let AI query MS SQL Server in read-only mode.
Run read-only SQL Server queries and inspect query performance statistics.
Let AI query multiple SQL databases read-only and export results.
Safely query SQL Server data and inspect tables and schemas read-only.
Connect to ODBC data sources for schema discovery, querying, and controlled writes.
Safely query multiple SQL databases in read-only mode across servers.