# Domo MCP Server

A Model Context Protocol (MCP) server that connects to Domo API.

## Tools

- Run SQL queries on Domo DataSets
- Search for DataSets by name
- Get the metadata of Domo DataSets
- Get the schema of Domo DataSets

## Prerequisites

- Python 3.11+ OR Docker
- Visual Studio Code
- Domo instance with:
  - Developer access token
  - Access to datasets to query

## Setup

### Local Python Setup

1. Clone this repository
1. Navigate to the cloned directory
1. Install the required packages:
   ```bash
   pip install -r requirements.txt
   ```
1. Add configuration to your VS Code settings:
   ```json
   {
     "name": "Domo MCP Server",
     "type": "stdio",
     "command": "python",
     "args": ["-m", "domo_mcp"],
     "env": {
       "PYTHONPATH": "${workspaceFolder}",
       "DOMO_DEVELOPER_TOKEN": "<your_domo_developer_token>",
       "DOMO_HOST": "<instance-name.domo.com>"
     }
   }
   ```
1. Ensure the server is running

### Local Docker Setup

1. Clone this repository
1. Navigate to the cloned directory
1. Build the Docker image:
   ```bash
    docker build -t domo-mcp-server .
   ```
1. Add configuration to your VS Code settings:
   ```json
      "domo-mcp": {
        "command": "docker",
        "args": [
          "run",
          "-i",
          "-e",
          "DOMO_DEVELOPER_TOKEN",
          "-e",
          "DOMO_HOST",
          "domo-mcp-server"
        ],
        "env": {
          "DOMO_DEVELOPER_TOKEN": "<domo_developer_token>",
          "DOMO_HOST": "<instance-name.domo.com>"
        }
      }
   ```

### Obtaining a Domo Developer Token

[Follow these steps](https://domo-support.domo.com/s/article/360042934494?language=en_US) to generate an access token.

## Running the Server

Start the MCP server:

```
python domo.py
```

You can test the MCP server using the inspector by running

```
npx @modelcontextprotocol/inspector python3 domo.py
```

## Available MCP Tools

The following MCP tools are available:

1. **get_dataset_metadata(dataset_id: str)** - Get metadata for a DataSet
2. **get_dataset_schema(dataset_id: str)** - Get the schema for a DataSet
3. **query_dataset(dataset_id: str, query: str)** - Query a DataSet with SQL
4. **search_datasets(query: str)** - Search for a DataSet by name to get its id
5. **list_roles()** - List all roles in the Domo instance
6. **create_role(name: str, from_role_id: int, description: Optional[str])** - Create a new role in the Domo instance
7. **list_role_authorities(role_id: int)** - List authorities for a specific role in the Domo instance

## Example Usage with LLMs

When used with LLMs that support the MCP protocol, this server enables natural language interaction with your Domo environment:

- "How many orders in my Example Sales dataset have critical priority?"
- "Who owns the Customer Invoice dataset?"
- "Show me the logs for the last 3 hours in my Activity Log dataset."

## Troubleshooting

### Connection Issues

- Ensure your Domo host is correct and doesn't include `https://` prefix
- Verify your personal access token has the necessary permissions and hasn't expired
- Run the included test script: `python test_connection.py`

## Security Considerations

- Your Domo developer token provides direct access to your instance
- Secure your `.env` file and never commit it to version control
- Run this server in a secure environment