The MCP server for Marketing Cloud Engagement includes several tools for managing data extensions. This table includes information about tools related to managing data extensions.
important: Destructive tools can change or delete data. Before you use a destructive tool, ask the AI assistant to perform a trial run of the task or show you the code that it plans to execute.
| Tool Name | Description | Required Scopes |
|---|---|---|
sfmc_bulk_upsert_data_extension_rows |
Async bulk upsert rows into a Data Extension.<br><br><b>Special considerations</b>: Asynchronous | Data | Data Extensions | Write |
sfmc_bulk_upsert_data_event_rows |
Batch upsert multiple rows into a Data Extension by external key. | Data | Data Extensions | Write |
sfmc_clear_data_extension_data |
Clear all data from a data extension.<br><br><b>Special considerations</b>: 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.<br><br><b>Special considerations</b>: Asynchronous | Data | Data Extensions | Write |
sfmc_delete_data_extension |
Delete a data extension.<br><br><b>Special considerations</b>: Destructive | Data | Data Extensions | Write |
sfmc_get_bulk_job_status |
Get the status of an async bulk data job.<br><br><b>Special considerations</b>: Read-only, open-world | Data | Data Extensions | Read |
sfmc_get_bulk_job_results |
Get the results of a completed async bulk data job.<br><br><b>Special considerations</b>: Read-only, open-world | Data | Data Extensions | Read |
sfmc_get_data_extension |
Retrieve a data extension.<br><br><b>Special considerations</b>: Read-only, open-world | Data | Data Extensions | Read |
sfmc_get_data_extension_fields |
Retrieve the field definitions for a data extension.<br><br><b>Special considerations</b>: Read-only, open-world | Data | Data Extensions | Read |
sfmc_get_data_extension_folders |
List all data extension folders.<br><br><b>Special considerations</b>: Read-only, open-world | Data | Data Extensions | Read |
sfmc_get_data_extension_link |
Create and output a direct link to a data extension in the Marketing Cloud Engagement UI.<br><br><b>Special considerations</b>: Read-only, open-world | (No permissions required) |
sfmc_get_data_extensions |
Search and list data extensions.<br><br><b>Special considerations</b>: Read-only, open-world | Data | Data Extensions | Read |
sfmc_get_data_extensions_by_category |
Retrieve all data extensions in a folder.<br><br><b>Special considerations</b>: Read-only, open-world | Data | Data Extensions | Read |
sfmc_query_data_extension_rows |
Query rows from a Data Extension by its external key, with filtering and pagination.<br><br><b>Special considerations</b>: Read-only, open-world | Data | Data Extensions | Read |
sfmc_retrieve_data_extension_record |
Retrieve a single row from a data extension.<br><br><b>Special considerations</b>: Read-only, open-world | Data | Data Extensions | Read |
sfmc_update_data_extension |
Update the properties of a data extension.<br><br><b>Special considerations</b>: Destructive | Data | Data Extensions | Write |
sfmc_update_data_extension_field_async |
Update the fields in a data extension asynchronously.<br><br><b>Special considerations</b>: 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 |