create_connection
Create Airflow connections by specifying connection ID, type, and authentication details to enable data pipeline integrations.
Instructions
Create a connection
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| conn_id | Yes | ||
| conn_type | Yes | ||
| extra | No | ||
| host | No | ||
| login | No | ||
| password | No | ||
| port | No | ||
| schema | No |
Input Schema (JSON Schema)
{
"properties": {
"conn_id": {
"title": "Conn Id",
"type": "string"
},
"conn_type": {
"title": "Conn Type",
"type": "string"
},
"extra": {
"anyOf": [
{
"type": "string"
},
{
"type": "null"
}
],
"default": null,
"title": "Extra"
},
"host": {
"anyOf": [
{
"type": "string"
},
{
"type": "null"
}
],
"default": null,
"title": "Host"
},
"login": {
"anyOf": [
{
"type": "string"
},
{
"type": "null"
}
],
"default": null,
"title": "Login"
},
"password": {
"anyOf": [
{
"type": "string"
},
{
"type": "null"
}
],
"default": null,
"title": "Password"
},
"port": {
"anyOf": [
{
"type": "integer"
},
{
"type": "null"
}
],
"default": null,
"title": "Port"
},
"schema": {
"anyOf": [
{
"type": "string"
},
{
"type": "null"
}
],
"default": null,
"title": "Schema"
}
},
"required": [
"conn_id",
"conn_type"
],
"type": "object"
}
Implementation Reference
- src/airflow/connection.py:41-70 (handler)The main handler function for the 'create_connection' tool. It constructs a connection dictionary from input parameters and uses the Airflow ConnectionApi to create the connection, returning the response as text content.async def create_connection( conn_id: str, conn_type: str, 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]]: connection_request = { "connection_id": conn_id, "conn_type": conn_type, } if host is not None: connection_request["host"] = host if port is not None: connection_request["port"] = port if login is not None: connection_request["login"] = login if password is not None: connection_request["password"] = password if schema is not None: connection_request["schema"] = schema if extra is not None: connection_request["extra"] = extra response = connection_api.post_connection(connection_request=connection_request) return [types.TextContent(type="text", text=str(response.to_dict()))]
- src/airflow/connection.py:11-20 (registration)The get_all_functions in connection.py registers the create_connection tool (along with others) by including its tuple: (create_connection, "create_connection", "Create a connection", False). This list is imported and used in src/main.py to add tools to the MCP server.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), ]