Skip to main content
Glama
nikhil-ganage

MCP Server Airflow Token

update_connection

Modify Airflow connection parameters such as host, port, credentials, or schema by specifying the connection ID to maintain data pipeline configurations.

Instructions

Update a connection by ID

Input Schema

TableJSON Schema
NameRequiredDescriptionDefault
conn_idYes
conn_typeNo
hostNo
portNo
loginNo
passwordNo
schemaNo
extraNo

Implementation Reference

  • Registers the update_connection tool (along with other connection tools) in the get_all_functions list used for MCP tool registration.
    def get_all_functions() -> list[tuple[Callable, str, str, bool]]:
        """Return list of (function, name, description, is_read_only) tuples for registration."""
        return [
            (list_connections, "list_connections", "List all connections", True),
            (create_connection, "create_connection", "Create a connection", False),
            (get_connection, "get_connection", "Get a connection by ID", True),
            (update_connection, "update_connection", "Update a connection by ID", False),
            (delete_connection, "delete_connection", "Delete a connection by ID", False),
            (test_connection, "test_connection", "Test a connection", True),
        ]
  • The main handler function for the update_connection tool. It constructs an update request from the provided parameters and calls the Airflow ConnectionApi to patch the connection.
    async def update_connection(
        conn_id: str,
        conn_type: Optional[str] = None,
        host: Optional[str] = None,
        port: Optional[int] = None,
        login: Optional[str] = None,
        password: Optional[str] = None,
        schema: Optional[str] = None,
        extra: Optional[str] = None,
    ) -> List[Union[types.TextContent, types.ImageContent, types.EmbeddedResource]]:
        update_request = {}
        if conn_type is not None:
            update_request["conn_type"] = conn_type
        if host is not None:
            update_request["host"] = host
        if port is not None:
            update_request["port"] = port
        if login is not None:
            update_request["login"] = login
        if password is not None:
            update_request["password"] = password
        if schema is not None:
            update_request["schema"] = schema
        if extra is not None:
            update_request["extra"] = extra
    
        response = connection_api.patch_connection(
            connection_id=conn_id, update_mask=list(update_request.keys()), connection_request=update_request
        )
        return [types.TextContent(type="text", text=str(response.to_dict()))]

Latest Blog Posts

MCP directory API

We provide all the information about MCP servers via our MCP API.

curl -X GET 'https://glama.ai/api/mcp/v1/servers/nikhil-ganage/mcp-server-airflow-token'

If you have feedback or need assistance with the MCP directory API, please join our Discord server