Aurora

Host setup guide

Host Setup Guide

HostSupportBest for
Claude Desktop✅ - Dynamic config management through aurora CLIExploring your data and generating visualizations
Cursor: Global✅ - Dynamic config management through aurora CLIAlmost always better to use project-based configuration
Cursor: Project Based✅ - Dynamic config management through aurora CLICreating code in your data engineering project or around it
Windsurf: Global✅ - Dynamic config management through aurora CLIAlmost always better to use project-based configuration
Others⚠️ - Try at your own risk, JSON config belowLiving on the edge. Tell us what you are using at aurora@fiveonefour.com

Our opinion on what each host is best for is based on our experience as of March 27th 2025 (this stuff changes quickly)!

Claude Desktop

Quick Links

To create a new project (for details, see CLI Reference)

aurora init <PROJECT-NAME> <TEMPLATE-NAME> --mcp claude-desktop

To configure the MCP for an existing project (for details, see CLI Reference)

aurora setup --mcp claude-desktop

This will look to the directory Claude stores its MCP configuration (~/Library/Application Support/Claude/claude_desktop_config.json):

  • If there isn’t a file there, it will create a config file and add the appropriate configuration JSON that allows it to use Aurora MCP
  • If there is an existing file there, and there is no configuration, it will add the appropriate configuration JSON that allows it to use Aurora MCP
  • If there is an existing file there with other MCPs, it will add the "aurora" JSON object to configure the aurora MCP

It will also list the project directory in the ~/.aurora/config.toml file such that any changes to your MCP preferences (aurora config) will be propagated to this project.

Note: you will have to restart Claude Desktop for the MCP to be picked up. If it was successful, you will see the Aurora tools listed beside the main chat box.

Common issues—if Claude Desktop doesn’t pick up Aurora MCP:

Common issues—if the MCP isn’t giving you access to data

  • Ensure the local development server is running (moose dev)

Cursor Global MCP

To create a new project (for details, see CLI Reference)

aurora init <PROJECT-NAME> <TEMPLATE-NAME> --mcp cursor-global

To configure the MCP for an existing project (for details, see CLI Reference)

aurora setup --mcp cursor-global

This will look to the directory Cursor stores its MCP configuration (~/.cursor/mcp.json):

  • If there isn’t a file there, it will create a config file and add the appropriate configuration JSON that allows it to use Aurora MCP
  • If there is an existing file there, and there is no configuration, it will add the appropriate configuration JSON that allows it to use Aurora MCP
  • If there is an existing file there with other MCPs, it will add the "aurora" JSON object to configure the aurora MCP

It will also list the project directory in the ~/.aurora/config.toml file such that any changes to your MCP preferences (aurora config) will be propagated to this project.

You will have to enable the MCP server in the Cursor MCP settings (Cursor > Settings > Cursor Settings > MCP). You may then need to refresh the MCP server for it to work.

Common issues—if Cursor doesn’t allow ”🟢” the MCP:

Common issues—if the MCP isn’t giving you access to data

  • Ensure the local development server is running (moose dev)

Cursor Project Based MCP (preferred)

To create a new project (for details, see CLI Reference)

aurora init <PROJECT-NAME> <TEMPLATE-NAME> --mcp cursor-project

To configure the MCP for an existing project (for details, see CLI Reference)

aurora setup

You don’t need to use the --mcp flag since cursor-project is our default option.

This will look within the project for where Cursor stores its MCP configuration (<path/to/project-root>/.cursor/mcp.json):

  • If there isn’t a file there, it will create a config file and add the appropriate configuration JSON that allows it to use Aurora MCP
  • If there is an existing file there, and there is no configuration, it will add the appropriate configuration JSON that allows it to use Aurora MCP
  • If there is an existing file there with other MCPs, it will add the "aurora" JSON object to configure the aurora MCP

It will also list the project directory in the ~/.aurora/config.toml file such that any changes to your MCP preferences (aurora config) will be propagated to this project.

You will have to enable the MCP server in the Cursor MCP settings (Cursor > Settings > Cursor Settings > MCP). You may then need to refresh the MCP server for it to work.

