# codeDB Lens MCP server

> Performs read-only database health checks and answers data questions for SQL Server and PostgreSQL via an AI client.

- Repository: https://github.com/codedb-io/codedb-lens
- Page: https://hostedmcp.org/servers/codedb-io/codedb-lens
- Transport: stdio
- Stars: 8
- License: Apache-2.0
- Latest version: 0.9.1

## Install

### Claude Code

```sh
claude mcp add --env 'CODEDB_LENS_PASSWORD=<YOUR_CODEDB_LENS_PASSWORD>' codedb-lens -- docker run -i --rm ghcr.io/codedb-io/codedb-lens:0.9.1
```

### Cursor (`~/.cursor/mcp.json`)

```json
{
  "mcpServers": {
    "codedb-lens": {
      "command": "docker",
      "args": [
        "run",
        "-i",
        "--rm",
        "ghcr.io/codedb-io/codedb-lens:0.9.1"
      ],
      "env": {
        "CODEDB_LENS_PASSWORD": "<YOUR_CODEDB_LENS_PASSWORD>"
      }
    }
  }
}
```

### VS Code (`.vscode/mcp.json`)

```json
{
  "servers": {
    "codedb-lens": {
      "type": "stdio",
      "command": "docker",
      "args": [
        "run",
        "-i",
        "--rm",
        "ghcr.io/codedb-io/codedb-lens:0.9.1"
      ],
      "env": {
        "CODEDB_LENS_PASSWORD": "<YOUR_CODEDB_LENS_PASSWORD>"
      }
    }
  }
}
```

### VS Code CLI

```sh
code --add-mcp '{"name":"codedb-lens","type":"stdio","command":"docker","args":["run","-i","--rm","ghcr.io/codedb-io/codedb-lens:0.9.1"],"env":{"CODEDB_LENS_PASSWORD":"<YOUR_CODEDB_LENS_PASSWORD>"}}'
```

### Claude Desktop (`claude_desktop_config.json`)

```json
{
  "mcpServers": {
    "codedb-lens": {
      "command": "docker",
      "args": [
        "run",
        "-i",
        "--rm",
        "ghcr.io/codedb-io/codedb-lens:0.9.1"
      ],
      "env": {
        "CODEDB_LENS_PASSWORD": "<YOUR_CODEDB_LENS_PASSWORD>"
      }
    }
  }
}
```

### Codex

```sh
codex mcp add codedb-lens --env 'CODEDB_LENS_PASSWORD=<YOUR_CODEDB_LENS_PASSWORD>' -- docker run -i --rm ghcr.io/codedb-io/codedb-lens:0.9.1
```

### Codex config.toml (`~/.codex/config.toml`)

```toml
[mcp_servers.codedb-lens]
command = "docker"
args = ["run", "-i", "--rm", "ghcr.io/codedb-io/codedb-lens:0.9.1"]

[mcp_servers.codedb-lens.env]
CODEDB_LENS_PASSWORD = "<YOUR_CODEDB_LENS_PASSWORD>"
```

### Gemini CLI

```sh
gemini mcp add -s user -e 'CODEDB_LENS_PASSWORD=<YOUR_CODEDB_LENS_PASSWORD>' codedb-lens docker -- run -i --rm ghcr.io/codedb-io/codedb-lens:0.9.1
```

### Gemini settings.json (`~/.gemini/settings.json`)

```json
{
  "mcpServers": {
    "codedb-lens": {
      "command": "docker",
      "args": [
        "run",
        "-i",
        "--rm",
        "ghcr.io/codedb-io/codedb-lens:0.9.1"
      ],
      "env": {
        "CODEDB_LENS_PASSWORD": "<YOUR_CODEDB_LENS_PASSWORD>"
      }
    }
  }
}
```

## Environment variables

| Name | Required | Secret | Description |
|---|---|---|---|
| `CODEDB_LENS_PASSWORD` | no | yes | password of the login |

## FAQ

### Is codeDB Lens safe to use with my data?

Yes, it uses a read-only login and nothing about your database leaves your machine.

### Can I use codeDB Lens with my AI assistant?

Yes, it provides an MCP server that allows AI clients like Claude, GitHub Copilot, or Cursor to run health checks and answer data questions.

### Does the tool collect telemetry?

No, the tool does not collect telemetry.

### What kind of reports does it generate?

It writes a self-contained HTML and JSON report featuring an A–F grade and a coverage seal.