Data Extensions
The MCP server for Marketing Cloud Engagement includes several tools for managing data extensions. This table includes information about these tools.
Destructive tools can change or delete data. Before you use a destructive tool, ask the AI assistant to perform a dry run of the task or show you the code that it plans to execute.
| Tool Name | Description | Special Considerations | Required Scopes |
|---|---|---|---|
sfmc_clear_data_extension_data | Clear all data from a data extension. | Destructive | Data | Data Extensions | Write |
sfmc_create_data_extension | Create a data extension. | Data | Data Extensions | Write | |
sfmc_create_data_extension_field_async | Add fields to a data extension. | Asynchronous | Data | Data Extensions | Write |
sfmc_delete_data_extension | Delete a data extension. | Destructive | Data | Data Extensions | Write |
sfmc_get_data_extension | Retrieve a data extension by ID. | Read-only, open-world | Data | Data Extensions | Read |
sfmc_get_data_extension_fields | Retrieve the field definitions for a data extension. | Read-only, open-world | Data | Data Extensions | Read |
sfmc_get_data_extension_folders | List all data extension folders. | Read-only, open-world | Data | Data Extensions | Read |
sfmc_get_data_extension_link | Creates and outputs a direct link to a data extension in the Marketing Cloud Engagement UI. | Read-only, open-world | (No permissions required) |
sfmc_get_data_extensions | Search and list data extensions. | Read-only, open-world | Data | Data Extensions | Read |
sfmc_get_data_extensions_by_category | Retrieve all data extensions in a folder. | Read-only, open-world | Data | Data Extensions | Read |
sfmc_retrieve_data_extension_record | Retrieve a single row from a data extension. | Read-only, open-world | Data | Data Extensions | Read |
sfmc_update_data_extension | Update the properties of a data extension. | Destructive | Data | Data Extensions | Write |
sfmc_update_data_extension_field_async | Update the fields in a data extension asynchronously. | Destructive, asynchronous | Data | Data Extensions | Write |
sfmc_upsert_data_extension_record | Update a row into a data extension, or insert a row if it doesn’t exist. | Data | Data Extensions | Write |