Sqlite

# Install the MCP server `io.github.rosch100/mcp-sqlite`

Its page: https://plug.directory/servers/io.github.rosch100/mcp-sqlite

It runs on the person's machine and needs Docker installed.

Ask the person for `YOUR_DB_PATH`, `YOUR_DB_PASSPHRASE` and put it in place of the placeholder; never invent a value.

Use the section for the person's client.

## Claude Desktop, Cursor, Devin Desktop, Cline, LM Studio, Gemini CLI, mcp-client-cli, oterm, TUUI, BoltAI, AnythingLLM, Augment Code, Bob Shell, ECA, Kiro, Kiro CLI

Merge into the place for the person's client:

- Claude Desktop: claude_desktop_config.json (Settings › Developer › Edit Config)
- Cursor: ~/.cursor/mcp.json
- Devin Desktop: ~/.config/devin/mcp_config.json
- Cline: cline_mcp_settings.json (MCP Servers › Configure › Configure MCP Servers)
- LM Studio: mcp.json (Program › Install › Edit mcp.json)
- Gemini CLI: ~/.gemini/settings.json
- mcp-client-cli: ~/.llm/config.json
- oterm: config.json in oterm's data folder (~/Library/Application Support/oterm on macOS, ~/.local/share/oterm on Linux, %APPDATA%\oterm on Windows)
- TUUI: resources/assets/config/mcp.json in the installed app
- BoltAI: ~/.boltai/mcp.json
- AnythingLLM: anythingllm_mcp_servers.json in the AnythingLLM storage plugins directory
- Augment Code: Augment Settings Panel – MCP section – Import from JSON (VS Code extension)
- Bob Shell: ~/.bob/settings/mcp.json (global) or .bob/mcp.json (project)
- ECA: ~/.config/eca/config.json (global) or .eca/config.json in the project
- Kiro: ~/.kiro/settings/mcp.json (user) or .kiro/settings/mcp.json (workspace)
- Kiro CLI: ~/.kiro/settings/mcp.json (user) or .kiro/settings/mcp.json (workspace)

```json
{
  "mcpServers": {
    "mcp-sqlite": {
      "command": "docker",
      "args": ["run", "-i", "--rm", "-e", "DB_PATH", "-e", "DB_PASSPHRASE", "ghcr.io/rosch100/mcp-sqlite:0.2.4"],
      "env": { "DB_PATH": "YOUR_DB_PATH", "DB_PASSPHRASE": "YOUR_DB_PASSPHRASE" }
    }
  }
}
```

## Claude Code

Run in a terminal:

```sh
claude mcp add --env DB_PATH=YOUR_DB_PATH --env DB_PASSPHRASE=YOUR_DB_PASSPHRASE --transport stdio mcp-sqlite -- docker run -i --rm -e DB_PATH -e DB_PASSPHRASE ghcr.io/rosch100/mcp-sqlite:0.2.4
```

## VS Code

Merge into .vscode/mcp.json:

```json
{
  "servers": {
    "mcp-sqlite": {
      "type": "stdio",
      "command": "docker",
      "args": ["run", "-i", "--rm", "-e", "DB_PATH", "-e", "DB_PASSPHRASE", "ghcr.io/rosch100/mcp-sqlite:0.2.4"],
      "env": { "DB_PATH": "YOUR_DB_PATH", "DB_PASSPHRASE": "YOUR_DB_PASSPHRASE" }
    }
  }
}
```

## Zed

Merge into ~/.config/zed/settings.json:

```json
{
  "context_servers": {
    "mcp-sqlite": {
      "command": "docker",
      "args": ["run", "-i", "--rm", "-e", "DB_PATH", "-e", "DB_PASSPHRASE", "ghcr.io/rosch100/mcp-sqlite:0.2.4"],
      "env": { "DB_PATH": "YOUR_DB_PATH", "DB_PASSPHRASE": "YOUR_DB_PASSPHRASE" }
    }
  }
}
```

## Continue

Merge into ~/.continue/config.yaml:

```yaml
mcpServers:
  - name: "mcp-sqlite"
    type: stdio
    command: "docker"
    args:
      - "run"
      - "-i"
      - "--rm"
      - "-e"
      - "DB_PATH"
      - "-e"
      - "DB_PASSPHRASE"
      - "ghcr.io/rosch100/mcp-sqlite:0.2.4"
    env:
      "DB_PATH": "YOUR_DB_PATH"
      "DB_PASSPHRASE": "YOUR_DB_PASSPHRASE"
```

## Goose

Merge into ~/.config/goose/config.yaml:

```yaml
extensions:
  "mcp-sqlite":
    type: stdio
    name: "mcp-sqlite"
    enabled: true
    cmd: "docker"
    args: ["run", "-i", "--rm", "-e", "DB_PATH", "-e", "DB_PASSPHRASE", "ghcr.io/rosch100/mcp-sqlite:0.2.4"]
    env_keys: []
    envs: { "DB_PATH": "YOUR_DB_PATH", "DB_PASSPHRASE": "YOUR_DB_PASSPHRASE" }
    timeout: 300
```

## Codex

Run in a terminal:

```sh
codex mcp add mcp-sqlite --env DB_PATH=YOUR_DB_PATH --env DB_PASSPHRASE=YOUR_DB_PASSPHRASE -- docker run -i --rm -e DB_PATH -e DB_PASSPHRASE ghcr.io/rosch100/mcp-sqlite:0.2.4
```

## Agenvoy

Merge into ~/.config/agenvoy/mcp.json:

```json
{
  "servers": {
    "mcp-sqlite": {
      "command": "docker",
      "args": ["run", "-i", "--rm", "-e", "DB_PATH", "-e", "DB_PASSPHRASE", "ghcr.io/rosch100/mcp-sqlite:0.2.4"],
      "env": { "DB_PATH": "YOUR_DB_PATH", "DB_PASSPHRASE": "YOUR_DB_PASSPHRASE" }
    }
  }
}
```

## Amp

Merge into ~/.config/amp/settings.json (user) or .amp/settings.json (workspace):

```json
{
  "amp.mcpServers": {
    "mcp-sqlite": {
      "command": "docker",
      "args": ["run", "-i", "--rm", "-e", "DB_PATH", "-e", "DB_PASSPHRASE", "ghcr.io/rosch100/mcp-sqlite:0.2.4"],
      "env": { "DB_PATH": "YOUR_DB_PATH", "DB_PASSPHRASE": "YOUR_DB_PASSPHRASE" }
    }
  }
}
```

Then restart the client, or reload its MCP servers, and ask it to list the server's tools to confirm it started.