pyodbc-mcp-server

jjones-wps/pyodbc-mcp-server

3.2

If you are the rightful owner of pyodbc-mcp-server and would like to certify it and/or have it hosted online, please leave a comment on the right or send an email to dayong@mcphub.com.

A Model Context Protocol (MCP) server providing read-only access to Microsoft SQL Server databases using Windows Authentication.

Tools

Functions exposed to the LLM to take actions

ListTables

List all tables in the database, optionally filtered by schema.

ListViews

List all views in the database, optionally filtered by schema.

DescribeTable

Get column definitions for a specific table.

GetTableRelationships

Find foreign key relationships for a table.

ReadData

Execute a SELECT query (with security filtering).

Prompts

Interactive templates invoked by user choice

No prompts

Resources

Contextual data attached and managed by the client

No resources