Skip to main content
Glama

MCP SQLite Server

MCP SQLite 服务器

基于官方 Python 参考 的模型上下文协议 SQLite 服务器的 Node.js 实现。此版本为 Python 的 UVX 运行器不可用的环境(例如LibreChat )提供了基于 npx 的替代方案。

与 Claude Desktop 一起使用

通过 Smithery 安装

要通过Smithery自动为 Claude Desktop 安装 MCP SQLite Server:

npx -y @smithery/cli install mcp-server-sqlite-npx --client claude

手动安装

将以下内容添加到claude_desktop_config.json

{ "mcpServers": { "sqlite": { "command": "/absolute/path/to/npx", "args": [ "-y", "mcp-server-sqlite-npx", "/absolute/path/to/database.db" ], "env": { "PATH": "/absolute/path/to/executables", "NODE_PATH": "/absolute/path/to/node_modules" } } } }

在 macoS 上使用 nvm 的完整示例:

{ "mcpServers": { "sqlite": { "command": "/Users/{username}/.nvm/versions/node/v22.12.0/bin/npx", "args": [ "-y", "mcp-server-sqlite-npx", "/Users/{username}/projects/database.db" ], "env": { "PATH": "/Users/{username}/.nvm/versions/node/v22.12.0/bin:/usr/local/bin:/usr/bin:/bin", "NODE_PATH": "/Users/{username}/.nvm/versions/node/v22.12.0/lib/node_modules" } } } }

在 Windows 上使用 nvm 的完整示例:

{ "mcpServers": { "sqlite": { "command": "C:\\Program Files\\nodejs\\npx.cmd", "args": [ "-y", "mcp-server-sqlite-npx", "C:\\Users\\{username}\\projects\\database.db" ], "env": { "PATH": "C:\\Program Files\\nodejs;%PATH%", "NODE_PATH": "C:\\Program Files\\nodejs\\node_modules" } } } }

发展

  1. 安装依赖项:
npm ci
  1. 构建 TypeScript 代码:
npm run build

使用 MCP Inspector 进行测试

您可以使用MCP Inspector 工具测试服务器:

npx @modelcontextprotocol/inspector node dist/index.js /absolute/path/to/database.db

Connect并转到Tools以开始使用服务器。

使用 Claude Desktop 进行测试

将以下内容添加到claude_desktop_config.json

{ "mcpServers": { "sqlite": { "command": "/absolute/path/to/node", "args": [ "/absolute/path/to/dist/index.js", "/absolute/path/to/database.db" ] } } }

例子:

  • /absolute/path/to/node/Users/{username}/.nvm/versions/node/v20.18.1/bin/node版本/节点/v20.18.1/bin/节点
  • /absolute/path/to/index.js : /Users/{username}/projects/mcp-server-sqlite-npx/dist/index.js
  • /absolute/path/to/database.db : /Users/{用户名/Users/{username}/projects/database.db

发布

  • 在 package.json 中增加版本
  • npm install
  • 提交消息: Release {version, eg 0.1.6}
-
security - not tested
A
license - permissive license
-
quality - not tested

local-only server

The server can only run on the client's local machine because it depends on local resources.

使用 SQLite 的模型上下文协议服务器的 Node.js 实现,为缺少 Python 的 UVX 运行器的环境提供基于 npx 的替代方案。

  1. 与 Claude Desktop 一起使用
    1. 通过 Smithery 安装
    2. 手动安装
  2. 发展
    1. 使用 MCP Inspector 进行测试
    2. 使用 Claude Desktop 进行测试
    3. 发布

Related MCP Servers

  • A
    security
    A
    license
    A
    quality
    A Model Context Protocol (MCP) server implementation that provides database interaction and business intelligence capabilities through SQLite. This server enables running SQL queries, analyzing business data, and automatically generating business insight memos.
    Last updated -
    67,659
    MIT License
  • A
    security
    A
    license
    A
    quality
    A Model Context Protocol server that provides database interaction capabilities through SQLite, enabling users to run SQL queries, analyze business data, and automatically generate business insight memos.
    Last updated -
    17
    MIT License
    • Apple
  • -
    security
    F
    license
    -
    quality
    A Model Context Protocol server that enables SQL operations (SELECT, INSERT, UPDATE, DELETE) and table management through a standardized interface with SQLite databases.
    Last updated -
    37
  • A
    security
    A
    license
    A
    quality
    A Model Context Protocol server that allows users to store, retrieve, update, and delete memories using SQLite storage.
    Last updated -
    5
    6
    MIT License

View all related MCP servers

MCP directory API

We provide all the information about MCP servers via our MCP API.

curl -X GET 'https://glama.ai/api/mcp/v1/servers/johnnyoshika/mcp-server-sqlite-npx'

If you have feedback or need assistance with the MCP directory API, please join our Discord server