Skip to main content
Glama

MCP SQLite Server

by johnnyoshika

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
F
license - not found
-
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 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 -
    6
    9
    TypeScript
    MIT License
    • Apple
  • -
    security
    A
    license
    -
    quality
    A Model Context Protocol server that enables seamless execution of commands, Python code, web content fetching, and reusable task management with secure credentials handling.
    Last updated -
    2
    Python
    MIT License
    • Apple
  • -
    security
    F
    license
    -
    quality
    A Node.js application that provides a Model Context Protocol server for interacting with Harbor container registry, supporting operations for projects, repositories, tags, and Helm charts.
    Last updated -
    TypeScript
  • -
    security
    -
    license
    -
    quality
    A Model Context Protocol server that provides tools for connecting to and interacting with various database systems (SQLite, PostgreSQL, MySQL/MariaDB, SQL Server) through a unified interface.
    Last updated -
    Python

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