MCP SQLite Server
by johnnyoshika
# MCP SQLite Server
[](https://smithery.ai/server/mcp-server-sqlite-npx)
A Node.js implementation of the Model Context Protocol SQLite server, based on the [official Python reference](https://github.com/modelcontextprotocol/servers/tree/main/src/sqlite). This version provides an npx-based alternative for environments where Python's UVX runner is not available, such as [LibreChat](https://github.com/danny-avila/LibreChat/issues/4876#issuecomment-2561363955).
## Use with Claude Desktop
### Installing via Smithery
To install MCP SQLite Server for Claude Desktop automatically via [Smithery](https://smithery.ai/server/mcp-server-sqlite-npx):
```bash
npx -y @smithery/cli install mcp-server-sqlite-npx --client claude
```
### Installing Manually
Add the following to `claude_desktop_config.json`:
```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"
}
}
}
}
```
Here's a full example when using nvm:
```json
{
"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
1. Install dependencies:
```bash
npm ci
```
2. Build the TypeScript code:
```bash
npm run build
```
### Testing with MCP Inspector
You can test the server using the [MCP Inspector tool](https://modelcontextprotocol.io/docs/tools/inspector):
```bash
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`:
```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/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`
### Publish
- Bump version in package.json
- `npm install`
- Commit with message: `Release {version, e.g. 0.1.6}`