SQLite Database Analyzer MCP Server

Overview

The SQLite Database Analyzer is a Model Context Protocol (MCP) server that provides database interaction capabilities through SQLite. It allows you to run SQL queries, analyze business data, and automatically generate business intelligence memos.

Installation

Using Claude Desktop

Option 1: Using uv

Add the following configuration to your claude_desktop_config.json file:

"mcpServers": {
  "sqlite": {
    "command": "uv",
    "args": [
      "--directory",
      "PATH_TO_SERVERS_REPO/servers/src/sqlite",
      "run",
      "mcp-server-sqlite",
      "--db-path",
      "~/test.db"
    ]
  }
}

Replace PATH_TO_SERVERS_REPO with the actual path to the parent directory of the servers repository.

Option 2: Using Docker

Add the following configuration to your claude_desktop_config.json file:

"mcpServers": {
  "sqlite": {
    "command": "docker",
    "args": [
      "run",
      "--rm",
      "-i",
      "-v",
      "mcp-test:/mcp",
      "mcp/sqlite",
      "--db-path",
      "/mcp/test.db"
    ]
  }
}

Using VS Code

Quick Installation

For VS Code, you can use the installation buttons provided in the repository README, or manually add the configuration to your settings.

Manual Installation (uv)

Add the following to your User Settings (JSON) file in VS Code or to .vscode/mcp.json in your workspace:

{
  "mcp": {
    "inputs": [
      {
        "type": "promptString",
        "id": "db_path",
        "description": "SQLite Database Path",
        "default": "${workspaceFolder}/db.sqlite"
      }
    ],
    "servers": {
      "sqlite": {
        "command": "uvx",
        "args": [
          "mcp-server-sqlite",
          "--db-path",
          "${input:db_path}"
        ]
      }
    }
  }
}

Manual Installation (Docker)

{
  "mcp": {
    "inputs": [
      {
        "type": "promptString",
        "id": "db_path",
        "description": "SQLite Database Path (within container)",
        "default": "/mcp/db.sqlite"
      }
    ],
    "servers": {
      "sqlite": {
        "command": "docker",
        "args": [
          "run",
          "-i",
          "--rm",
          "-v",
          "mcp-sqlite:/mcp",
          "mcp/sqlite",
          "--db-path",
          "${input:db_path}"
        ]
      }
    }
  }
}

Building from Source

If you want to build the Docker image yourself:

docker build -t mcp/sqlite .

Usage

Once installed, you can interact with the SQLite Database Analyzer through Claude or other compatible AI assistants. The server provides a demonstration prompt that guides you through database operations:

• Use the mcp-demo prompt with a topic argument to specify the business domain you want to analyze
• The server will generate appropriate database schemas and sample data
• You can then use the provided tools to query and analyze the data
• Insights discovered during analysis can be added to a continuously updated business insights memo

The server exposes a dynamic resource memo://insights that automatically updates as new insights are discovered during your analysis.