{"id":121418,"date":"2026-11-02T19:00:46","date_gmt":"2026-11-02T11:00:46","guid":{"rendered":"https:\/\/www.wsisp.com\/helps\/121418.html"},"modified":"2026-11-02T19:00:46","modified_gmt":"2026-11-02T11:00:46","slug":"mcp-%e5%ae%9e%e6%88%98-07%ef%bc%9a%e8%ae%a9-ai-%e6%9f%a5%e8%af%a2-sqlite%ef%bc%8c%e5%8f%aa%e5%bc%80%e6%94%be%e4%b8%80%e4%b8%aa%e6%9f%a5%e8%af%a2%e5%85%a5%e5%8f%a3","status":"publish","type":"post","link":"https:\/\/www.wsisp.com\/helps\/121418.html","title":{"rendered":"MCP \u5b9e\u6218 07\uff1a\u8ba9 AI \u67e5\u8be2 SQLite\uff0c\u53ea\u5f00\u653e\u4e00\u4e2a\u67e5\u8be2\u5165\u53e3"},"content":{"rendered":"

\u6587\u4ef6\u8bfb\u8fc7\u4e86，\u63a5\u53e3\u4e5f\u63a5\u8fc7\u4e86，\u8fd9\u6b21\u8bd5\u8bd5\u6570\u636e\u5e93\u3002<\/p>\n

\u76ee\u6807\u5f88\u5177\u4f53：\u8ba9 AI \u67e5\u51fa\u4e00\u4e2a\u6f14\u793a\u9879\u76ee\u91cc，\u8fd8\u6ca1\u5173\u95ed\u7684\u4e24\u6761\u7f3a\u9677\u3002<\/p>\n

\u6211\u4eec\u4f7f\u7528 SQLite\u3002\u5b83\u4e0d\u9700\u8981\u5355\u72ec\u5b89\u88c5\u6570\u636e\u5e93\u670d\u52a1，Python \u81ea\u5e26\u652f\u6301，\u9002\u5408\u5148\u628a\u6d41\u7a0b\u8dd1\u901a\u3002<\/p>\n

\u4e00\u3001\u51c6\u5907\u9879\u76ee<\/h3>\n

\u65b0\u5efa\u6587\u4ef6\u5939 mcp-sqlite，\u6309\u4e0b\u9762\u521b\u5efa\u6587\u4ef6：<\/p>\n

mcp-sqlite\/
\n\u251c\u2500\u2500 prepare.py
\n\u251c\u2500\u2500 run.py
\n\u251c\u2500\u2500 check.py
\n\u2514\u2500\u2500 fixtures\/
\n \u2514\u2500\u2500 schema.sql<\/p>\n

\u5728\u9879\u76ee\u6587\u4ef6\u5939\u6253\u5f00\u7ec8\u7aef，\u5b89\u88c5\u4f9d\u8d56\u3002<\/p>\n

Mac：<\/p>\n

python3 -m<\/span> venv .venv
\n.venv\/bin\/python -m<\/span> pip install<\/span> mcp<\/span>==<\/span>2.3<\/span>.0 pydantic<\/span>==<\/span>2.14<\/span>.1<\/p>\n

Windows PowerShell：<\/p>\n

py –<\/span>3 –<\/span>m venv .<\/span>venv
\n.<\/span>\\\\.<\/span>venv\\\\Scripts\\\\python.<\/span>exe –<\/span>m pip install mcp==2.<\/span>3.<\/span>0 pydantic==2.<\/span>14.<\/span>1<\/p>\n

Python \u4f7f\u7528 3.11 \u6216\u66f4\u9ad8\u7248\u672c\u3002<\/p>\n

\u4e8c\u3001\u5efa\u4e00\u4e2a\u6f14\u793a\u6570\u636e\u5e93<\/h3>\n

\u6253\u5f00 fixtures\/schema.sql，\u590d\u5236：<\/p>\n

CREATE<\/span> TABLE<\/span> issues (<\/span>
\n id TEXT<\/span> PRIMARY<\/span> KEY<\/span>,<\/span>
\n title TEXT<\/span> NOT<\/span> NULL<\/span>,<\/span>
\n project TEXT<\/span> NOT<\/span> NULL<\/span>,<\/span>
\n status<\/span> TEXT<\/span> NOT<\/span> NULL<\/span> CHECK<\/span>(<\/span>status<\/span> IN<\/span> (<\/span>'open'<\/span>,<\/span> 'closed'<\/span>)<\/span>)<\/span>
\n)<\/span>;<\/span><\/p>\n

INSERT<\/span> INTO<\/span> issues VALUES<\/span>
\n(<\/span>'DB-001'<\/span>,<\/span> '\u865a\u6784\u767b\u5f55\u95ee\u9898'<\/span>,<\/span> 'demo-project'<\/span>,<\/span> 'open'<\/span>)<\/span>;<\/span><\/p>\n

INSERT<\/span> INTO<\/span> issues VALUES<\/span>
\n(<\/span>'DB-002'<\/span>,<\/span> '\u865a\u6784\u641c\u7d22\u95ee\u9898'<\/span>,<\/span> 'demo-project'<\/span>,<\/span> 'open'<\/span>)<\/span>;<\/span><\/p>\n

INSERT<\/span> INTO<\/span> issues VALUES<\/span>
\n(<\/span>'DB-003'<\/span>,<\/span> '\u865a\u6784\u5df2\u4fee\u590d\u95ee\u9898'<\/span>,<\/span> 'demo-project'<\/span>,<\/span> 'closed'<\/span>)<\/span>;<\/span><\/p>\n

\u8fd9\u91cc\u6709\u4e09\u6761\u95ee\u9898：\u4e24\u6761\u672a\u5173\u95ed，\u4e00\u6761\u5df2\u5173\u95ed\u3002<\/p>\n

\u518d\u6253\u5f00 prepare.py，\u590d\u5236\u5efa\u5e93\u4ee3\u7801：<\/p>\n

from<\/span> pathlib import<\/span> Path
\nimport<\/span> sqlite3<\/p>\n

BASE =<\/span> Path(<\/span>__file__)<\/span>.<\/span>resolve(<\/span>)<\/span>.<\/span>parent \/<\/span> "fixtures"<\/span><\/p>\n

def<\/span> prepare<\/span>(<\/span>)<\/span>:<\/span>
\n target =<\/span> BASE \/<\/span> "demo.db"<\/span><\/p>\n

# \u5df2\u5b58\u5728\u65f6\u76f4\u63a5\u62a5\u9519，\u907f\u514d\u8986\u76d6\u65e7\u6570\u636e\u3002<\/span>
\n with<\/span> target.<\/span>open<\/span>(<\/span>"xb"<\/span>)<\/span>:<\/span>
\n pass<\/span><\/p>\n

try<\/span>:<\/span>
\n connection =<\/span> sqlite3.<\/span>connect(<\/span>target)<\/span>
\n try<\/span>:<\/span>
\n connection.<\/span>executescript(<\/span>
\n (<\/span>BASE \/<\/span> "schema.sql"<\/span>)<\/span>.<\/span>read_text(<\/span>encoding=<\/span>"utf-8"<\/span>)<\/span>
\n )<\/span>
\n finally<\/span>:<\/span>
\n connection.<\/span>close(<\/span>)<\/span>
\n except<\/span> Exception:<\/span>
\n target.<\/span>unlink(<\/span>missing_ok=<\/span>True<\/span>)<\/span>
\n raise<\/span><\/p>\n

return<\/span> target<\/p>\n

if<\/span> __name__ ==<\/span> "__main__"<\/span>:<\/span>
\n print<\/span>(<\/span>"Created"<\/span>,<\/span> prepare(<\/span>)<\/span>.<\/span>name)<\/span><\/p>\n

Mac \u6267\u884c：<\/p>\n

.venv\/bin\/python prepare.py<\/p>\n

Windows \u6267\u884c：<\/p>\n

.<\/span>\\\\.<\/span>venv\\\\Scripts\\\\python.<\/span>exe prepare.<\/span>py<\/p>\n

\u770b\u5230\u4e0b\u9762\u7684\u8f93\u51fa，\u5c31\u8bf4\u660e\u5efa\u597d\u4e86：<\/p>\n

Created demo.db<\/p>\n

fixtures \u6587\u4ef6\u5939\u4e2d\u4f1a\u591a\u51fa\u4e00\u4e2a demo.db，\u5b83\u5c31\u662f\u6570\u636e\u5e93\u3002<\/p>\n

\u5efa\u5e93\u53ea\u9700\u8981\u6267\u884c\u4e00\u6b21\u3002 \u518d\u6b21\u6267\u884c\u63d0\u793a\u6587\u4ef6\u5df2\u5b58\u5728，\u662f\u4e3a\u4e86\u9632\u6b62\u8986\u76d6\u6570\u636e\u3002<\/p>\n

\u4e09\u3001\u5199\u4e00\u4e2a\u53ea\u8bfb\u67e5\u8be2\u5de5\u5177<\/h3>\n

\u6253\u5f00 run.py，\u590d\u5236\u5b8c\u6574\u4ee3\u7801：<\/p>\n

from<\/span> pathlib import<\/span> Path
\nimport<\/span> sqlite3
\nfrom<\/span> typing import<\/span> Annotated,<\/span> Any,<\/span> Literal<\/p>\n

from<\/span> pydantic import<\/span> Field
\nfrom<\/span> mcp.<\/span>server import<\/span> MCPServer
\nfrom<\/span> mcp.<\/span>server.<\/span>mcpserver.<\/span>exceptions import<\/span> ToolError
\nfrom<\/span> mcp.<\/span>types import<\/span> ToolAnnotations<\/p>\n

mcp =<\/span> MCPServer(<\/span>"sqlite-reader-demo"<\/span>)<\/span><\/p>\n

READ_ONLY =<\/span> ToolAnnotations(<\/span>
\n read_only_hint=<\/span>True<\/span>,<\/span>
\n destructive_hint=<\/span>False<\/span>,<\/span>
\n idempotent_hint=<\/span>True<\/span>,<\/span>
\n open_world_hint=<\/span>False<\/span>,<\/span>
\n)<\/span><\/p>\n

DB =<\/span> Path(<\/span>__file__)<\/span>.<\/span>resolve(<\/span>)<\/span>.<\/span>parent \/<\/span> "fixtures"<\/span> \/<\/span> "demo.db"<\/span><\/p>\n

def<\/span> connect_readonly<\/span>(<\/span>)<\/span>:<\/span>
\n connection =<\/span> sqlite3.<\/span>connect(<\/span>
\n DB.<\/span>resolve(<\/span>)<\/span>.<\/span>as_uri(<\/span>)<\/span> +<\/span> "?mode=ro"<\/span>,<\/span>
\n uri=<\/span>True<\/span>,<\/span>
\n timeout=<\/span>1<\/span>,<\/span>
\n )<\/span>
\n connection.<\/span>row_factory =<\/span> sqlite3.<\/span>Row
\n connection.<\/span>execute(<\/span>"PRAGMA query_only=ON"<\/span>)<\/span>
\n return<\/span> connection<\/p>\n

@mcp.<\/span>tool<\/span>(<\/span>annotations=<\/span>READ_ONLY)<\/span>
\ndef<\/span> list_db_issues<\/span>(<\/span>
\n project:<\/span> Literal[<\/span>"demo-project"<\/span>,<\/span> "empty-project"<\/span>]<\/span>,<\/span>
\n status:<\/span> Literal[<\/span>"open"<\/span>,<\/span> "closed"<\/span>]<\/span> =<\/span> "open"<\/span>,<\/span>
\n limit:<\/span> Annotated[<\/span>int<\/span>,<\/span> Field(<\/span>strict=<\/span>True<\/span>,<\/span> ge=<\/span>1<\/span>,<\/span> le=<\/span>20<\/span>)<\/span>]<\/span> =<\/span> 10<\/span>,<\/span>
\n)<\/span> –<\/span>><\/span> dict<\/span>[<\/span>str<\/span>,<\/span> Any]<\/span>:<\/span>
\n """\u6309\u9879\u76ee\u548c\u72b6\u6001\u67e5\u8be2\u6f14\u793a\u7f3a\u9677，\u4e0d\u63a5\u53d7 SQL，\u4e0d\u4fee\u6539\u6570\u636e\u5e93\u3002"""<\/span><\/p>\n

try<\/span>:<\/span>
\n connection =<\/span> connect_readonly(<\/span>)<\/span><\/p>\n

try<\/span>:<\/span>
\n rows =<\/span> connection.<\/span>execute(<\/span>
\n """
\n SELECT id, title, project, status
\n FROM issues
\n WHERE project = ? AND status = ?
\n ORDER BY id
\n LIMIT ?
\n """<\/span>,<\/span>
\n (<\/span>project,<\/span> status,<\/span> limit)<\/span>,<\/span>
\n )<\/span>.<\/span>fetchall(<\/span>)<\/span>
\n finally<\/span>:<\/span>
\n connection.<\/span>close(<\/span>)<\/span><\/p>\n

except<\/span> sqlite3.<\/span>Error:<\/span>
\n raise<\/span> ToolError(<\/span>
\n "database_unavailable_or_invalid_schema"<\/span>
\n )<\/span> from<\/span> None<\/span><\/p>\n

return<\/span> {<\/span>
\n "source"<\/span>:<\/span> "local-demo-sqlite"<\/span>,<\/span>
\n "count"<\/span>:<\/span> len<\/span>(<\/span>rows)<\/span>,<\/span>
\n "issues"<\/span>:<\/span> [<\/span>dict<\/span>(<\/span>row)<\/span> for<\/span> row in<\/span> rows]<\/span>,<\/span>
\n }<\/span><\/p>\n

if<\/span> __name__ ==<\/span> "__main__"<\/span>:<\/span>
\n mcp.<\/span>run(<\/span>transport=<\/span>"stdio"<\/span>)<\/span><\/p>\n

\u8fd9\u6bb5\u4ee3\u7801\u9650\u5236\u4e86\u4e09\u4ef6\u4e8b：<\/p>\n