domo-mcp-server
3.2
If you are the rightful owner of domo-mcp-server and would like to certify it and/or have it hosted online, please leave a comment on the right or send an email to henry@mcphub.com.
A Model Context Protocol (MCP) server that connects to Domo API.
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
- Clone this repository
- Navigate to the cloned directory
- Install the required packages:
pip install -r requirements.txt - 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>" } } - Ensure the server is running
Local Docker Setup
- Clone this repository
- Navigate to the cloned directory
- Build the Docker image:
docker build -t domo-mcp-server . - Add configuration to your VS Code settings:
"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 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:
- get_dataset_metadata(dataset_id: str) - Get metadata for a DataSet
- get_dataset_schema(dataset_id: str) - Get the schema for a DataSet
- query_dataset(dataset_id: str, query: str) - Query a DataSet with SQL
- search_datasets(query: str) - Search for a DataSet by name to get its id
- list_roles() - List all roles in the Domo instance
- create_role(name: str, from_role_id: int, description: Optional[str]) - Create a new role in the Domo instance
- 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
.envfile and never commit it to version control - Run this server in a secure environment
