drio
Open app

MCP SQLite Server

Source

Catalog onlyCatalog onlySTDIO

Overview

MCP SQLite Server is a Node.js implementation of the Model Context Protocol SQLite server, providing a lightweight alternative suitable for environments where a Python implementation is not available.

To use the MCP SQLite Server, you need to configure it in your application, such as Claude Desktop, by providing the correct command and database paths in the configuration file. You can run it using the npx command for easier execution.

  • Node.js based implementation of the Model Context Protocol. - npx support for seamless execution in environments without Python. - Flexible configuration for different application environments, like Claude Desktop.
  1. Integrating SQLite database functionality into Node.js applications.
  2. Serving as a backend server to manage context protocols in applications like LibreChat.
  3. Facilitating database interactions in development and testing environments.

Add to your AI client

Use these steps to connect MCP SQLite Server in Cursor, Claude, VS Code, and other MCP-compatible apps. The same JSON appears in the Use with menu above for one-click copy.

Cursor

Add this to your .cursor/mcp.json file in your project root, then restart Cursor.

.cursor/mcp.json

{
  "mcpServers": {
    "mcp-server-sqlite-npx-johnnyoshika": {
      "command": "npx",
      "args": [
        "-y",
        "@modelcontextprotocol/server-mcp-server-sqlite-npx-johnnyoshika"
      ]
    }
  }
}

Claude Desktop

Add this server entry to the mcpServers object in your Claude Desktop config, then restart the app.

~/Library/Application Support/Claude/claude_desktop_config.json (macOS) or %APPDATA%\Claude\claude_desktop_config.json (Windows)

{
  "mcpServers": {
    "mcp-server-sqlite-npx-johnnyoshika": {
      "command": "npx",
      "args": [
        "-y",
        "@modelcontextprotocol/server-mcp-server-sqlite-npx-johnnyoshika"
      ]
    }
  }
}

Claude Code

Add this to your project's .mcp.json file. Claude Code will detect it automatically.

.mcp.json (project root)

{
  "mcpServers": {
    "mcp-server-sqlite-npx-johnnyoshika": {
      "command": "npx",
      "args": [
        "-y",
        "@modelcontextprotocol/server-mcp-server-sqlite-npx-johnnyoshika"
      ]
    }
  }
}

VS Code (Copilot)

Add this to your .vscode/mcp.json file. Requires the GitHub Copilot extension with MCP support enabled.

.vscode/mcp.json

{
  "servers": {
    "mcp-server-sqlite-npx-johnnyoshika": {
      "type": "stdio",
      "command": "npx",
      "args": [
        "-y",
        "@modelcontextprotocol/server-mcp-server-sqlite-npx-johnnyoshika"
      ]
    }
  }
}

Windsurf

Add this to your Windsurf MCP config file, then restart Windsurf.

~/.codeium/windsurf/mcp_config.json

{
  "mcpServers": {
    "mcp-server-sqlite-npx-johnnyoshika": {
      "command": "npx",
      "args": [
        "-y",
        "@modelcontextprotocol/server-mcp-server-sqlite-npx-johnnyoshika"
      ]
    }
  }
}

Cline

Open Cline settings, navigate to MCP Servers, and add this server configuration.

Cline MCP Settings (via UI)

{
  "mcpServers": {
    "mcp-server-sqlite-npx-johnnyoshika": {
      "command": "npx",
      "args": [
        "-y",
        "@modelcontextprotocol/server-mcp-server-sqlite-npx-johnnyoshika"
      ]
    }
  }
}

FAQ

Is MCP SQLite Server dependent on Python?

No, it is a Node.js implementation, making it suitable for environments where Python is not available.

How can I test the server?

You can test the server using the MCP Inspector tool, which allows you to interact with your database easily.

What dependencies are needed to run MCP SQLite Server?

You need Node.js installed on your system along with the required npm packages, which can be installed using `npm ci`.7:["$","div",null,{"className":"container mx-auto flex flex-col gap-4","children":["$L26","$L27",["$","$L28",null,{"currentProject":{"id":530,"uuid":"5ad7a53a-5b9e-4a56-be10-fd64dceeec4b","name":"mcp-server-sqlite-npx","title":"MCP SQLite Server","description":"","avatar_url":"https://avatars.githubusercontent.com/u/504505?v=4","created_at":"2024-12-30T02:54:21.004Z","updated_at":"2025-01-05T03:00:23.728Z","status":"created","author_name":"johnnyoshika","author_avatar_url":"https://avatars.githubusercontent.com/u/504505?v=4","tags":"[]","category":"developer-tools","is_featured":false,"sort":1,"url":"https://github.com/johnnyoshika/mcp-server-sqlite-npx","target":"_self","content":"$29","summary":"$2a","img_url":"https://camo.githubusercontent.com/2530af14d9c544e960cc537e767f1d6046bb37a11d3b8f0d877cb37b7320a737/68747470733a2f2f736d6974686572792e61692f62616467652f6d63702d7365727665722d73716c6974652d6e7078","type":null,"metadata":"{\"star\":\"2\",\"license\":\"\",\"language\":\"JavaScript\",\"is_official\":false,\"latest_commit_time\":\"2025-03-15 18:03:33\"}","user_uuid":null,"tools":null,"sse_url":null,"sse_provider":null,"sse_params":null,"is_official":false,"server_command":null,"server_params":null,"server_config":null,"allow_call":false,"is_innovation":false,"is_dxt":false,"dxt_manifest":null,"dxt_file_url":null,"is_audit":false},"randomProjects":[],"currentServerKey":"$undefined"}]]}]

Developer tools