mcp/aws-iot-sitewise-mcp-server repository overview

⁠AWS IoT SiteWise MCP Server

Industrial IoT asset management.

What is an MCP Server?⁠

⁠MCP Info

⁠Image Building Info

⁠Available Tools (41)

---

⁠Tools Details

⁠Tool: batch_get_asset_property_aggregates

Get aggregated values for multiple asset properties.

---

⁠Tool: batch_get_asset_property_value

Get the current values for multiple asset properties.

---

⁠Tool: batch_get_asset_property_value_hist

Get the historical values for multiple asset properties.

---

⁠Tool: 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.

---

⁠Tool: 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.

---

⁠Tool: create_bulk_import_schema

Construct and validate a bulk import schema.

---

⁠Tool: 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.

---

⁠Tool: 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.

---

⁠Tool: describe_asset

Retrieve information about an asset.

---

⁠Tool: describe_asset_model

Retrieve information about an asset model.

---

⁠Tool: 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.

---

⁠Tool: 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.

---

⁠Tool: 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.

---

⁠Tool: describe_default_encryption_config

Retrieve information about the default encryption configuration for your AWS account.

---

⁠Tool: 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.

---

⁠Tool: describe_gateway

Retrieve information about a gateway.

---

⁠Tool: describe_gateway_capability_config

Retrieve information about a gateway capability configuration.

---

⁠Tool: describe_logging_options

Retrieve the current AWS IoT SiteWise logging options.

---

⁠Tool: describe_storage_configuration

Retrieve information about the storage configuration for your AWS account.

---

⁠Tool: describe_time_series

Retrieve information about a time series (data stream).

---

⁠Tool: 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 Parameters|Type|Description -|-|- query_statement|string|SQL query statement to execute against AWS IoT SiteWise data max_results|integer optional|The maximum number of results to return (1-10000) next_token|string optional|The token to be used for the next set of paginated results region|string optional|AWS region

---

⁠Tool: get_asset_property_aggregates

Get aggregated values for an asset property.

---

⁠Tool: get_asset_property_value

Get the current value for the given asset property.

---

⁠Tool: get_asset_property_value_history

Get the history of an asset property's values.

---

⁠Tool: 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

⁠Tool: get_interpl_asset_property_values

Get interpolated values for an asset property for a specified time interval.

---

⁠Tool: get_metadata_transfer_job

Get details of a metadata transfer job.

---

⁠Tool: 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

⁠Tool: 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.

---

⁠Tool: list_asset_model_properties

Retrieve a paginated list of properties associated with an asset model.

---

⁠Tool: list_asset_models

Retrieve a paginated list of summaries for all asset models.

---

⁠Tool: list_assets

Retrieve a paginated list of asset summaries.

---

⁠Tool: list_associated_assets

Retrieve a paginated list of associated assets.

[...]