2天搞定一个mcp python ai模型的本地业务扩展能力编写mcp 两种io方式和其他实现一个mcp 实时查询sql server

x

在mcp没怎么流行的时候常常听到有广子说加什么搭建本地应用场景的大模型，那种我想是用来训练数据吧，
但是对于我们新手小白来说，文档知识库 + mcp才是最合适的，那种训练的，不敢想

给sql server写了一个mcp，用的是 FastMCP写法，之前的写法作废了，据说这种写法更容易实现
V安装：https://docs.astral.sh/uv/getting-started/installation/
MCP Github首页：https://github.com/modelcontextprotocol
MCP Python SKD: https://github.com/modelcontextprotocol/python-sdk


from mcp.server.fastmcp import FastMCP

# Create an MCP server
mcp = FastMCP("Demo")


# Add an addition tool
@mcp.tool()
def add(a: int, b: int) -> int:
    """Add two numbers"""
    return a + b


# Add a dynamic greeting resource
@mcp.resource("greeting://{name}")
def get_greeting(name: str) -> str:
    """Get a personalized greeting"""
    return f"Hello, {name}!"


# Add a prompt
@mcp.prompt()
def greet_user(name: str, style: str = "friendly") -> str:
    """Generate a greeting prompt"""
    styles = {
        "friendly": "Please write a warm, friendly greeting",
        "formal": "Please write a formal, professional greeting",
        "casual": "Please write a casual, relaxed greeting",
    }

    return f"{styles.get(style, styles[ friendly ])} for someone named {name}."
def main():
    print("Hello from sqlservermcp!")


if __name__ == "__main__":
    main()

配置

第一种 UV
安装uv
powershell -ExecutionPolicy ByPass -c "irm https://astral.sh/uv/install.ps1 | iex"
配置目录环境

C:UsersAdministratorPycharmProjectsSqlserverMCP>uv init . -p

C:UsersAdministratorPycharmProjectsSqlserverMCP>uv python list
cpython-3.14.0b4-windows-x86_64-none                 <download available>
cpython-3.14.0b4+freethreaded-windows-x86_64-none    <download available>
cpython-3.13.5-windows-x86_64-none                   C:UsersAdministratorAppDataRoaminguvpythoncpython-3.13.5-windows-x86_64-nonepython.exe
cpython-3.13.5+freethreaded-windows-x86_64-none      <download available>
cpython-3.12.11-windows-x86_64-none                  <download available>
cpython-3.11.13-windows-x86_64-none                  <download available>
cpython-3.10.18-windows-x86_64-none                  <download available>
cpython-3.10.9-windows-x86_64-none                   D:Python310python.exe
cpython-3.9.23-windows-x86_64-none                   <download available>
cpython-3.8.20-windows-x86_64-none                   <download available>
pypy-3.11.13-windows-x86_64-none                     <download available>
pypy-3.10.16-windows-x86_64-none                     <download available>
pypy-3.9.19-windows-x86_64-none                      <download available>
pypy-3.8.16-windows-x86_64-none                      <download available>
graalpy-3.11.0-windows-x86_64-none                   <download available>
graalpy-3.10.0-windows-x86_64-none                   <download available>

C:UsersAdministratorPycharmProjectsSqlserverMCP>uv init . -p 3.13.5
Initialized project `sqlservermcp` at `C:UsersAdministratorPycharmProjectsSqlserverMCP`

C:UsersAdministratorPycharmProjectsSqlserverMCP>uv add "mcp[cli]"
Using CPython 3.13.5
error: failed to remove directory `C:UsersAdministratorPycharmProjectsSqlserverMCP.venv`: 拒绝访问。 (os error 5)

C:UsersAdministratorPycharmProjectsSqlserverMCP>uv add "mcp[cli]"
Using CPython 3.13.5
error: failed to remove directory `C:UsersAdministratorPycharmProjectsSqlserverMCP.venv`: 拒绝访问。 (os error 5)

C:UsersAdministratorPycharmProjectsSqlserverMCP>uv add "mcp[cli]"
Using CPython 3.13.5
error: Project virtual environment directory `C:UsersAdministratorPycharmProjectsSqlserverMCP.venv` cannot be used because it is not a compatible environment but cannot be recreated because it is not a virtual environment

C:UsersAdministratorPycharmProjectsSqlserverMCP>uv add "mcp[cli]"
Using CPython 3.13.5
error: Project virtual environment directory `C:UsersAdministratorPycharmProjectsSqlserverMCP.venv` cannot be used because it is not a compatible environment but cannot be recreated because it is not a virtual environment

C:UsersAdministratorPycharmProjectsSqlserverMCP>uv init . -p 3.13.5
error: Project is already initialized in `C:UsersAdministratorPycharmProjectsSqlserverMCP` (`pyproject.toml` file exists)

C:UsersAdministratorPycharmProjectsSqlserverMCP>uv init . -p 3.13.5
Initialized project `sqlservermcp` at `C:UsersAdministratorPycharmProjectsSqlserverMCP`

C:UsersAdministratorPycharmProjectsSqlserverMCP>uv add "mcp[cli]"
Using CPython 3.13.5
Creating virtual environment at: .venv
Resolved 35 packages in 2.13s
⠇ Preparing packages... (13/15)
pygments                  ------------------------------ 329.92 KiB/1.17 MiB
pywin32                   ------------------------------ 323.83 KiB/9.05 MiB

上面刚开始是直接用开发工具创建的.venv导致的问题直接删掉关闭开发工具，重新初始化即可。
pyproject.toml
关于调试：

mcp 有两种方式链接
第一种调试：
进入指定目录之后
uv run sqlserver_mcp.server.py
如果没报错代表成功了，

[project]
name = "sqlserver-fastmcp"
version = "1.0.0"
description = "SQL Server FastMCP Server for Claude"
authors = [
    {name = "Your Name", email = "your.email@example.com"}
]
readme = "README.md"
requires-python = ">=3.10"
dependencies = [
    "fastmcp>=0.1.0",
    "pyodbc>=4.0.0",
]

[project.optional-dependencies]
dev = [
    "pytest>=7.0.0",
    "black>=23.0.0",
    "flake8>=6.0.0",
]

[build-system]
requires = ["hatchling"]
build-backend = "hatchling.build"

# 添加这个部分 - 关键配置
[tool.hatch.build.targets.wheel]
packages = ["sqlserver_mcp"]

[tool.black]
line-length = 88
target-version = [ py38 ]

[tool.uv]
dev-dependencies = [
    "pytest>=7.0.0",
    "black>=23.0.0",
    "flake8>=6.0.0",
]

第二种方式:
直接用pychram打开这个项目