Orchestra MCP Server

Official

by orchestra-hq

Overview Schema Source Related Servers Discussions Admin

Python

Remote

List assets

list_assets

Read-only

Retrieve a paginated list of assets for the workspace the credential resolves to.

Instructions

Retrieve a paginated list of assets for the workspace the credential resolves to.

Assets can be filtered by type, integration, integration account, workspace, database, schema, status, or asset ID. By default, results are sorted by created_in_integration in descending order.

Input Schema

Name	Required	Description	Default
`page`	No	Page number. Must be greater than or equal to 1.
`status`	No	Filter by status. Comma-separated values are supported where the parameter accepts multiple values.
`asset_ids`	No	Filter by asset IDs. Provide comma-separated UUIDs for multiple values.
`page_size`	No	Number of items per page. Defaults to 50; maximum 100.
`asset_type`	No	Filter by asset type. Comma-separated values are supported.
`integration`	No	Integration identifier.
`schema_name`	No	Filter by schema name.
`sort_column`	No	Column used to sort assets.	created_in_integration
`workspace_id`	No	Filter by integration workspace ID.
`database_name`	No	Filter by database name.
`sort_direction`	No	Sort direction.	desc
`X-Orchestra-Account-Id`	No	Act on this account rather than the one the credential resolves to. Omit it to use the credential's own account. An API key is issued to a single account, so it may only name that account; an OAuth token may name any account its grant covers.
`integration_account_id`	No	Filter by the account identifier in the integration.

Output Schema

Name	Required	Description	Default
No arguments

Schema Changelog

Changes observed during successful MCP inspections.

Changed1 schema field changedv2026.10.12-0Oct 14, 2026

changedInput schema / properties / integration / anyOf

