广告合作
MCP.so
登录

MCP SQL Server

@dennismartis

代码仓库

基本信息

分类

数据库

传输方式

stdio

作者

dennismartis

关于 MCP SQL Server

暂无概览

#sql-mcp-server#sql-database#conversational-ai

MCP SQL Server 配置

使用下面的配置,将此服务器添加到你的 MCP 客户端。

{
  "mcpServers": {
    "sql_mcp_server": {
      "command": "python",
      "args": [
        "mcp_sql_server.py"
      ]
    }
  }
}

MCP SQL Server 工具

工具列表暂未提供

当前收录暂时没有可展示的工具列表，不代表服务没有工具。请查阅项目文档了解支持的能力。

工具是从 README 中自动提取的。维护者可以在 ## Tools 标题下列出工具,即可填充这部分内容。

概览

What is MCP SQL Server?

MCP SQL Server is a FastMCP server that exposes Microsoft SQL Server database operations through a conversational AI interface, allowing users to query and manipulate data using natural language.

How to use MCP SQL Server?

Install Python dependencies (pip install pyodbc asyncio fastmcp), ensure Microsoft SQL Server and ODBC Driver 17 for SQL Server are available, then configure the connection parameters (SERVER and DATABASE) in the script. Run the server with python mcp_sql_server.py.

Key features of MCP SQL Server

  • Execute SQL queries and view results
  • List available tables in the database
  • Describe table structure with column names and data types
  • Execute INSERT, UPDATE, DELETE operations
  • List all ODBC drivers on the system
  • Display database information and server version

Use cases of MCP SQL Server

  • Interact with SQL Server databases through a conversational AI interface
  • Quickly explore database schema without manual SQL queries
  • Perform CRUD operations via natural language instructions
  • Retrieve server and database metadata for administration

常见问题

1

What are the system requirements for MCP SQL Server?

Python 3.7+, pyodbc, asyncio, FastMCP, Microsoft SQL Server, and ODBC Driver 17 for SQL Server.

2

How does MCP SQL Server handle database connections?

The server uses Windows Authentication ("Trusted_Connection=yes") and manages the connection via a lifecycle context manager that handles setup and teardown.

3

What should I do if I get a connection error?

Verify the SQL Server instance name, ensure the server is running, and confirm that ODBC Driver 17 for SQL Server is installed.

4

Does MCP SQL Server support any authentication besides Windows Authentication?

The README only documents Windows Authentication; no other authentication methods are mentioned.

5

How does MCP SQL Server prevent blocking during database operations?

Database operations run in a separate thread using `asyncio.get_event_loop().run_in_executor()` to avoid blocking the main event loop.

评论

数据库 分类下的更多 MCP 服务器

Fund Momentum MCP Server

schneidavie

Fund Momentum MCP Server — VC intelligence for AI assistants. 1000+ active VC funds, live investor signals, AI-powered startup matching.

Redis

modelcontextprotocol

Model Context Protocol Servers

88.2K

MySQL MCP Server

designcomputer

A Model Context Protocol (MCP) server that enables secure interaction with MySQL databases

1.3K

Lawstronaut

Lawstronaut-FZCO

Access millions of official legal and regulatory source documents from 155+ jurisdictions via MCP. Lawstronaut supports AI agents with structured legal research, legal data, laws, regulations, cases, guidance, official s

MCP Server for MySQL based on NodeJS

benborla

A Model Context Protocol server that provides read-only access to MySQL databases. This server enables LLMs to inspect database schemas and execute read-only queries.

1.9K
广告合作