Common issues—if Cursor doesn’t 🟢 the MCP:

Common issues—if the MCP isn’t giving you access to data

  • Ensure the local development server is running (moose dev)

Cursor FAQ:

  • I have the MCPs running, I can see them enabled and I can see the little green dot, but Cursor isn’t using any of my tools?
    • Cursor will use the tools if the chat bar is set to agent mode (see the bottom left of the chat bar). Ensure you are in agent mode.

Windsurf Global MCP

To create a new project (for details, see CLI Reference)

aurora init <PROJECT-NAME> <TEMPLATE-NAME> --mcp windsurf-global

To configure the MCP for an existing project (for details, see CLI Reference)

aurora setup --mcp windsurf-global

This will look to the directory Windsurf stores its MCP configuration (~/.codeium/windsurf/mcp_config.json):

  • If there isn’t a file there, it will create a config file and add the appropriate configuration JSON that allows it to use Aurora MCP
  • If there is an existing file there, and there is no configuration, it will add the appropriate configuration JSON that allows it to use Aurora MCP
  • If there is an existing file there with other MCPs, it will add the "aurora" JSON object to configure the aurora MCP

It will also list the project directory in the ~/.aurora/config.toml file such that any changes to your MCP preferences (aurora config) will be propagated to this project.

You will have to enable the MCP server in the Cascade MCP settings (Windsurf > Settings > Windsurf Settings > Cascade). You may then need to refresh the MCP server for it to work.

MCP.json

Note, this will create an MCP outside of the management of the Aurora CLI (changes to focus, tools, etc. will not be propagated to this MCP).

Standard tooling, local only (note, you only need node or python, not both):

{
  "mcpServers": {
    "aurora": {
      "args": [
        "@514labs/aurora-mcp@latest",
        "/path/to/moose/project"
      ],
      "command": "npx",
      "env": {
        "ANTHROPIC_API_KEY": "<key>",
        "MOOSE_PATH": "/path/to/.moose/bin/moose",
        "NODE_PATH": "/path/to/.nvm/versions/node/v22.14.0/bin/node",
        "PYTHON_PATH": "/path/to/.pyenv/shims/python"
      }
    }
  }
}

Experimental tooling, local only (note, you only need node or python, not both):

{
  "mcpServers": {
    "aurora": {
      "args": [
        "@514labs/aurora-mcp@latest",
        "--experimental",
        "/path/to/moose/project"
      ],
      "command": "npx",
      "env": {
        "ANTHROPIC_API_KEY": "<key>",
        "MOOSE_PATH": "/path/to/.moose/bin/moose",
        "NODE_PATH": "/path/to/.nvm/versions/node/v22.14.0/bin/node",
        "PYTHON_PATH": "/path/to/.pyenv/shims/python"
      }
    }
  }
}

Experimental tooling, local development and remote Boreal—requires creation of read only credentials for Boreal managed Clickhouse:

{
  "mcpServers": {
    "aurora": {
      "args": [
        "@514labs/aurora-mcp@latest",
        "--experimental",
        "--boreal-experimental",
        "/path/to/moose/project"
      ],
      "command": "npx",
      "env": {
        "ANTHROPIC_API_KEY": "<key>",
        "BOREAL_CLICKHOUSE_DATABASE": "",
        "BOREAL_CLICKHOUSE_HOST": "",
        "BOREAL_CLICKHOUSE_PASSWORD": "",
        "BOREAL_CLICKHOUSE_PORT": "",
        "BOREAL_CLICKHOUSE_USER": "",
        "MOOSE_PATH": "/path/to/.moose/bin/moose",
        "NODE_PATH": "/path/to/.nvm/versions/node/v22.14.0/bin/node",
        "PYTHON_PATH": "/path/to/.pyenv/shims/python"
      }
    }
  }
}

Query to create read only credentials:

CREATE USER username IDENTIFIED BY 'password' SETTINGS PROFILE 'readonly'
GRANT SHOW TABLES, SELECT ON db+name.* TO username