Alibaba Cloud RDS OpenAPI MCP Server

Instructions

Batch retrieves database information for multiple RDS instances.
Args:
    region_id: The region ID of the RDS instance.
    db_instance_ids: List of DB instance identifiers (e.g., ["rm-uf6wjk5****", "db-instance-01"])
Returns:
    list[dict]: A list of dictionaries containing database information for each instance.

Implementation Reference

• src/alibabacloud_rds_openapi_mcp_server/server.py:884-908 (handler)

  The main handler function implementing the 'describe_db_instance_databases' tool. It takes region_id and a list of db_instance_ids, calls the Alibaba Cloud RDS SDK's DescribeDatabases API in a loop for each instance, and returns a list of responses with database info for each.

  @mcp.tool(annotations=READ_ONLY_TOOL)
  async def describe_db_instance_databases(
          region_id: str,
          db_instance_ids: list[str]
  ) -> list[dict]:
      """
      Batch retrieves database information for multiple RDS instances.
      Args:
          region_id: The region ID of the RDS instance.
          db_instance_ids: List of DB instance identifiers (e.g., ["rm-uf6wjk5****", "db-instance-01"])
      Returns:
          list[dict]: A list of dictionaries containing database information for each instance.
      """
      try:
          client = get_rds_client(region_id)
          db_instance_databases = []
          for db_instance_id in db_instance_ids:
              request = rds_20140815_models.DescribeDatabasesRequest(
                  dbinstance_id=db_instance_id
              )
              response = await client.describe_databases_async(request)
              db_instance_databases.append(response.body.to_map())
          return db_instance_databases
      except Exception as e:
          raise e