MCP SQLite Server

by johnnyoshika

Integrations

  • Implements a Model Context Protocol server for SQLite databases, allowing AI assistants to query and interact with SQLite databases

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
F
license - not found
-
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
    A
    license
    -
    quality
    A Model Context Protocol server that enables seamless execution of commands, Python code, web content fetching, and reusable task management with secure credentials handling.
    Last updated -
    2
    Python
    MIT License
    • Apple
  • -
    security
    F
    license
    -
    quality
    A Node.js application that provides a Model Context Protocol server for interacting with Harbor container registry, supporting operations for projects, repositories, tags, and Helm charts.
    Last updated -
    TypeScript
  • -
    security
    -
    license
    -
    quality
    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.
    Last updated -
    Python

View all related MCP servers

ID: g0zgwpqegg