What is Domo Mcp Server

Domo MCP Server is a Model Context Protocol (MCP) server designed to connect with the Domo API, enabling users to interact with Domo datasets programmatically.

Use cases

Use cases for Domo MCP Server include querying datasets for specific information, retrieving dataset metadata for analysis, and enabling natural language queries through integration with LLMs.

How to use

To use Domo MCP Server, clone the repository, set up a Python virtual environment, install the required dependencies, configure your .env file with your Domo instance details, and run the server using ‘python domo.py’. Optionally, test the connection with ‘python test_connection.py’.

Key features

Key features of Domo MCP Server include retrieving metadata about Domo datasets, executing SQL queries on datasets, and providing tools for dataset schema and search functionalities.

Where to use

Domo MCP Server can be used in data analytics, business intelligence, and application development environments where integration with Domo’s data services is required.

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
2. Navigate to the cloned directory
3. Install the required packages:

   pip install -r requirements.txt
   

4. Add configuration to your VS Code settings:

   {
     "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>"
     }
   }
   

5. Ensure the server is running

Local Docker Setup

1. Clone this repository
2. Navigate to the cloned directory
3. Build the Docker image:

    docker build -t domo-mcp-server .
   

4. Add configuration to your VS Code settings:

Obtaining a Domo Developer Token

Follow these steps 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