SQLite (Node.js)

by johnnyoshika

13 stars

4.1k downloads

Not rated

GitHub

About

A Node.js MCP server for interacting with local SQLite databases, runnable via npx.

Details

Author: johnnyoshika
Repository: johnnyoshika/mcp-server-sqlite-npx
GitHub stars: 13
Downloads: 4,055
License: MIT License
Categories: Database, Other, Developer Tools, Design, File Management, AI, Community, Infrastructure, Communication
Tags: #integration

- Node.js-based implementation of the Model Context Protocol SQLite server
- npx-deployable alternative to the official Python SQLite server
- Integrates with Claude Desktop via manual or Smithery installation
- Provides SQLite database operations through the MCP interface
- Supports MCP Inspector for testing and debugging
- Allows automatic installation via the Smithery CLI

Setting up with Highlight

This MCP is not yet compatible with Highlight’s one-click setup. However, you can still use it with Highlight by following these steps:

Download and install Highlight from highlightai.com/download
Navigate to the plugins tab and select "Add Custom Plugin"
Configure the plugin with the settings below
Plugin Name SQLite (Node.js)

Command (node, npx, python, etc.) /Users/{username}/.nvm/versions/node/v22.12.0/bin/npx
Arguments
- Argument 1 -y
- Argument 2 mcp-server-sqlite-npx
- Argument 3 /Users/{username}/projects/database.db
Environment
- 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
Please refer to the README for specific instructions on how to obtain API keys or other required environment variables.
Enable "Start Automatically" if you want the plugin to start when Highlight launches

Setting up with Cursor

Open Cursor's settings
Navigate to the MCP section
Click "Add new Global MCP server"
Copy and paste the configuration below based on your operating system

JSON

{
    "mcpServers": {
        "sqlite (node.js)": {
            "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"
            },
            "args": [
                "-y",
                "mcp-server-sqlite-npx",
                "/Users/{username}/projects/database.db"
            ],
            "command": "/Users/{username}/.nvm/versions/node/v22.12.0/bin/npx"
        }
    }
}

JSON

{
    "mcpServers": {
        "sqlite (node.js)": {
            "env": {
                "PATH": "C:\\Program Files\\nodejs;%PATH%",
                "NODE_PATH": "C:\\Program Files\\nodejs\\node_modules"
            },
            "args": [
                "-y",
                "mcp-server-sqlite-npx",
                "C:\\Users\\{username}\\projects\\database.db"
            ],
            "command": "C:\\Program Files\\nodejs\\npx.cmd"
        }
    }
}

JSON

{
    "mcpServers": {
        "sqlite (node.js)": {
            "env": {
                "PATH": "/absolute/path/to/executables",
                "NODE_PATH": "/absolute/path/to/node_modules"
            },
            "args": [
                "-y",
                "mcp-server-sqlite-npx",
                "/absolute/path/to/database.db"
            ],
            "command": "/absolute/path/to/npx"
        }
    }
}

Setting up with Claude Desktop

Open Claude Desktop's settings
Go to the Integrations tab
Click "Add MCP Server"
Use the configuration below based on your operating system

Note: Make sure Claude Desktop is running before attempting to connect.

JSON

{
    "mcpServers": {
        "sqlite (node.js)": {
            "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"
            },
            "args": [
                "-y",
                "mcp-server-sqlite-npx",
                "/Users/{username}/projects/database.db"
            ],
            "command": "/Users/{username}/.nvm/versions/node/v22.12.0/bin/npx"
        }
    }
}

JSON

{
    "mcpServers": {
        "sqlite (node.js)": {
            "env": {
                "PATH": "C:\\Program Files\\nodejs;%PATH%",
                "NODE_PATH": "C:\\Program Files\\nodejs\\node_modules"
            },
            "args": [
                "-y",
                "mcp-server-sqlite-npx",
                "C:\\Users\\{username}\\projects\\database.db"
            ],
            "command": "C:\\Program Files\\nodejs\\npx.cmd"
        }
    }
}

JSON

