MCP SQLite Server

Generic MCP server to manipulate SQLite

Catalog onlyCatalog onlySTDIO

Overview

MCP SQLite is a Go-based server implementation that allows clients to interact with an SQLite database using a standardized JSON-RPC protocol.

To use MCP SQLite, configure the server via a YAML file, start the server, and send JSON-RPC requests from MCP clients to execute various database operations.

MCP Compliance: Provides a JSON-RPC interface for executing database operations. - SQLite Operations: Supports creating tables, describing schemas, listing tables, and executing read/write queries.

Integrating with applications like Claude Desktop for database management.
Automating database operations through JSON-RPC requests.
Facilitating data storage and retrieval in Go-based applications.

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-sqlite-cnosuke": {
      "command": "npx",
      "args": [
        "-y",
        "@modelcontextprotocol/server-mcp-sqlite-cnosuke"
      ]
    }
  }
}

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-sqlite-cnosuke": {
      "command": "npx",
      "args": [
        "-y",
        "@modelcontextprotocol/server-mcp-sqlite-cnosuke"
      ]
    }
  }
}

Claude Code

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

.mcp.json (project root)

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

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-sqlite-cnosuke": {
      "type": "stdio",
      "command": "npx",
      "args": [
        "-y",
        "@modelcontextprotocol/server-mcp-sqlite-cnosuke"
      ]
    }
  }
}

Windsurf

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

~/.codeium/windsurf/mcp_config.json

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

Cline

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

Cline MCP Settings (via UI)

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

FAQ

What programming language is MCP SQLite written in?

MCP SQLite is written in Go.

How do I configure the SQLite database path?

You can configure the path in the YAML file or set it via the `SQLITE_PATH` environment variable.

Is there a logging feature?

Yes, you can adjust logging behavior using command-line flags.

Developer tools