MCP Server

The Komodo MCP (Model Context Protocol) server allows AI assistants like Cursor, VS Code Copilot, Claude Desktop, and Amp to explore your Snowflake schemas.

Prerequisites

Install the Komodo SDK
Authenticate:
Terminal window
```
uv run komodo login
```
Set your account:
Terminal window
```
uv run komodo account set
```

Usage

Get Configuration

Generate the MCP server configuration JSON to add to your AI assistant:

uv run komodo alpha mcp show-config

The configuration is automatically copied to your clipboard.

Options:

--name, -n - Custom server name (default: komodo)

Client Configuration

Cursor

Add to ~/.cursor/mcp.json:

{
  "mcpServers": {
    "komodo": {
      "command": "uv",
      "args": ["run", "komodo", "alpha", "mcp", "run"]
    }
  }
}

VS Code

Add to your VS Code settings.json:

{
  "mcp": {
    "servers": {
      "komodo": {
        "command": "uv",
        "args": ["run", "komodo", "alpha", "mcp", "run"]
      }
    }
  }
}

Try It Out

After configuring your client, ask your AI assistant:

“What are my Komodo databases?”

Capabilities

The MCP server provides tools for:

Listing databases, schemas, and tables
Exploring column definitions
Understanding Komodo’s healthcare data structure