mcpField
M
MCP SQLite Server

MCP SQLite Server

Local
github.com/johnnyoshikaDatabases17Updated 53w ago
Repository

About MCP SQLite Server

MCP SQLite Server is a Node.js SQLite MCP server based on the official Python reference implementation. It provides an npx alternative for environments where the UVX runner is unavailable and accepts a database file as an argument.

Key features

  1. 01Based on the official Python reference
  2. 02Implemented in Node.js
  3. 03Launch with npx
  4. 04Specify a SQLite database file
  5. 05Test with MCP Inspector

Use cases

  1. 01Use an SQLite MCP server where UVX is unavailable
  2. 02Configure a database file for Claude Desktop
  3. 03Test the server with MCP Inspector

MCP support

The server provides SQLite database tools to MCP clients, with the database file specified at launch. The README shows configuration for Claude Desktop and testing with MCP Inspector.

#mcp#sqlite#server#nodejs

Configuration

Local server config is the same for every client. Copy it into your client’s MCP config file.

mcp.json · Universal config
{
  "mcpServers": {
    "sqlite-npx": {
      "command": "npx",
      "args": [
        "-y",
        "@smithery/cli"
      ]
    }
  }
}
Run commandnpx -y @smithery/cli

Local servers need a runtime on your machine (e.g. Node.js 18+). Config file locations differ by client; see your client’s docs.

Packages
npm@smithery/cli

Tools

No tool list yet

Local servers expose tools only once running on your machine, and the maintainer has not provided a tool list.

Details

From the project README

MCP SQLite Server

smithery badge MseeP.ai Security Assessment 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 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:

~/Library/Application Support/Claude/claude_desktop_config.json

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

%APPDATA%\Claude\claude_desktop_config.json

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

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}

Comments

Markdown supported

New to MCP?

From what the protocol is to installing your first server, these answers cover most first questions.

An open protocol that defines how AI applications connect to external tools and data in a uniform way. Clients talk to the model; MCP servers provide tools, resources and prompt templates. They exchange standard messages, so one server can be reused by many clients.