Add to Docker Desktop
Version 4.43 or later needs to be installed to add the server automatically
Tools
| Name | Description |
|---|---|
batch_get_asset_property_aggregates | Get aggregated values for multiple asset properties. |
batch_get_asset_property_value | Get the current values for multiple asset properties. |
batch_get_asset_property_value_hist | Get the historical values for multiple asset properties. |
convert_multiple_timestamps | Convert multiple Unix epoch timestamps to human-readable format. This tool converts multiple timestamps at once, useful for processing API responses that contain several timestamp fields. |
convert_unix_timestamp | Convert Unix epoch timestamp to human-readable format. This tool provides accurate timestamp conversion to prevent AI agents from making conversion errors when interpreting Unix timestamps from API responses. |
create_bulk_import_schema | Construct and validate a bulk import schema. |
create_timestamp_range | Create a formatted timestamp range from start and end timestamps. This tool formats a range of timestamps for display, useful for showing training periods, evaluation periods, or other time ranges. |
describe_action | Describe an action in AWS IoT SiteWise. Retrieves detailed information about a specific action, including its definition, payload, target resource, execution time, and resolution details. |
describe_asset | Retrieve information about an asset. |
describe_asset_model | Retrieve information about an asset model. |
describe_bulk_import_job | Get detailed information about a specific bulk import job in AWS IoT SiteWise. This function retrieves comprehensive details about a bulk import job including its configuration, status, progress, error information, and execution statistics. |
describe_computation_model | Describe a computation model in AWS IoT SiteWise. Retrieves detailed information about a specific computation model, including its configuration, data bindings, status, and metadata. |
describe_computation_model_execution_summary | Describe a computation model execution summary in AWS IoT SiteWise. This tool intelligently determines whether to use resolve parameters based on the computation model configuration: - For Asset Model Level Configuration: Uses resolve parameters if provided to get execution summary for specific assets - For Asset Level Configuration: Ignores resolve parameters as they're not needed (already tied to specific assets) **Smart Optimization**: If you know the configuration type, provide it via the `configuration_type` parameter to avoid an additional API call to describe_computation_model for type detection. |
describe_default_encryption_config | Retrieve information about the default encryption configuration for your AWS account. |
describe_execution | Describe an execution in AWS IoT SiteWise. Retrieves detailed information about a specific execution, including execution details, status, timestamps, target resource information, and execution results. This provides comprehensive information about the execution process. |
describe_gateway | Retrieve information about a gateway. |
describe_gateway_capability_config | Retrieve information about a gateway capability configuration. |
describe_logging_options | Retrieve the current AWS IoT SiteWise logging options. |
describe_storage_configuration | Retrieve information about the storage configuration for your AWS account. |
describe_time_series | Retrieve information about a time series (data stream). |
execute_query | Execute comprehensive SQL queries against AWS IoT SiteWise data using the executeQuery API. The AWS IoT SiteWise query language supports SQL capabilities including: - Views: asset, asset_property, raw_time_series, latest_value_time_series, precomputed_aggregates - SQL clauses: SELECT, FROM, WHERE, GROUP BY, ORDER BY, HAVING, LIMIT - Functions: Aggregation, date/time, string, mathematical, conditional - Operators: Comparison, logical, arithmetic, pattern matching (LIKE) - JOIN operations: JOIN, LEFT JOIN, UNION (prefer implicit joins for performance) Available Views and Schema (From Official AWS Documentation): ASSET VIEW: Contains information about the asset and model derivation - asset_id (string), asset_name (string), asset_description (string) - asset_model_id (string), parent_asset_id (string), asset_external_id (string) - asset_external_model_id (string), hierarchy_id (string) ASSET_PROPERTY VIEW: Contains information about the asset property's structure - asset_id (string), property_id (string), property_name (string), property_alias (string) - property_external_id (string), asset_composite_model_id (string), property_type (string) - property_data_type (string), int_attribute_value (integer), double_attribute_value (double) - boolean_attribute_value (boolean), string_attribute_value (string) RAW_TIME_SERIES VIEW: Contains the historical data of the time series - asset_id (string), property_id (string), property_alias (string), event_timestamp (timestamp) - quality (string), boolean_value (boolean), int_value (integer), double_value (double), string_value (string) LATEST_VALUE_TIME_SERIES VIEW: Contains the latest value of the time series - asset_id (string), property_id (string), property_alias (string), event_timestamp (timestamp) - quality (string), boolean_value (boolean), int_value (integer), double_value (double), string_value (string) PRECOMPUTED_AGGREGATES VIEW: Contains automatically computed aggregated asset property values - asset_id (string), property_id (string), property_alias (string), event_timestamp (timestamp) - quality (string), resolution (string), sum_value (double), count_value (integer) - average_value (double), maximum_value (double), minimum_value (double), stdev_value (double) Complete SQL Function Reference (From AWS IoT SiteWise User Guide): DATE/TIME FUNCTIONS: - DATE_ADD( unit, value, date): Add time to date (e.g., DATE_ADD(DAY, 7, event_timestamp)) - DATE_SUB( unit, value, date): Subtract time from date (e.g., DATE_SUB( YEAR, 2, event_timestamp)) - TIMESTAMP_ADD( unit, value, timestamp): Add time to timestamp - TIMESTAMP_SUB(unit, value, timestamp): Subtract time from timestamp - NOW( ): Current timestamp (supported, but use TIMESTAMP_ADD/SUB for math operations) - TIMESTAMP literals: Use TIMESTAMP '2023-01-01 00:00:00' for specific dates - CAST(expression AS TIMESTAMP): Convert string to timestamp Note: NOW() IS supported. When doing math on NOW() or any timestamp, use TIMESTAMP_ADD/TIMESTAMP_SUB functions rather than +/- operators. TYPE CONVERSION FUNCTIONS: - TO_DATE(integer): Convert epoch milliseconds to date - TO_DATE(expression, format): Convert string to date with format - TO_TIMESTAMP(double): Convert epoch seconds to timestamp - TO_TIMESTAMP(string, format): Convert string to timestamp with format - TO_TIME(int): Convert epoch milliseconds to time - TO_TIME(string, format): Convert string to time with format - CAST(expression AS data_type): Convert between BOOLEAN, INTEGER, TIMESTAMP, DATE, STRING, etc. AGGREGATE FUNCTIONS: - AVG(expression): Average value - COUNT(expression): Count rows (COUNT(*) is supported) - MAX(expression): Maximum value - MIN(expression): Minimum value - SUM(expression): Sum values - STDDEV(expression): Standard deviation - GROUP BY expression: Group results - HAVING boolean-expression: Filter grouped results IMPORTANT LIMITATIONS: - Window functions, CTEs (WITH clauses), DISTINCT, SELECT *, and ILIKE are NOT supported SUPPORTED FEATURES: - CASE statements (CASE WHEN...THEN...ELSE...END pattern) ARE supported - COUNT(*) IS supported (only SELECT * is blocked) - Use implicit JOINs for better performance when possible |
get_asset_property_aggregates | Get aggregated values for an asset property. |
get_asset_property_value | Get the current value for the given asset property. |
get_asset_property_value_history | Get the history of an asset property's values. |
get_current_timestamp | Get the current Unix timestamp and formatted time. This tool provides the current timestamp in both Unix epoch format and human-readable format, useful for reference when working with timestamps. Returns: Dictionary containing current timestamp information |
get_interpl_asset_property_values | Get interpolated values for an asset property for a specified time interval. |
get_metadata_transfer_job | Get details of a metadata transfer job. |
get_sitewise_server_mode | Get the current SiteWise server mode and available capabilities. This tool helps users understand what operations are available and provides guidance for enabling write operations if needed. Returns: Dictionary containing server mode information and capabilities |
list_actions | List actions for a specific target resource in AWS IoT SiteWise. Retrieves a paginated list of actions associated with a specific target resource. You can filter by resolved resource and control pagination. |
list_asset_model_properties | Retrieve a paginated list of properties associated with an asset model. |
list_asset_models | Retrieve a paginated list of summaries for all asset models. |
list_assets | Retrieve a paginated list of asset summaries. |
list_associated_assets | Retrieve a paginated list of associated assets. |
list_bulk_import_jobs | List bulk import jobs in AWS IoT SiteWise. This function retrieves a paginated list of bulk import job summaries with optional filtering by job status. Each job summary includes basic information like job ID, name, status, and timestamps. |
list_computation_model_data_binding_usages | Find computation models that use a given resource in data binding. This API helps you find computation models which are bound to a given resource: - Asset model (fetch all computation models where any of this asset model's properties are bound) - Asset (fetch all computation models where any of this asset's properties are bound) - Asset model property (fetch all computation models where this property is bound) - Asset property (fetch all computation models where this property is bound) |
list_computation_model_resolve_to_resources | List computation model resolve to resources in AWS IoT SiteWise. Retrieves a paginated list of resources that a computation model resolves to. This shows the specific assets or other resources that are associated with the computation model through resolve-to relationships. |
list_computation_models | List computation models in AWS IoT SiteWise. Retrieves a paginated list of computation models in your AWS account. You can filter by computation model type and control pagination. |
list_executions | List executions for a specific target resource in AWS IoT SiteWise. Retrieves a paginated list of executions that occurred after performing execute actions on the specified target resource. This shows the progress status, error information, and execution details for training actions, inference schedules, and other action types. |
list_gateways | Retrieve a paginated list of gateways. |
list_metadata_transfer_jobs | List metadata transfer jobs. |
list_time_series | Retrieve a paginated list of time series (data streams). |