Skip to main content
Glama

MCP SQLite Server

MCP SQLite Server

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}
-
security - not tested
A
license - permissive license
-
quality - not tested

local-only server

The server can only run on the client's local machine because it depends on local resources.

A Node.js implementation of the Model Context Protocol server using SQLite, providing a npx-based alternative for environments lacking Python's UVX runner.

  1. Use with Claude Desktop
    1. Installing via Smithery
    2. Installing Manually
  2. Development
    1. Testing with MCP Inspector
    2. Testing with Claude Desktop
    3. Publish

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
    F
    license
    -
    quality
    A Model Context Protocol server that enables SQL operations (SELECT, INSERT, UPDATE, DELETE) and table management through a standardized interface with SQLite databases.
    Last updated -
    393
    JavaScript
  • -
    security
    A
    license
    -
    quality
    A Model Context Protocol server that allows users to store, retrieve, update, and delete memories using SQLite storage.
    Last updated -
    Python
    MIT License
  • -
    security
    F
    license
    -
    quality
    A comprehensive Node.js server implementing Model Context Protocol (MCP) that enables filesystem operations, process management, and terminal session handling with an enterprise-grade security approach.
    Last updated -
    114,220
    TypeScript

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