Skip to main content
Glama
johnnyoshika

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"
      }
    }
  }
}

Related MCP server: SQLite MCP Server

发展

  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}

Maintenance

ActivityInactive
ResponsivenessSyncing

Resources

Unclaimed servers have limited discoverability.

Looking for Admin?

If you are the server author, to access and configure the admin panel.

Related MCP Connectors

Related MCP Servers

  • F
    license
    Not graded
    quality
    D
    maintenance
    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.
    3
    -
  • A
    license
    Not graded
    quality
    D
    maintenance
    A Model Context Protocol server implementation that enables AI assistants to execute SQL queries and interact with SQLite databases through a structured interface.
    7
    MIT
  • A
    license
    B
    quality
    A
    maintenance
    A Model Context Protocol server that enables SQL operations (SELECT, INSERT, UPDATE, DELETE) and table management through a standardized interface with SQLite databases.
    7
    140
    1
    ISC
  • A
    license
    Not graded
    quality
    D
    maintenance
    A minimal, general-purpose implementation of the Model Context Protocol (MCP) for Node.js and Bare runtime, enabling creation of AI-interactive servers with tools, resources, and multiple transport options.
    11
    2
    MIT

Latest Blog Posts

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