Previous value: -[
-  {
-    "enum": [
-      "AIRBYTE_CLOUD",
-      "AIRBYTE_SERVER",
-      "AIRFLOW",
-      "ARCH",
-      "ALTERYX_SERVER",
-      "ANTHROPIC",
-      "AWS_EC2",
-      "AWS_ECS",
-      "AWS_EMR",
-      "AWS_EKS",
-      "AWS_FIREHOSE",
-      "AWS_GLUE",
-      "AWS_LAMBDA",
-      "AWS_RDS",
-      "AWS_REDSHIFT",
-      "AWS_S3",
-      "AWS_BEDROCK",
-      "AWS_SAGEMAKER",
-      "AWS_SECRETS_MANAGER",
-      "AWS_SES",
-      "AWS_STEP_FUNCTIONS",
-      "AZURE",
-      "AZURE_CONTAINER_APPS",
-      "AZURE_DATA_FACTORY",
-      "AZURE_DATA_LAKE_STORAGE",
-      "AZURE_KEY_VAULT",
-      "AZURE_KUBERNETES_SERVICE",
-      "AZURE_LOGIC_APPS",
-      "AZURE_SYNAPSE_ANALYTICS",
-      "AZURE_VM",
-      "BAUPLAN",
-      "BOOMI",
-      "CDATA",
-      "CENSUS",
-      "CLICKHOUSE",
-      "COALESCE",
-      "COUNT",
-      "DATADOG",
-      "DATABRICKS",
-      "DATAPROC",
-      "DATAZEN",
-      "DBT",
-      "DBT_CORE",
-      "DLT",
-      "DOMO",
-      "DREMIO",
-      "DUCKDB",
-      "EMAIL",
-      "ESTUARY",
-      "ETLEAP",
-      "FABRIC",
-      "FABRIC_SYNAPSE",
-      "FIVETRAN",
-      "FORTRA",
-      "GCP_BIG_QUERY",
-      "GCP_CLOUD_RUN",
-      "GCP_CLOUD_FUNCTIONS",
-      "GCP_CLOUD_STORAGE",
-      "GCP_DATAFLOW",
-      "GCP_DATAFORM",
-      "GCP_DATASTREAM",
-      "GCP_LOOKER",
-      "GKE",
-      "GITHUB_ACTIONS",
-      "GOOGLE_CLOUD",
-      "HEVO",
-      "HEX",
-      "HIGHTOUCH",
-      "HTTP",
-      "HUBSPOT",
-      "INFORMATICA_IICS",
-      "INFORMATICA_POWERCENTER",
-      "KAFKA",
-      "KEBOOLA",
-      "KLEENE",
-      "LIGHTDASH",
-      "LINUX_SSH",
-      "MARIADB",
-      "MATILLION",
-      "MATILLION_ETL",
-      "METAPLANE",
-      "MICROSOFT_TEAMS",
-      "MICROSTRATEGY",
-      "MONGODB",
-      "MOTHERDUCK",
-      "MYSQL",
-      "N8N",
-      "NIMBLE",
-      "NOTION",
-      "OMNI",
-      "OPEN_AI",
-      "ORCHESTRA",
-      "PARADIME",
-      "PAGER_DUTY",
-      "PINECONE",
-      "PORTABLE",
-      "POSTGRES",
-      "POWER_AUTOMATE",
-      "POWER_BI",
-      "PREFECT_CLOUD",
-      "PYTHON",
-      "QLIK",
-      "QLIK_REPLICATE",
-      "QUICKBOOKS",
-      "RENDER",
-      "RIVERY",
-      "RUDDERSTACK",
-      "SALESFORCE",
-      "SAP",
-      "SFTP",
-      "SHAREPOINT",
-      "SIGMA",
-      "SISENSE",
-      "SLACK",
-      "SNOWFLAKE",
-      "SNOWPLOW",
-      "SODA",
-      "SQL_MESH",
-      "SQL_SERVER",
-      "STITCH",
-      "STREAMKAP",
-      "TABLEAU_CLOUD",
-      "TALEND_CLOUD",
-      "THOUGHTSPOT",
-      "TOBIKO_CLOUD",
-      "WEAVIATE",
-      "WEBHOOK",
-      "WELD",
-      "WINDOWS_SSH"
-    ],
-    "type": "string"
-  },
-  {
-    "type": "null"
-  }
-]New value: +[
+  {
+    "enum": [
+      "AIRBYTE_CLOUD",
+      "AIRBYTE_SERVER",
+      "AIRFLOW",
+      "ARCH",
+      "ALTERYX_SERVER",
+      "ANTHROPIC",
+      "AWS_EC2",
+      "AWS_ECS",
+      "AWS_EMR",
+      "AWS_EKS",
+      "AWS_FIREHOSE",
+      "AWS_GLUE",
+      "AWS_LAMBDA",
+      "AWS_RDS",
+      "AWS_REDSHIFT",
+      "AWS_S3",
+      "AWS_BATCH",
+      "AWS_BEDROCK",
+      "AWS_SAGEMAKER",
+      "AWS_SECRETS_MANAGER",
+      "AWS_SES",
+      "AWS_STEP_FUNCTIONS",
+      "AZURE",
+      "AZURE_CONTAINER_APPS",
+      "AZURE_DATA_FACTORY",
+      "AZURE_DATA_LAKE_STORAGE",
+      "AZURE_KEY_VAULT",
+      "AZURE_KUBERNETES_SERVICE",
+      "AZURE_LOGIC_APPS",
+      "AZURE_SYNAPSE_ANALYTICS",
+      "AZURE_VM",
+      "BAUPLAN",
+      "BOOMI",
+      "CDATA",
+      "CENSUS",
+      "CLICKHOUSE",
+      "COALESCE",
+      "COUNT",
+      "DATADOG",
+      "DATABRICKS",
+      "DATAPROC",
+      "DATAZEN",
+      "DBT",
+      "DBT_CORE",
+      "DLT",
+      "DOMO",
+      "DREMIO",
+      "DUCKDB",
+      "EMAIL",
+      "ESTUARY",
+      "ETLEAP",
+      "FABRIC",
+      "FABRIC_SYNAPSE",
+      "FIVETRAN",
+      "FORTRA",
+      "GCP_BIG_QUERY",
+      "GCP_CLOUD_RUN",
+      "GCP_CLOUD_FUNCTIONS",
+      "GCP_CLOUD_STORAGE",
+      "GCP_DATAFLOW",
+      "GCP_DATAFORM",
+      "GCP_DATASTREAM",
+      "GCP_LOOKER",
+      "GKE",
+      "GITHUB_ACTIONS",
+      "GOOGLE_CLOUD",
+      "HEVO",
+      "HEX",
+      "HIGHTOUCH",
+      "HTTP",
+      "HUBSPOT",
+      "INFORMATICA_IICS",
+      "INFORMATICA_POWERCENTER",
+      "KAFKA",
+      "KEBOOLA",
+      "KLEENE",
+      "LIGHTDASH",
+      "LINUX_SSH",
+      "MARIADB",
+      "MATILLION",
+      "MATILLION_ETL",
+      "METAPLANE",
+      "MICROSOFT_TEAMS",
+      "MICROSTRATEGY",
+      "MONGODB",
+      "MOTHERDUCK",
+      "MYSQL",
+      "N8N",
+      "NIMBLE",
+      "NOTION",
+      "OMNI",
+      "OPEN_AI",
+      "ORCHESTRA",
+      "PARADIME",
+      "PAGER_DUTY",
+      "PINECONE",
+      "PORTABLE",
+      "POSTGRES",
+      "POWER_AUTOMATE",
+      "POWER_BI",
+      "PREFECT_CLOUD",
+      "PYTHON",
+      "QLIK",
+      "QLIK_REPLICATE",
+      "QUICKBOOKS",
+      "RENDER",
+      "RIVERY",
+      "RUDDERSTACK",
+      "SALESFORCE",
+      "SAP",
+      "SFTP",
+      "SHAREPOINT",
+      "SIGMA",
+      "SISENSE",
+      "SLACK",
+      "SNOWFLAKE",
+      "SNOWPLOW",
+      "SODA",
+      "SQL_MESH",
+      "SQL_SERVER",
+      "STITCH",
+      "STREAMKAP",
+      "TABLEAU_CLOUD",
+      "TALEND_CLOUD",
+      "THOUGHTSPOT",
+      "TOBIKO_CLOUD",
+      "TYPESAFE",
+      "WEAVIATE",
+      "WEBHOOK",
+      "WELD",
+      "WINDOWS_SSH"
+    ],
+    "type": "string"
+  },
+  {
+    "type": "null"
+  }
+]

