Johnnyoshika MCP Server Sqlite Npx

🚀 MCP SQLite Server

This is a Model Context Protocol (MCP) SQLite server implemented in Node.js, inspired by the official Python reference implementation here. This version provides an npx-based alternative for environments where the UVX runner with Python cannot be used, such as LibreChat.

🚀 Quick Start

Use with Claude Desktop

Install via Smithery

Automatically install the MCP SQLite server to support Claude Desktop through Smithery:

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

Manual Installation

Add the following content to the claude_desktop_config.json file:

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

Here is a complete example (assuming using nvm):

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

🔧 Development

Installation of Dependencies

npm ci

Build TypeScript Code

npm run build

Testing with MCP Inspector

You can use the MCP Inspector tool to test the server:

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

After connecting, go to the Tools tab to start using the server.

Testing with Claude Desktop

Add the following content to the claude_desktop_config.json file:

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

Examples:

• /absolute/path/to/node: /Users/johnny/.nvm/versions/node/v20.18.1/bin/node
• /absolute/path/to/index.js: /Users/johnny/projects/mcp-server-sqlite-npx/dist/index.js
• /absolute/path/to/database.db: /Users/johnny/projects/database.db

Publishing

• Update the version number in package.json.
• Run npm install.
• Commit the code with the commit message: Release {version, e.g. 0.1.6}