mcp-server-sqlite-npx

MCP.Pizza Chef: johnnyoshika

The mcp-server-sqlite-npx is a Node.js implementation of the Model Context Protocol SQLite server, providing an npx-based alternative to the official Python reference server. It enables MCP clients to interact with SQLite databases in environments where Python's UVX runner is unavailable, such as LibreChat. This server facilitates seamless integration of SQLite data sources into MCP workflows, supporting real-time context feeding and interaction with LLMs.

Use This MCP server To

Enable MCP clients to access SQLite databases via Node.js Integrate SQLite data sources in environments lacking Python support Use with Claude Desktop for enhanced local context management Deploy MCP SQLite server in JavaScript/Node.js-based workflows Provide real-time structured data from SQLite to LLMs Replace Python MCP SQLite server in restricted environments

README

MCP SQLite Server

smithery badge

A Node.js implementation of the Model Context Protocol SQLite server, based on the official Python reference. This version provides an npx-based alternative for environments where Python's UVX runner is not available, such as LibreChat.

Use with Claude Desktop

Installing via Smithery

To install MCP SQLite Server for Claude Desktop automatically via Smithery:

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

Installing Manually

Add the following to 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"
      }
    }
  }
}

Full example when using nvm on macoS:

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

Full example when using nvm on Windows:

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

Development

  1. Install dependencies:
npm ci
  1. Build the TypeScript code:
npm run build

Testing with MCP Inspector

You can test the server using the MCP Inspector tool:

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

Connect and go to Tools to start using the server.

Testing with Claude Desktop

Add the following to claude_desktop_config.json:

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

Examples:

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

Publish

  • Bump version in package.json
  • npm install
  • Commit with message: Release {version, e.g. 0.1.6}

mcp-server-sqlite-npx FAQ

How do I install the mcp-server-sqlite-npx server?
You can install it using npx with the command 'npx -y @smithery/cli install mcp-server-sqlite-npx --client claude' or manually configure it in your client JSON.
Can this server be used without Python installed?
Yes, it is designed as a Node.js alternative to the Python MCP SQLite server, ideal for environments without Python UVX runner.
Is this server compatible with Claude Desktop?
Yes, it is specifically supported for use with Claude Desktop and can be configured via its JSON config file.
What is the advantage of using this Node.js MCP SQLite server?
It allows MCP clients to interact with SQLite databases in JavaScript environments, expanding compatibility beyond Python-based setups.
Does this server support real-time context updates from SQLite?
Yes, it provides real-time structured data access from SQLite databases to MCP clients and LLMs.
How do I configure the server command and arguments?
Configuration is done by specifying the npx command and appropriate arguments in the MCP client config JSON, such as claude_desktop_config.json.
Can this server be integrated into other MCP clients besides Claude?
While primarily demonstrated with Claude Desktop, it can be integrated with any MCP client that supports external MCP servers.