Changed1 schema field changedv0.1.1Sep 30, 2026

changedInput schema / properties / integration / anyOf

Previous value: -[
-  {
-    "enum": [
-      "AIRBYTE_CLOUD",
-      "AIRBYTE_SERVER",
-      "AIRFLOW",
-      "ARCH",
-      "ALTERYX_SERVER",
-      "ANTHROPIC",
-      "AWS_EC2",
-      "AWS_ECS",
-      "AWS_EMR",
-      "AWS_EKS",
-      "AWS_FIREHOSE",
-      "AWS_GLUE",
-      "AWS_LAMBDA",
-      "AWS_RDS",
-      "AWS_REDSHIFT",
-      "AWS_S3",
-      "AWS_BEDROCK",
-      "AWS_SAGEMAKER",
-      "AWS_SECRETS_MANAGER",
-      "AWS_SES",
-      "AWS_STEP_FUNCTIONS",
-      "AZURE",
-      "AZURE_CONTAINER_APPS",
-      "AZURE_DATA_FACTORY",
-      "AZURE_DATA_LAKE_STORAGE",
-      "AZURE_KEY_VAULT",
-      "AZURE_KUBERNETES_SERVICE",
-      "AZURE_LOGIC_APPS",
-      "AZURE_SYNAPSE_ANALYTICS",
-      "AZURE_VM",
-      "BAUPLAN",
-      "BOOMI",
-      "CDATA",
-      "CENSUS",
-      "CLICKHOUSE",
-      "COALESCE",
-      "COUNT",
-      "DATADOG",
-      "DATABRICKS",
-      "DATAPROC",
-      "DATAZEN",
-      "DBT",
-      "DBT_CORE",
-      "DLT",
-      "DOMO",
-      "DREMIO",
-      "DUCKDB",
-      "EMAIL",
-      "ESTUARY",
-      "ETLEAP",
-      "FABRIC",
-      "FABRIC_SYNAPSE",
-      "FIVETRAN",
-      "FORTRA",
-      "GCP_BIG_QUERY",
-      "GCP_CLOUD_RUN",
-      "GCP_CLOUD_FUNCTIONS",
-      "GCP_CLOUD_STORAGE",
-      "GCP_DATAFLOW",
-      "GCP_DATAFORM",
-      "GCP_DATASTREAM",
-      "GCP_LOOKER",
-      "GKE",
-      "GITHUB_ACTIONS",
-      "GOOGLE_CLOUD",
-      "HEVO",
-      "HEX",
-      "HIGHTOUCH",
-      "HTTP",
-      "HUBSPOT",
-      "INFORMATICA_IICS",
-      "INFORMATICA_POWERCENTER",
-      "KAFKA",
-      "KEBOOLA",
-      "KLEENE",
-      "LIGHTDASH",
-      "LINUX_SSH",
-      "MATILLION",
-      "MATILLION_ETL",
-      "METAPLANE",
-      "MICROSOFT_TEAMS",
-      "MICROSTRATEGY",
-      "MONGODB",
-      "MOTHERDUCK",
-      "MYSQL",
-      "N8N",
-      "NIMBLE",
-      "NOTION",
-      "OMNI",
-      "OPEN_AI",
-      "ORCHESTRA",
-      "PARADIME",
-      "PAGER_DUTY",
-      "PINECONE",
-      "PORTABLE",
-      "POSTGRES",
-      "POWER_AUTOMATE",
-      "POWER_BI",
-      "PREFECT_CLOUD",
-      "PYTHON",
-      "QLIK",
-      "QLIK_REPLICATE",
-      "QUICKBOOKS",
-      "RENDER",
-      "RIVERY",
-      "RUDDERSTACK",
-      "SALESFORCE",
-      "SAP",
-      "SFTP",
-      "SHAREPOINT",
-      "SIGMA",
-      "SISENSE",
-      "SLACK",
-      "SNOWFLAKE",
-      "SNOWPLOW",
-      "SODA",
-      "SQL_MESH",
-      "SQL_SERVER",
-      "STITCH",
-      "STREAMKAP",
-      "TABLEAU_CLOUD",
-      "TALEND_CLOUD",
-      "THOUGHTSPOT",
-      "TOBIKO_CLOUD",
-      "WEAVIATE",
-      "WEBHOOK",
-      "WELD",
-      "WINDOWS_SSH"
-    ],
-    "type": "string"
-  },
-  {
-    "type": "null"
-  }
-]New value: +[
+  {
+    "enum": [
+      "AIRBYTE_CLOUD",
+      "AIRBYTE_SERVER",
+      "AIRFLOW",
+      "ARCH",
+      "ALTERYX_SERVER",
+      "ANTHROPIC",
+      "AWS_EC2",
+      "AWS_ECS",
+      "AWS_EMR",
+      "AWS_EKS",
+      "AWS_FIREHOSE",
+      "AWS_GLUE",
+      "AWS_LAMBDA",
+      "AWS_RDS",
+      "AWS_REDSHIFT",
+      "AWS_S3",
+      "AWS_BEDROCK",
+      "AWS_SAGEMAKER",
+      "AWS_SECRETS_MANAGER",
+      "AWS_SES",
+      "AWS_STEP_FUNCTIONS",
+      "AZURE",
+      "AZURE_CONTAINER_APPS",
+      "AZURE_DATA_FACTORY",
+      "AZURE_DATA_LAKE_STORAGE",
+      "AZURE_KEY_VAULT",
+      "AZURE_KUBERNETES_SERVICE",
+      "AZURE_LOGIC_APPS",
+      "AZURE_SYNAPSE_ANALYTICS",
+      "AZURE_VM",
+      "BAUPLAN",
+      "BOOMI",
+      "CDATA",
+      "CENSUS",
+      "CLICKHOUSE",
+      "COALESCE",
+      "COUNT",
+      "DATADOG",
+      "DATABRICKS",
+      "DATAPROC",
+      "DATAZEN",
+      "DBT",
+      "DBT_CORE",
+      "DLT",
+      "DOMO",
+      "DREMIO",
+      "DUCKDB",
+      "EMAIL",
+      "ESTUARY",
+      "ETLEAP",
+      "FABRIC",
+      "FABRIC_SYNAPSE",
+      "FIVETRAN",
+      "FORTRA",
+      "GCP_BIG_QUERY",
+      "GCP_CLOUD_RUN",
+      "GCP_CLOUD_FUNCTIONS",
+      "GCP_CLOUD_STORAGE",
+      "GCP_DATAFLOW",
+      "GCP_DATAFORM",
+      "GCP_DATASTREAM",
+      "GCP_LOOKER",
+      "GKE",
+      "GITHUB_ACTIONS",
+      "GOOGLE_CLOUD",
+      "HEVO",
+      "HEX",
+      "HIGHTOUCH",
+      "HTTP",
+      "HUBSPOT",
+      "INFORMATICA_IICS",
+      "INFORMATICA_POWERCENTER",
+      "KAFKA",
+      "KEBOOLA",
+      "KLEENE",
+      "LIGHTDASH",
+      "LINUX_SSH",
+      "MARIADB",
+      "MATILLION",
+      "MATILLION_ETL",
+      "METAPLANE",
+      "MICROSOFT_TEAMS",
+      "MICROSTRATEGY",
+      "MONGODB",
+      "MOTHERDUCK",
+      "MYSQL",
+      "N8N",
+      "NIMBLE",
+      "NOTION",
+      "OMNI",
+      "OPEN_AI",
+      "ORCHESTRA",
+      "PARADIME",
+      "PAGER_DUTY",
+      "PINECONE",
+      "PORTABLE",
+      "POSTGRES",
+      "POWER_AUTOMATE",
+      "POWER_BI",
+      "PREFECT_CLOUD",
+      "PYTHON",
+      "QLIK",
+      "QLIK_REPLICATE",
+      "QUICKBOOKS",
+      "RENDER",
+      "RIVERY",
+      "RUDDERSTACK",
+      "SALESFORCE",
+      "SAP",
+      "SFTP",
+      "SHAREPOINT",
+      "SIGMA",
+      "SISENSE",
+      "SLACK",
+      "SNOWFLAKE",
+      "SNOWPLOW",
+      "SODA",
+      "SQL_MESH",
+      "SQL_SERVER",
+      "STITCH",
+      "STREAMKAP",
+      "TABLEAU_CLOUD",
+      "TALEND_CLOUD",
+      "THOUGHTSPOT",
+      "TOBIKO_CLOUD",
+      "WEAVIATE",
+      "WEBHOOK",
+      "WELD",
+      "WINDOWS_SSH"
+    ],
+    "type": "string"
+  },
+  {
+    "type": "null"
+  }
+]

