MCP Server

The Komodo MCP (Model Context Protocol) server connects AI assistants — Cursor, VS Code Copilot, Claude Desktop, and similar clients — to your Komodo Snowflake warehouse so they can explore schemas and help you write SQL.

Prerequisites

1. Install the Marmot Development Kit
2. Authenticate:

   uv run komodo login

3. Set your account:

   uv run komodo account set

Usage

Configuration JSON

Run:

uv run komodo mcp show-config

The CLI prints (and copies) the right JSON for your environment. The snippets below show the same inner komodo server definition; only the outer wrapper changes per client.

Replace /path/to/your/komodo/project with the directory that contains your pyproject.toml where komodo is installed (often your app or workspace root).

Shared server definition

Every client uses this object under its own key (see tabs).

"komodo": {
  "command": "uv",
  "args": ["run", "komodo", "mcp", "run"],
  "cwd": "/path/to/your/komodo/project"
}

Editor configuration

All tools operate against production. Configure the MCP server in your editor:

Cursor

File: ~/.cursor/mcp.json

{
  "mcpServers": {
    "komodo": {
      "command": "uv",
      "args": ["run", "komodo", "mcp", "run"],
      "cwd": "/path/to/your/komodo/project"
    }
  }
}

VS Code

User or workspace settings.json — server lives under mcp.servers:

{
  "mcp": {
    "servers": {
      "komodo": {
        "command": "uv",
        "args": ["run", "komodo", "mcp", "run"],
        "cwd": "/path/to/your/komodo/project"
      }
    }
  }
}

Claude Desktop

Same top-level shape as Cursor (mcpServers):

{
  "mcpServers": {
    "komodo": {
      "command": "uv",
      "args": ["run", "komodo", "mcp", "run"],
      "cwd": "/path/to/your/komodo/project"
    }
  }
}

Run the server manually

uv run komodo mcp run

Clients normally start this command using the configuration above.

Tip

The MCP server also exposes App Builder tools for scaffolding, building, and deploying apps. The default remote build path uses Komodo OAuth only (no AWS credentials). Local build_mode uses BuildKit on your machine to produce an image tarball, then uploads through the Build API prebuilt path — still OAuth only, no client ECR push. For local builds, configure BUILDKIT_HOST on the MCP server (not only in your shell); see App Builder — BUILDKIT_HOST. See the App Builder MCP Tools Reference for the full tool list.

Try it out

After configuring your client, try:

“What are my Komodo databases?”

Capabilities

list_snowflake list_type	Description	Required parameters
database	List accessible databases	—
schema	Schemas in a database	database
table	Tables in a schema (metadata / row counts)	database, schema
column	Column definitions	database, schema, table

In internal Komodo environments, komodo-internal-tools registers additional MCP tools; see internal documentation for the full list.