Airflow + oterm: Complete MCP Integration

Airflow is a MCP server that A MCP Server that connects to Apache Airflow using official python client..

When integrated with oterm, you can:

• List all available DAGs in Airflow
• Manually trigger a DAG run
• Get DAG run history and status

This guide provides step-by-step instructions to set up Airflow in oterm, including configuration, examples, and troubleshooting.

What You'll Achieve

After completing this setup:

• Airflow will be fully integrated and operational
• You can use Airflow tools directly in oterm
• All Airflow capabilities will be available for your workflows
• Access to 5 different tools

Prerequisites

Before starting, ensure you have:

• Airflow webserver host URL
• Airflow authentication username
• Airflow authentication password
• oterm installed and configured
• Compatible operating system (CLI (Terminal))

Installation

Step 1: Install Airflow

Configuration

Step 2: Configure oterm

1. Open oterm settings
2. Navigate to MCP server configuration
3. Add Airflow server with appropriate settings
4. Save and restart if needed

Examples

Once configured, you can use Airflow in oterm:

Pipeline Monitoring

undefined

Ask oterm: "Check status of all DAGs and recent failures"

Expected Result: undefined

Manual DAG Execution

undefined

Ask oterm: "Trigger monthly_report DAG with date parameter"

Expected Result: undefined

Troubleshooting Failed Tasks

undefined

Ask oterm: "Show failed tasks in data_pipeline and their error logs"

Expected Result: undefined

Testing Your Setup

1. Launch oterm
2. Verify Airflow is available in the tools list
3. Test basic Airflow functionality

Troubleshooting

Common Issues

Connection Refused

Symptoms: Failed to connect to Ollama

Cause: Ollama service is not running

Solution:

• Start Ollama with ollama serve
• Check if Ollama is running on the default port (11434)

Tool Not Found

Symptoms: Model does not use the tool, Tool execution failed

Cause: MCP server not configured correctly or crashed

Solution:

• Check the config.json for syntax errors
• Verify the MCP server command works independently in the terminal
• Ensure the model supports tool calling (e.g., llama3.1)

Airflow not appearing in oterm

Symptoms: Server not listed, Tools not available

Cause: Configuration or installation issue

Solution:

• Verify configuration syntax
• Check Airflow installation
• Restart oterm
• Check logs for error messages

Next Steps

Now that Airflow is integrated with oterm:

• Explore all Airflow capabilities through oterm
• Check out other MCP servers that work with oterm
• Join the MCP community for tips and support
• Consider contributing to Airflow development

Need Help?

• Search for Airflow documentation
• Check the oterm MCP guide
• Join the MCP community discussions