First observedv0.1.0Sep 26, 2026

TDQS

B3.4/5.0

Behavior3/5

Does the description disclose side effects, auth requirements, rate limits, or destructive behavior?

The readOnlyHint annotation already declares this is a safe read, so the description's remaining job is add-on context. It usefully contributes pagination behavior and the default sort column/direction, but says nothing about the cross-account X-Orchestra-Account-Id override or result limits, which it could have surfaced.

Agents need to know what a tool does to the world before calling it. Descriptions should go beyond structured annotations to explain consequences.

Conciseness5/5

Is the description appropriately sized, front-loaded, and free of redundancy?

Two tight sentences: purpose and scope first, then filter dimensions, then default ordering. Every clause carries information and nothing is padded.

Shorter descriptions cost fewer tokens and are easier for agents to parse. Every sentence should earn its place.

Completeness4/5

Given the tool's complexity, does the description cover enough for an agent to succeed on first attempt?

With an output schema present, return values need not be described, and the read-only annotation covers the safety profile. The description covers scope, filters, and sorting, leaving only the account-override header unmentioned, which is a minor gap.

Complex tools with many parameters or behaviors need more documentation. Simple tools need less. This dimension scales expectations accordingly.

Parameters3/5

Does the description clarify parameter syntax, constraints, interactions, or defaults beyond what the schema provides?

Schema description coverage is 100%, so the schema already documents every filter. The description only summarizes the filter categories and the default sort, adding no syntax or format detail beyond what the schema provides. Baseline 3 applies.

Input schemas describe structure but not intent. Descriptions should explain non-obvious parameter relationships and valid value ranges.

Purpose4/5

Does the description clearly state what the tool does and how it differs from similar tools?

States a specific verb and resource ('Retrieve a paginated list of assets') plus the scope ('for the workspace the credential resolves to'). It is clearly distinct from get_asset_by_id by virtue of being a list operation, but no sibling is named explicitly.

Agents choose between tools based on descriptions. A clear purpose with a specific verb and resource helps agents select the right tool.

Usage Guidelines2/5

Does the description explain when to use this tool, when not to, or what alternatives exist?

The description enumerates the filterable dimensions and the default sort but gives no when-to-use guidance, no when-not-to-use, and never points to get_asset_by_id for single-asset retrieval. An agent must infer the intended context from the name alone.

Agents often have multiple tools that could apply. Explicit usage guidance like "use X instead of Y when Z" prevents misuse.

Deploy Server