{
    "mcpServers": {
        "sqlite (node.js)": {
            "env": {
                "PATH": "/absolute/path/to/executables",
                "NODE_PATH": "/absolute/path/to/node_modules"
            },
            "args": [
                "-y",
                "mcp-server-sqlite-npx",
                "/absolute/path/to/database.db"
            ],
            "command": "/absolute/path/to/npx"
        }
    }
}

Setting up with Windsurf

Open Windsurf's preferences
Go to the Integrations section
Click "Add MCP Integration"
Use the configuration below based on your operating system

JSON

{
    "mcpServers": {
        "sqlite (node.js)": {
            "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"
            },
            "args": [
                "-y",
                "mcp-server-sqlite-npx",
                "/Users/{username}/projects/database.db"
            ],
            "command": "/Users/{username}/.nvm/versions/node/v22.12.0/bin/npx"
        }
    }
}

JSON

{
    "mcpServers": {
        "sqlite (node.js)": {
            "env": {
                "PATH": "C:\\Program Files\\nodejs;%PATH%",
                "NODE_PATH": "C:\\Program Files\\nodejs\\node_modules"
            },
            "args": [
                "-y",
                "mcp-server-sqlite-npx",
                "C:\\Users\\{username}\\projects\\database.db"
            ],
            "command": "C:\\Program Files\\nodejs\\npx.cmd"
        }
    }
}

JSON

{
    "mcpServers": {
        "sqlite (node.js)": {
            "env": {
                "PATH": "/absolute/path/to/executables",
                "NODE_PATH": "/absolute/path/to/node_modules"
            },
            "args": [
                "-y",
                "mcp-server-sqlite-npx",
                "/absolute/path/to/database.db"
            ],
            "command": "/absolute/path/to/npx"
        }
    }
}

Setting up with Cline

Open Cline's settings
Navigate to the Integrations section
Click "Add MCP Server"
Copy and paste the configuration below based on your operating system

Note: Make sure to restart Cline after adding the configuration.

JSON

{
    "mcpServers": {
        "sqlite (node.js)": {
            "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"
            },
            "args": [
                "-y",
                "mcp-server-sqlite-npx",
                "/Users/{username}/projects/database.db"
            ],
            "command": "/Users/{username}/.nvm/versions/node/v22.12.0/bin/npx"
        }
    }
}

JSON

{
    "mcpServers": {
        "sqlite (node.js)": {
            "env": {
                "PATH": "C:\\Program Files\\nodejs;%PATH%",
                "NODE_PATH": "C:\\Program Files\\nodejs\\node_modules"
            },
            "args": [
                "-y",
                "mcp-server-sqlite-npx",
                "C:\\Users\\{username}\\projects\\database.db"
            ],
            "command": "C:\\Program Files\\nodejs\\npx.cmd"
        }
    }
}

JSON

{
    "mcpServers": {
        "sqlite (node.js)": {
            "env": {
                "PATH": "/absolute/path/to/executables",
                "NODE_PATH": "/absolute/path/to/node_modules"
            },
            "args": [
                "-y",
                "mcp-server-sqlite-npx",
                "/absolute/path/to/database.db"
            ],
            "command": "/absolute/path/to/npx"
        }
    }
}

Setting up with Goose

Open Goose's preferences
Go to the Integrations tab
Select "MCP Servers"
Click "Add New Server"
Use the configuration below based on your operating system

JSON

{
    "mcpServers": {
        "sqlite (node.js)": {
            "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"
            },
            "args": [
                "-y",
                "mcp-server-sqlite-npx",
                "/Users/{username}/projects/database.db"
            ],
            "command": "/Users/{username}/.nvm/versions/node/v22.12.0/bin/npx"
        }
    }
}

JSON

{
    "mcpServers": {
        "sqlite (node.js)": {
            "env": {
                "PATH": "C:\\Program Files\\nodejs;%PATH%",
                "NODE_PATH": "C:\\Program Files\\nodejs\\node_modules"
            },
            "args": [
                "-y",
                "mcp-server-sqlite-npx",
                "C:\\Users\\{username}\\projects\\database.db"
            ],
            "command": "C:\\Program Files\\nodejs\\npx.cmd"
        }
    }
}

