# semlayer MCP server

> Infers a portable semantic layer from data warehouses and serves it to AI agents via MCP to improve query accuracy and business logic adherence.

- Repository: https://github.com/semlayer-dev/semlayer
- Page: https://hostedmcp.org/servers/semlayer-dev/semlayer
- Transport: stdio
- Stars: 4
- Latest version: 0.7.0b6

## Install

### Claude Code

```sh
claude mcp add --env 'ANTHROPIC_API_KEY=<YOUR_ANTHROPIC_API_KEY>' semlayer -- uvx semlayer
```

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

```json
{
  "mcpServers": {
    "semlayer": {
      "command": "uvx",
      "args": [
        "semlayer"
      ],
      "env": {
        "ANTHROPIC_API_KEY": "<YOUR_ANTHROPIC_API_KEY>"
      }
    }
  }
}
```

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

```json
{
  "servers": {
    "semlayer": {
      "type": "stdio",
      "command": "uvx",
      "args": [
        "semlayer"
      ],
      "env": {
        "ANTHROPIC_API_KEY": "<YOUR_ANTHROPIC_API_KEY>"
      }
    }
  }
}
```

### VS Code CLI

```sh
code --add-mcp '{"name":"semlayer","type":"stdio","command":"uvx","args":["semlayer"],"env":{"ANTHROPIC_API_KEY":"<YOUR_ANTHROPIC_API_KEY>"}}'
```

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

```json
{
  "mcpServers": {
    "semlayer": {
      "command": "uvx",
      "args": [
        "semlayer"
      ],
      "env": {
        "ANTHROPIC_API_KEY": "<YOUR_ANTHROPIC_API_KEY>"
      }
    }
  }
}
```

### Codex

```sh
codex mcp add semlayer --env 'ANTHROPIC_API_KEY=<YOUR_ANTHROPIC_API_KEY>' -- uvx semlayer
```

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

```toml
[mcp_servers.semlayer]
command = "uvx"
args = ["semlayer"]

[mcp_servers.semlayer.env]
ANTHROPIC_API_KEY = "<YOUR_ANTHROPIC_API_KEY>"
```

### Gemini CLI

```sh
gemini mcp add -s user -e 'ANTHROPIC_API_KEY=<YOUR_ANTHROPIC_API_KEY>' semlayer uvx -- semlayer
```

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

```json
{
  "mcpServers": {
    "semlayer": {
      "command": "uvx",
      "args": [
        "semlayer"
      ],
      "env": {
        "ANTHROPIC_API_KEY": "<YOUR_ANTHROPIC_API_KEY>"
      }
    }
  }
}
```

## Environment variables

| Name | Required | Secret | Description |
|---|---|---|---|
| `ANTHROPIC_API_KEY` | no | yes | Optional. Descriptions and LLM-validated joins need it; statistics-only inference works without it. |

## FAQ

### How much does it cost to use?

It costs approximately $0.70 per 100 tables using the cheap model tier with your own API key.

### Can I use it without an LLM?

Yes, it has a fully deterministic mode called --no-llm that requires zero API calls.

### Does it send my actual data to the LLM?

You can use the --no-sample-egress flag to ensure no values from warehouse cells are sent to the LLM.