JSON

{
    "mcpServers": {
        "sqlite (node.js)": {
            "env": {
                "PATH": "/absolute/path/to/executables",
                "NODE_PATH": "/absolute/path/to/node_modules"
            },
            "args": [
                "-y",
                "mcp-server-sqlite-npx",
                "/absolute/path/to/database.db"
            ],
            "command": "/absolute/path/to/npx"
        }
    }
}

From the repository

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

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

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

Claude Desktop / Cursor

Paste into your MCP client config file to install this server.

{
    "mcpServers": {
        "sqlite (node.js)": {
            "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"
            },
            "args": [
                "-y",
                "mcp-server-sqlite-npx",
                "/Users/{username}/projects/database.db"
            ],
            "command": "/Users/{username}/.nvm/versions/node/v22.12.0/bin/npx"
        }
    }
}

Linux

{
    "env": {
        "PATH": "/absolute/path/to/executables",
        "NODE_PATH": "/absolute/path/to/node_modules"
    },
    "args": [
        "-y",
        "mcp-server-sqlite-npx",
        "/absolute/path/to/database.db"
    ],
    "command": "/absolute/path/to/npx"
}

Macos

{
    "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"
    },
    "args": [
        "-y",
        "mcp-server-sqlite-npx",
        "/Users/{username}/projects/database.db"
    ],
    "command": "/Users/{username}/.nvm/versions/node/v22.12.0/bin/npx"
}

Windows

{
    "env": {
        "PATH": "C:\\Program Files\\nodejs;%PATH%",
        "NODE_PATH": "C:\\Program Files\\nodejs\\node_modules"
    },
    "args": [
        "-y",
        "mcp-server-sqlite-npx",
        "C:\\Users\\{username}\\projects\\database.db"
    ],
    "command": "C:\\Program Files\\nodejs\\npx.cmd"
}

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

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

~/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" } } } }

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

To install MCP SQLite Server for Claude Desktop automatically viaSmithery:

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

You can test the server using the MCP Inspector tool:

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

Connectand go toToolsto start using the server.

Add the following toclaude_desktop_config.json:

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

- /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

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

Database MCP server for MySQL, MariaDB, PostgreSQL & SQLite

A single-binary MCP server for MySQL, MariaDB, PostgreSQL, and SQLite

A Model Context Protocol (MCP) server that provides multi-database query execution capabilities with support for SQLite, PostgreSQL, and MySQL databases. Includes a built-in Web UI for managing database connections.

Enables AI assistants to interact with various databases through JDBC connections.

Production-grade Model Context Protocol (MCP) server for unified SQL database access. Connect multiple databases through a single MCP server with schema discovery, relationship mapping, caching, and safety controls.

Connects to and interacts with various database systems like SQLite, PostgreSQL, SQL Server, and MongoDB.

Provides database access for SQLite, SQL Server, PostgreSQL, and MySQL.

Multi-database analysis MCP server (PostgreSQL, MySQL, SQLite). Inspects schemas, detects index problems, analyzes table bloat, and explains query plans for actionable database optimization.

A lightweight MCP server for any database with a JDBC driver. Built with Quarkus and requires Java 21+.

An MCP server that provides AI assistants with structured access to multiple databases simultaneously.

No reviews yet — be the first

Use Google, GitHub, or an email account so ratings stay tied to real people.

Email sign in

No reviews posted yet.

SQLite (Node.js)

About

Details

Jump to

Setting up with Highlight

Setting up with Cursor

JSON

JSON

JSON

Setting up with Claude Desktop

JSON

JSON

JSON

Setting up with Windsurf

JSON

JSON

JSON

Setting up with Cline

JSON

JSON

JSON

Setting up with Goose

JSON

JSON

JSON

From the repository

Claude Desktop / Cursor

Linux

Macos

Windows

Install

About

Details

Jump to

Setting up with Highlight

From the repository

Claude Desktop / Cursor

Linux

Macos

Windows

Install

More like this

Sequential Thinking

Redis

Sentry

Github

Filesystem

EverArt